• 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,735 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,365 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.

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