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

ravula755 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

as400dev620 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,825 pointsBadges: