• Stop AS/400 job purge program

    I have a requirement where i have to submit a PGM in batch. This program is a SQLRPGLE program that deletes record from a file. I have scheduled it at 8pm and I want to stop its purging at 10pm. This means this job will run for 2 hours every day after which it should be stopped. How can I achieve...

    Supriyoas400190 pointsBadges:
  • AS/400 batch jobs

    In a PF, if we delete a record then how to insert a new record at the same place in that PF? Any logic or code? A batch job is taking a lot of time to run,found that it is going into loop and wrapping up so how to skip that loop and process the job without changing the code? In which scenario C D I...

    chowas400615 pointsBadges:
  • In RPGLE, how to fetch the particular record in 1 lakh record without a key

    Hi, I have some 1 lakh record. I need to fetch from 250th record with no key in it. What is the possible optimed way we can achieve it.

    KirManoj15 pointsBadges:
  • DB2/400-AS/400

    File:Student ................. SID     . Sname . ................. 1       .  Chow . 2       .  Ratna. ................. I want to update sname= Rotna(2nd position a=o) using substring? Please help the query or correct the below query: UPDATE STUDENT SET SNAME=SUBSTR(SNAME, 2,1)...

    chowas400615 pointsBadges:
  • Increase TCP/IP buffer size for AS/400

    I want to increase TCP send and receive buffer size in AS/400. How can I do that?

    Maltaf65 pointsBadges:
  • Remove library from all library lists

    We've stopped using a vendor's product that has been here since we first became a 400 shop 12+ years ago. The vendor's libraries have found their way into hundreds of job descriptions across the system. Is there an easy way to remove the entries for these libraries from all the job descriptions?...

    ERICPELL5 pointsBadges:
  • Can I install V5R3M0?

    Hi friends, based on this Hardware I can install the version V5R3M0 on this machine? Display Processor Information                                                                                System type . . . . . . . ....

    PutzGrilla800 pointsBadges:
  • Word 2003/2007 VBScript fails in 2010 (background printing) – help!

    Hi script wizards, I cobbled this together from info on the web but I don't know hardly anything about scripting - I'm a COBOL programmer! Works with word 2003/2007 (has been for some time) but not in Word 2010. The background printing commands fail (e.g. objWord.Options.PrintBackground = False)....

    LindenR5 pointsBadges:
  • Need a COBOL QMHRTVM Example

    Does anyone have a code snippet they would be willing to share that demonstrates the parameter setup and the call for the API QMHRTVM? I am lousy with API's but I need to incorporate this one into two of my SQLCBLLE Programs.

    FCARPENTER200 pointsBadges:
  • Play recorded macro with CL program

    How can I play a recorded macro with in a CL program?

    Messam140 pointsBadges:
  • Changing Spool File Status in AS/400

    Hello, is there a way you could change the spool file status using a command? For e.g I have a few spools which are currently in the 'SAV', 'HLD' state. How would we be able to convert all of this to a RDY state. A blanket conversion of all spools in an OUTQ state is also acceptable. Any help would...

    lesserT15 pointsBadges:
  • How to convert character date to numeric date

    Hi All, I have a character date field ('DD/MM/YYYY'). Now I want to convert into ISO numeric format in free format. Thanks

    97834441841,400 pointsBadges:
  • Passing Parameters into a clle program from a Menu.

    Hello I am wondering if there is a way to pass parameters from a menu into a CLLE program, whereby the parameter list could be variable. Most Menu options will pass one parameter to the CLLE program; namely the program name that will be called if security is passed. (PARM 1) But, there are some...

    Piano520 pointsBadges:
  • WRKDBF and undelete function V5R4

    We use wrkdbf and its global undelete and on demand (option 8) does not work with V5R4 (thanks IBM) I have applied the patch from the undel2 library but it does not work on production libraries or do multiple records at a time. It appears to be using my QTEMP and once that is created it does not...

    Superjk15 pointsBadges:
  • Programmatically place outq on hold when empty

    Hi, I have been tasked with writing a CL program that will be run every night that releases a held Outq and allows the contents to go through then, put the outq back on hold once there are no more spool files in it. Is there an API or something I can use in a CL program that will check for an empty...

    Ronnieb345 pointsBadges:
  • System Administration guide lines

    Hi, I'm very new to the administration on IBM i. I have many years of Developmet experience on AS/400 but now my job involves more on admin front than the development. I request you to please help me with some useful tips and guidelines along with some good links on this. Thanks Ram

    ten20081,150 pointsBadges:
  • SAVOBJ command to copy files to a save file

    I am trying to use the SAVOBJ command to copy files to a save file. Is there a way to add to the save file and not write over it with each SAVOBJ call? I know I can create a list of files and send all of them to one save file but I would rather just add to the save file if possible. Thanks!

    Nward35 pointsBadges:
  • Installing V5R4 to V6R1

    Hi, I want to know what are all the problems will appear when I'm installing the V6R1. Now I'm using V5R4. Please let me know the benefits also. Thanks in advance Prabhu

    Sprabhu15 pointsBadges:
  • Can a join logical file only select highest value when multiple records are found?

    Have a file of students (stu # as key), want to join to enrollment file & get the most recent activity date (could be many records for one student or one record for a student). Can a join logical file be created that would give me that? SQL can select via max operand. Does DDS have something...

    BillGood15 pointsBadges:
  • Directory command is not working

    Call qcmdexc parm('CPYTOIMPF FROMfile(mylib/myfile) TOSTMF(/home/test/test.txt)') It is not working I think because of the missing ' I tried to fix it with a hex value of x'7D' but the run SQL procedure didn't accept it

    Blueye20 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