• Execute start macro in AS/400 session in a CL PROGRAM

    How to execute start macro in AS/400 session in a CL program?

    Messam280 pointsBadges:
  • OVRDBF -POSITION

    Hi,     How to position the record in CL based on the key value? I have tried this.my CL program is as follows... ***************************  PGM                                                    DCLF       FILE(PMS90/EMPMST90)                      ...

    22917560 pointsBadges:
  • CPF5149 error message when file is opened in update mode

    In my CL program I have an OPNQRYF on a file with option as (*UPD) OvrDbf File(FDFILE) Share(*Yes) OpnQryF File(FDFILE) Option(*Upd) + QrySlt('STATUS *NE "A" *And + FREQ *GT "0" *And (FDSDTP *LT "' *Cat &CurDat *Cat '") *And (MATURITY *GT "' *Cat &CurDat *Cat '") ') After this I am calling...

    RamvishakRamesh2,505 pointsBadges:
  • Run time Error in CL Program

    Hi Team, I am getting a run time error (While Calling the program) in the following code. PGM        PARM(&A &B) DCL        VAR(&A) TYPE(*DEC) LEN(2 0) DCL        VAR(&B) TYPE(*DEC) LEN(2 0) DCL        VAR(&TOTAL) TYPE(*DEC) LEN(4 0)...

    ankit2002770 pointsBadges:
  • Decimal data error

    Hi all, I have a batch job which calls a CL program which internally have a call to another RPG program, after submission of the job I am getting decimal data where.... I'm adding the value of the Zoned decimal variable to Packed decimal variable. But when I run the RPG program individually there...

    Sai4AS4001,420 pointsBadges:
  • AS400 – Editing an FTP script in CL

    I have written a CL routine to send a file via FTP using the OVFDBF commands for INPUT and OUTPUT. This works fine, however I need to be able to edit my FTP script file somehow in order to change the name of the file in the PUT command. Clearly you cannot pass a variable to this but is there anyway...

    phil75565 pointsBadges:
  • CL program entery missing in JOBLOG

    Hi all, I have a CLP program C1 which is using SBMJOB inside the program to run 5 different batch jobs, and when i submit C1. I am getting Spool entries only for the internal submit jobs submitted by C1, but there is no entry for C1. But I want to get the starting time and ending time of my batch...

    Sai4AS4001,420 pointsBadges:
  • Multiple submission of a JOB

    Hi every one, Requirement 1.a : I have a CL program (ISC) which reads/process 10 Million records from an input file IF with some conditions and writes to a Output file OF1 with the help a RPG program R1. Now my requirement is to improve the performance of this read process by running/submitting...

    Sai4AS4001,420 pointsBadges:
  • STRPCCMD – How to avoid black DOS screen popup

    I have a STRPCCMD command in my CL program to open an IFS folder which has the .CSV files. STRPCCMD PAUSE(*NO) PCCMD(''''start " " "\'+%trim(P@SYSNAME)+%xlate('/':'':DFTPATH)+'"'')' P@Sysname has the system name. I can see a popup DOS window but getting message the path not found. I am able to see...

    RamvishakRamesh2,505 pointsBadges:
  • OVRDBF not showing all file records

    In CL program, declared a file FILE01 and read some records, later using OVRDBF accessed another file FILE02. Still I'm getting records of FILE01 only but not FILE02. Why? Thanks Venkat

    VENKYAS40075 pointsBadges:
  • How to write a CL program to place RUNQRY in the application menu

    My management has asked me to disable the ability of users to access command line from an application by limiting capabilities *YES. I need to write a CL that will allow me to place RUNQRY into the application menu and need help creating the CL program. Can anyone assist?

    Chardyjr45 pointsBadges:
  • 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:

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