• problem with Index rebuild

    How can I rebuild the indexes online,after trucating/moving partitions tables,so that things has not come in unstable stage and continue keep responsing on same tables. As rebuild takes several minutes. So how could I manage the things when database is online with out interuption.

    Bulandshahr0 pointsBadges:
  • Calculation at database level

    Hi! Please take a look at few rows of one table . MBRNO Readmit READMIT DATE READMIT Readmit Seq. NO DISCHARGE date NO. of days 121 1 20030101 20030105 5 2 20030105 20030115 10 3 20030202 20030218 3 4 20030218 20020220 0 The measure is count of cases. I do not want to calculate the case with...

    Meenac0 pointsBadges:
  • Create table and insert

    I have encountered a very strange situation. I have a procedure that checks if a table name exists, if it does, it drops and re-create the table, else just create it. Following is the code : SELECT COUNT(*) INTO V_TABLE_EXIST FROM USER_TABLES WHERE TABLE_NAME = 'X'; IF (V_TABLE_EXIST = 1) THEN...

    7308270 pointsBadges:
  • Crystal reports installation help-

    I am running a citrix server metaframe 1.8 with windows 2000 server and i am trying to install Crystall 8.5 on it. When I crystal on this server and try to run a report with a date and time formula it says "The remaining text does not appear to be part of the formula". Here is the code that i am...

    Nathan100 pointsBadges:
  • How-to for an RFC from a Web system

    How can I call a RFC via an SAP function from a Web system -- actually an ASP system? I know that the .COM Connector is not available in Windows XP, so I need to make some kind of interface to do this job. Does anyone have any bright ideas?

    SAPseeker0 pointsBadges:
  • iSeries and activation groups

    I have a program that is running in the default activation group. Within the various modules I use a procedure from a system service program that runs in a named activation group. At some point the application performs a RCLACTGRP *ELIGIBLE which deletes the named activation group for the service...

    Davega0 pointsBadges:
  • Changing the statement heap parameter on iSeries

    Hi, I would like to know how to change the statement heap parameter DB2 (stmtheap) on the AS/400. I tried the command GET DATABASE CONFIGURATION FOR database-alias (giving alias name as the AS/400 server name) but it returns the error "SQL0901N The SQL statement failed because of a non-severe...

    Sbkhole0 pointsBadges:
  • Random Number Generation – RPGLE

    I need to generate a random number between 1 and 100 in RPGLE. Does anyone have an algorithm to do it?

    Hex29a0 pointsBadges:
  • Mainframe to AS/400

    Any guidelines or manuals are available to convert Mainframe COBOL TO AS/400 COBOL JCL TO CL CICSS TO CICS/400

    Nitin1000 pointsBadges:
  • City Based Website Portal

    I am working on project of starting a city based Portal. and was looking for ideas, which can make it success. the city is an industrial hub of Punjab (a state in india) Please suggest the contents.

    Andesh0 pointsBadges:
  • mobile number directory service

    I?m looking for good mobile number directory service for our sales force. Does anyone use one they recommend??

    Allie0 pointsBadges:
  • SQL Clustering

    SQL Server 2000 As far as performance tuning, where can I find statistics or could you offer your opinion in the following scenario. Which offers better performance, running One server in Active mode and another in inactive mode, each with four processors or Running both servers in active mode,...

    Krismop0 pointsBadges:
  • Service.exe Process

    I have a w2k pro computer that is experiencing an incredible slowness, when I check the runing processes, I find service.exe is eating up over 90% of the cpu, starving out any other application/process. Has anybody come accross this problem and knows how to fix it? any suggestion would be...

    Senomango0 pointsBadges:
  • How do I Create a dynamic DLL in visual Basic 6

    I created a DLL and 7 projects use this DLL. The problem I am having is, I have to compile all the projects with the DLL every time I make a change to the DLL. This tells me it is static, but I want it to be dynamic. I do not know if I am doing something wrong in my compile of the DLL, or if the...

    Cevonne5 pointsBadges:
  • Please help

    Yet another question, and an example of my code. i have pulled some of the information that i need for the flat file by connecting to 3 tables, then sending the information i have chosen from the table into columns. i need to connect to another 2set of tables to add further information to my first...

    Alex88090 pointsBadges:
  • Looking for a new start

    Hi! I am a long time AS400 programmer. Because, of the lack of marketing for the AS400--the job opportunities have plumitted. I would like to revamp me career--but, don't know what direction to go. Can someone stir me in the right direction?

    Openanewdoor0 pointsBadges:
  • Oracle Partition

    Hi, I have a query that looks like select * from fact, dim_time where fact.my_dt = dim_time.clndr_dt and fact.my_dt between '1-jan-2005' and '10-mar-2005' this query eliminates partitions which are based on week. Now, if i replace the literal strings in the between clause with some kind of...

    Arunj740 pointsBadges:
  • Problems in DDL trigger usage

    Problems in DDL trigger usage. I have a problem in the usage of DDL trigger. I created a DDL trigger on a user schema on "AFTER CREATE" event to catch the creation script of the all database objects using the system variables ora_sysevent, ora_dict_obj_name, ora_dict_obj_type,ora_dict_obj_owner....

    Asrcmurthy0 pointsBadges:
  • Replacement for DFU

    We are looking for a product to replace DFU on our AS/400. I have found one product called DBU. In the past I had received information about Hawkeye. Does anybody have any information about this product or company? Thank you

    GreenFrog0 pointsBadges:
  • Using Linux on an older computer to telecommute

    I have an older computer running Win98 at home and want to use it to telecommute to occasionally. I have a cable modem so speed isn?t an issue, but my OS is. Win98 is not compatible with my company?s Webmail. A techie at lunch suggested that a combo of Linux and Mozilla might be able to handle it,...

    CalendarGirl0 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following