1
  • How can I find the list of temporary indexes created by the system of my iSeries AS/400 server?

    How can I find the list of temporary indexes created on my iSeries server? Can I also find the file name and key fields on which the indexes are created. I have a query running fast on one server which has not been IPLed for quite some time. Same query takes much longer on a server which was...

    JohnsonMumbai1,480 pointsBadges:
  • Unable to restore file from a Save file as the job which was saving the file onto the save file was accidently killed mid way through the backup.

    I'm unable to restore a file from the save file as it was not completely saved as mentioned. Is it possible to restore part of the file from the Save file? The actual file was later deleted before a restore could be fired from the save file which got created. (Though the save file was incomplete as...

    JohnsonMumbai1,480 pointsBadges:
  • SQL optimization in COBOL400

    I am using an SQL in Cobol 400 to delete around 100 million records out of 200 million records based on a date. What is the best way to delete this much data in one stretch? The file has key as date. My sql would look like Delete from FileA where Date < 'some date'

    anuppdas105 pointsBadges:
  • Why use OVRDBF before OPNQRYF in AS/400?

    Why we need to use OVRDBF file before doing OPNQRYF? What is it (OVRDBF) doing actually?

    Sureyz2,825 pointsBadges:
  • Want to find a string in CL source file(ABOUT 400 CL SOURCE ) and replace with other String.

    I Have a problem For replacing a particular Hard coded Libray name from my all CL source file(about 400) by some other hardcoded library name.For e.g There is a library name Used in many CL source file with ABCD(lib name).I want to change all occurances in each CL source file By DEFG.

    fsddfsdfsd60 pointsBadges:
  • We had a security audit and one of the requirement was to raise an alarm whenever any user does a data extract.

    Is it possible to raise a alert whenever a user does a data extract using ODBC or DTF.Using CL program or any other way.

    JohnsonMumbai1,480 pointsBadges:
1

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.

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

Following