• How to create a sort number in CL or query?

    Hi all, I already create a PF with a field name "NUMBER". I want to fill this Field "NUMBER" with a sort number like 1 2 3 4 5 6 7 Etc . Can anyone help me how to create CL programming to fill the NUMBER field with sort number like 1 2 3 4 Etc . It's almost creating a sort number in Excel . Please...

    indiesrm197315 pointsBadges:
  • Finding number of records in a file, without reading the file in CL programming

    Hi, I have an Task to do the program in CL, to find number of records in a file, but I should not read that file. Can you please tell me how to proceed?

    srivijay1320 pointsBadges:
  • CMD bound with CL program

    If I use CRTCMD command and bound it with some CLLE program then later after command creation, how I come to know with which CLLE it is bound to?

    hunshabbir72,820 pointsBadges:
  • iSeries unattended backup

    I found a while back a CL program that can run in QCTL to ran an iSeries unattended backup, I tried it but the program hanged up. Have you seen any CL programs that can run an iSeries unattended backup?

    Dalverson5 pointsBadges:
  • 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,735 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?

    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:

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