• How to pass numeric data to CL program from AS/400 command line

    Hi All, I want to pass numeric data of length (8 0) to my CL program while calling from AS/400 command line but program is not receiving correct value into the program. Can anyone please help me how to pass numeric data?

    Mohan K695 pointsBadges:
  • Use of variable CPYTOIMPF command

    How do I use a variable as the target file in CPYTOIMPF in a CL program?

    tonycs10 pointsBadges:
  • IIF function

    I have 2 tables: First table: 1- name 2- position 3- nationality 4- visa No. Second table: 1- Position 2- No of visas. 3- No of used visas. 4- No of remaining visas. But I want to use IIF function when add new position in first table increases the no of used visas in the second table automatically....

    khalid1155 pointsBadges:
  • Suppress CPI8072 message when using SNDNETSPLF

    We have an interactive CL program that uses SNDNETSPLF to send a spool file to a second outq on the same AS400 running V5R4. After the operation has completed the user receives the message and has to press Enter before the job will continue. Is there a way to suppress this message without...

    Oldtonew135 pointsBadges:
  • Increase size of output file in CL used in DSPJRN command

    I am trying to increase the size of the output file in a CL used in the DSPJRN command. I need to set the OUTFILFMT to *TYPE5. My OUTFILE is being created in QTEMP  - so OUTPUT(*outfile) OUTFILE(QTEMP/DCSTAUDWK1) How can I do this? DSPJRN JRN(&JOURNAL) FILE((DCSCIM) (DCSTCIMU) + (DCSCIU)...

    fischurder5 pointsBadges:
  • Read selective file in CL by using OVRDBF

    How do I read selective file in CL by using OVRDBF by positioning to from particular record till selective record? Lets say I have Emp (record format is REC) file which is having 10 records (rrn or key field). Now I want to read file from 2nd record till 8th  record, how can we do this with...

    hndajad195 pointsBadges:
  • Passing variables from CL to QMQRY

    Hi, I have a CL that get parameter and run QMQRY. When I run it, I get a prompt: "Type a value for variable "x" and press enter". Why I get it even though I pass the parameter? The CL: " PGM PARAM(&X) DCL VAR(&X) TYPE(*CHAR) LEN(8) STRQMQR QMQR(LIB1/QRY1) OUTPUT(*OUTFILE)...

    felixb95 pointsBadges:
  • How to delete specific spool files

    I am not that familiar with command line code as access has been restricted and converted to screen options so forgive me. The task is every month I need to delete specific spool files > 9 months old with specific form type. Originally my thoughts were to: Create formatted file to copy the five...

    Stage15 pointsBadges:
  • EPSON LQ 590 CPI issue

    Hello, I have specified 20 CPI in my CL program using override command, but the printer still prints only 15 CPI. I'm printing information on a pre-printed form hence have positioning issues due to font size. Please advise.

    umesh135 pointsBadges:
  • Retrieve SQL messages from Joblog

    Hi, I'm on 6.1 and I have RUNSQL in a CL program. The statement is 'UPDATE ...' and run's okay but I need to get the SQL MSG SQL7957 with the number of rows updated or the SQL0100 (row not found). I can get this with RCVMSG but only in debug mode. Can anyone help me? Rui

    RuiFerr15 pointsBadges:
  • DSPFD command throws message CPF3061

    I am trying to delete members from a physical file if the member size is reaced. I have written code in CL as below -> dclf file(qtemp/ehutmp) opnid efile create outfile by dspfd-> dspfd file(ehub) type(*mbrlist) output(*outfile) outfile(qtemp/ehutmp) and then read file and delete old member...

    mohit123210 pointsBadges:
  • SQL/400: Call CL program

    From stored procedure in SQL/400, I want to call the CL program. I have created the wrapper program for calling CL as SQL procedure.(qcmd). How can I pass the param with quotes to CL program? SBMJOB CMD(CALL PGM(abc) PARM('parm1' +'parm2 'prtn1')) JOB(prt1) + USER(braha1)

    Bhusha40 pointsBadges:
  • How to use read command in CL program

    How do I use read Command in CL programming?

    mahalakshmi4375 pointsBadges:
  • Delete members from multimember physical file

    I have to remove members which are were created before six months from two physical files in a single CL program if the member size is reached in physical files. I am creating outfile using DSPFD command and then deleting records that are created before 6 months. EHUBTMP and EHUPTMP will be the...

    mohit123210 pointsBadges:
  • How to get number of members in two PF in single CL program

    I want to get no of members in two multi member physical files in a one CL program using outfiles. Please give a pseudo code for this. How should I use DCLF, DSPFFD, RCVF in my CL program for getting no of members in 2 physical files, say my physical files are file1 and file 2. Please help. Thanks...

    mohit123210 pointsBadges:
  • Print data types in CL program

    We have 100 files. We want to print the Field, Field Description and Data types through a CL program. Is it possible in a CL program?

    mahalak75 pointsBadges:
  • Insert data in a PF by using a CL program

    How do I insert the data in PF by using a CL program?

    venki125965 pointsBadges:
  • How to find object’s library?

    Inside a CL, I want to know the library of the compiled object, to see if it's in a test or production library. How can I do this?

    AnnieSBMC5 pointsBadges:
  • In a single CL Program, can we read a database file more than once?

    In a single CL Program, can we read a database file more than once

    Chraghuveer25 pointsBadges:
  • *INU3 and *INU4 SWS

    I am working on an some old programs that make use of *INU3 and * INU4 indicators. From the CL program it appears they are getting set on by ''00100000' and '00010000'. Would I be correct?

    UARTJ125 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