• Delete 72 hours old record from a file using SQLRPGLE

    I have a file containing two fields...First one contains date with century and second one contains time in time stamp format. I want to delete 72 hours old record from this file using SQLRPGLE.

    mcasantoshrai55 pointsBadges:
  • Unreadable spool file

    Hi all, after I restore some objects on our dev machine using the backup from our prd. I did try to have a copy of the spool file as a report. I use iSeries Navigator to get it from my users spool but when double checking its content its looks like some kind of an encrypted file but I can see the...

    joverparas360 pointsBadges:
  • AS/400

    User class?

    agnieszka10 pointsBadges:
  • Duplicate records in a keyed physical file

    Would journaling over a multiple member physical file cause duplicate records? The DDS of the file does not have UNIQUE.

    Mcrews25 pointsBadges:
  • Outfile for WRKJOB command.

    HI All, I need to print all the instance of a job in some spool file or database file. Suppose we have a daily job ABCJOB. Now if I do WRKJOB ABCJOB, it will display all the jobs with date and if I select any, it will show the spool file and other options. Now what I want is instead of displaying...

    ddaswani170 pointsBadges:
  • Cursor is returning previous values in SQLRPGLE

    I have an SQLRPGLE program which accepts the SQL statement as an input parameter to the program from an RPGLE program. (The SQL is entered by user .) My intention is to validate the SQL and make a prepare statement out of it, and then initiates a Fetch Next from C1 into a :wSTR. Check for the...

    RamvishakRamesh2,505 pointsBadges:
  • How to check DBI version on IBMi v7r1

    Hi I would like to know how to check the version of DBI that we are running. We have IBMi v7r1 and zend server 5.6.0.

    jailall101735 pointsBadges:
  • Validate date in COBOL/400

    I have date in yyyymmdd format. I want to validate if it lies between a particular period of 2 years let b/w 1 Jan 2012 to 5 April 2014, in COBOL/400.... Please help me as the intrinsic function like that in COBOL are not working in this case. Thanks.

    praveen21210 pointsBadges:
  • Examples of AS/400 create alias in Crystal Reports

    Can someone give me an example of Crystal Reports create alias using AS/400 file? Thanks! Tony

    tcuccaro40 pointsBadges:
  • QTEMP file not removed

    In my CLP I created a file in QTEMP using CRTDUPOBJ. I then use this file in a few CL programs and a couple of RPG programs. Also, in OPNQRYF in the CL programs. At the end of the job stream my file is not removed. I have used QTEMP before without a problem; I'm wondering if using it in OPNQRYF has...

    Rpgldb30 pointsBadges:
  • Certification RPG

    Hi, I am planning to do certification in AS/400. I don't have much coding knowledge. I have been working on support project till date. Can any one please guide me the process, how much is the fee & any suggestions which you would like to mention in specific? Thanks, Sruthi

    juslikdat1440 pointsBadges:
  • New record can not be added

    We a have ticketing system application but it has stop adding new records. No new message to expand files. Does anyone have any help?

    abar1425 pointsBadges:
  • Panasonic CF-H2 Toughbook

    I am running Client Access Ver5.5 on a Panasonic CF-H2 Toughbook. When I initiate the built-in scanner on the Toughbook to scan a barcode, the device beeps signifying a good scan, but the Client Access session is not displaying the data. If I initiate the scan on a barcode in note pad, it displays...

    Bro17920 pointsBadges:
  • User profile being disabled

    We have one user that is having issues with her profile being disabled. This only happens on Mondays, she signs in once, and it tells her she is disabled. I enable her, only to have this happen again the next Monday. I am not sure how to track this or where to look to correct. Thanks

    Amoore30 pointsBadges:
  • RPGLE

    I need to change primary and secondary file into full procedure file. Can anybody help me?

    eductn70 pointsBadges:
  • Single page subfile with filter

    I have a single page subfile which has two fields, 'Account' and 'description'. The subfile is displayed from File1 which has account(key) but doesn't have description. I am fetching description from another file based on the 'account'. Now in the subfile I want to include a filter or a 'position...

    RamvishakRamesh2,505 pointsBadges:
  • Question is about ILERPG

    I have been given a module name and I'm asked to find out the name of the service programs which included that module. Is there any possible way to find it?

    JSDHFKJHA335 pointsBadges:
  • Validate SQL and display the output

    I have a screen where the user can enter an SQL script, I need to validate whether the SQL query is a valid one, if so then display the output on to the screen. I am planning to execute a SQL prepare statement out of the script entered and then use SQLCOD to determine whether it is valid or not....

    RamvishakRamesh2,505 pointsBadges:
  • Run Oracle Procedure in SSRS dataset

    Have an Oracle stored procedure that needs to run to repopulate a table. Do not need data from sp, have a separate dataset to pull from refreshed table. What I need is a way to run the sp that is acceptable to SSRS inside or outside of dataset.

    redusn19505 pointsBadges:
  • How can I direct Interactive jobs to specific subsystems?

    We have 2 interactive subsystems. One was intended for all the interactive jobs of the IT department. The other was for all non-IT users. The idea being - if necessary, the non-IT user subsystem could be ended while IT people were still logged on fixing a problem or whatever. When interactive...

    LetItBe260 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