• CL program to delete dependent files

    Could any one please help me with the steps to write a CL program. I want to write a program in CL or any other language eg. RPGLE which will take physical file as an input and based on DSPDBR dependent logical files can be deleted.

    abhisheka1405 pointsBadges:
  • AS/400 Netserver

    I am trying to implement data exchange between and AS400 and a Windows server using the AS/400 NetServer (QNTC). What steps are necessary to setup and activate the connection? Where can I find examples of CL programs that do file transfers.

    RichK1151130 pointsBadges:
  • AS/400 RUNQRY: Enter Key

    This may be quiet different to the regular questions. Actually I have coded 3 RUNQRY statements with 3 QRY definitions in a CL program. Program is running fine.Thing is that ,when the control comes before each RUNQRY statement, emulator is prompting for an ENTER key. After pressing the ENTER key....

    HABBIE895 pointsBadges:
  • AS/400 QMQRY: How to pass values at runtime

    Hi, I am trying to pass file name to a QMQRY object in a CL program at run time.I was facing some error,which I posted below. I request you to kindly go through the below code & correct me to, if I am wrong. QMQRY object:         ************ 0001.00 &SELECT      0002.00 &FIELDS...

    HABBIE895 pointsBadges:
  • AS/400 QMQRY: Table Lateral Identifier Error

    Hi, I have a file.That comprises of all the file names(Only one column).Now  I am reading this file through a RPG program & passing this file name to a QMQRY object on a CL program. On the QMQRY, I'm facing the below error, as it is not accepting the '&' symbol. These are the two programs....

    HABBIE895 pointsBadges:
  • AS/400: Create a file listing object locks on an object

    This there a way to create an out file listing all object locks on a specific object? Using WRKOBJLCK I can see the jobs that have a lock on an object. I need to end these locks using a CL program. We are using ShowCase and using the command ENDSCSVR will not work because there are numerous locks...

    northwoods180 pointsBadges:
  • CL Program Error Message: Invocation offset outside range of current stack

    When my CL Program executes CPYFRMIMPF command, some times, the session was looping endlessly with error message " Invocation offset outside range of current stack" i.e MCH4426. Exact command I am executing is... CPYFRMIMPF FROMFILE(LIB1/F1) TOFILE(LIB1/F2) MBROPT(*ADD) FROMRCD(2)...

    gnani25 pointsBadges:
  • AS/400: Create a CL program using DSPOBJD

    Regarding AS/400, I need to create CL program using DSPOBJD to find the PGM starts with any alphabets as our wish.

    parthibanumapathi5 pointsBadges:
  • How to remove the AS/400 program message being displayed?

    Hi, Actually I'm getting the following program message from a CL program When I press F3 in the display file. The message is, Job 167761/AGENT105/QPADEV0018 started on 28/03/14 at 15:26:00 in subsystem Initial program ended and *SIGNOFF specified for initial menu. But I don't want to display this...

    Sureyz2,720 pointsBadges:
  • Execute start macro in AS/400 session in a CL PROGRAM

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

    Messam260 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:

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