• How to create ‘n’ number of userprofiles from CL Program

    How to create 'n' number of userprofile from CL Program?

    Lsivabe85 pointsBadges:
  • WRKQRY query

    Hi, I have a CL program which uses WRKQRY to generate a report out of it. Now I have a requirement to change a field which holds Quantity and I want to divide this by 10 to the power of another field say DecFld. ie if Quantity is 359686 and DecFld is 2, I want 359686/10**2 = 3596.86 . Is it...

    RamvishakRamesh2,505 pointsBadges:
  • Variable not found when calling a SQLRPGLE program

    Variable not found when calling a SQLRPGLE program with parameters in CL program CALL PGM(LIBXYZ/TESTRPG1) PARM(&LIBNAM &FILNAM) here LIBNAM AD FILNAM are passed with VALUES to the SQLRPGLE program and at sql statemet ie. insert INTO LIB/FILl( LIB is having the value and FILL is not getting...

    ravula725 pointsBadges:
  • CL or EXIT program to find iSeries navigator users

    How can I find iSeries navigator users? Is there any EXIT program or can I use any CL for this?

    Maltaf65 pointsBadges:
  • Display a record from a file in a loop condition in AS/400

    Hi, I need a CL program to display a record from a file in a loop condition. If a file exists, then it should display the records or else it should display the message 'file does not exist'. Please help me. The program should contain dcf,monmsg,rcvf.

    as40040010 pointsBadges:
  • How to check the submit job is completed or not?

    Hi, I need to do 1. SBMJOB PGM1 2. SBMJOB PGM2 I need to process the PGM2 only when the PGM1 is completed. I should not use the data area or file. Please help me out. Thanks Dev

    as400dev585 pointsBadges:
  • Check for program errors

    How do I check for errors after modifying a CL?

    colecollings5 pointsBadges:
  • AS/400 CL program

    Can we read and write in AS/400 CL program?

    new40080 pointsBadges:
  • STRSQL command

    Can you use the STRSQL command within an AS/400 CL program?

    Pb5410 pointsBadges:
  • Read records for a particular period in RPG

    Hi all! I have a date period in RPG as month and year like 072012 and 022013 both are character fields. I'm passing this fields from OPNQRYF in CL program to RPG. How can I read records from a master for this particular period in RPG? Surey

    Sureyz2,720 pointsBadges:
  • Help required in writing a CL program which will monitor QSYSOPR msgq for specific h/w failure msg ID’s and shoot email ?

    Hi All – Could any one help me in writing a CL program which will monitor the QSYSOPR msgq for specific h/w failure MSGID's and shoot email ? Regards, Madhu

    Madhura030 pointsBadges:
  • Deleting SAVED journal receivers

    I want to delete journal receivers in a library that have the the status of SAVED. Can anyone offer some CL code to do this in a program? Each receiver begins with AMQA and followed by 6 numerics. I guess I would write out to an outfile then read the outfile to delete the receivers.

    northwoods180 pointsBadges:
  • Show error message to user after a CPYF command ended in error in CL program

    I have a copy command in my CL program. I have specified tofile and tomember parameters. I have given CRTFILE(*NO) so that I don't want to create a source file if it is not existing. I want to show a message "Sourcefile is invalid" when the source file is not an existing one. I want to show the...

    RamvishakRamesh2,505 pointsBadges:
  • Changing user profiles in a CL program

    Since I'm not much of a programmer I was wondering if someone could offer some suggestions on three programs I need to write. My first program will need to delete the JOBD associated with the user profile in QGPL and replace it with a different JOBD. The profiles that will have to be changed will...

    northwoods180 pointsBadges:
  • Making changes in a user profile with a CL program

    I am going to need to write a CL program that will read a list downloaded from an Excel spreadsheet onto the AS/400. The CL will scan through the file that will delete the job description associated with the user profile in QGPL and will replace the deleted job description with a new JOBD that has...

    Rrbond07140 pointsBadges:
  • Column heading issue with RUNQRY in CL

    I have a CL program which has a RUNQRY. I have two input files and I have defined the result fields. I have given an expression and I have used column heading. The issue is after executing the query, if I do a RUNQRY on the outfile, I am not able to see the column headings of the defined fields....

    RamvishakRamesh2,505 pointsBadges:
  • How to write a CL program if SQL query is giving some record

    Hi, How can a CL program can be written based on some SQL query which gives some records. If SQL query is giving some records as output then using SNDEMLMSG command, how can that CL program be written? SNDEMLMSG command will send an email to specific user based on SQL query's output if any thing...

    6r1,850 pointsBadges:
  • Execute from a source member list

    I saw a colleague run something, and I know he built the user defined option (F16) "EX" in the WRKxxxPDM display, I don't know the CMD/CL routine or Syntax for the source file/type. Thanks in advance! Dan

    dinks5715 pointsBadges:
  • Program is expecting a file not used in this call

    I have 2 different environments using 2 different library lists. A user takes an option from a menu and a CL program is called with overrides to a database file and then an interactive RPG program is called. The user then exits this program and then goes to the other environment (different...

    Sofarsogood60 pointsBadges:
  • Determine if a submitted job has completed

    Hello ALL --- I have a CL program that executes a command which calls a CL utility program. The utility program submits a job that involves the building of a save file. The original CL program will then restore the contents of the save file into a library and obviously must wait until the submitted...

    mikechance81275 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.

Following