• 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:
  • AS/400: Finding a list of objects which are locked by users.

    We have Visions Mimix global software replicating data from Source to 3 target servers. There are few users running sql queries etc on the target servers causing objects to go into lock and this results in objects going into replication error. Is it possible to get a list of objects which are...

    JohnsonMumbai1,365 pointsBadges:
  • Need help on the prompt override program

    Hello, I have command which when prompted asks for a confirmation and if a 'Y' is given then 2 more parameters appear retrieving data from a data area. I have setup the program override program and the confirm parameter on the command as a 'key parameter', the parms that retrieve data from the data...

    yaazhisai260 pointsBadges:
  • Is Mimix running from within our RPG/CL program?

    How can I know that Mimix is running from within my RPG/CL program. I have written a monitor for Mimix, and I need to be able to know when Mimix is not running so I can stop the monitor. Our operations team cannot use the Portal, politics.

    JonChilds15 pointsBadges:
  • Reading a file in Reverse Order in CL Program

    ) In CL program how can we read a data base file in reverse order.

    Chraghuveer25 pointsBadges:
  • SQL 9010 Error when using RUNSQLSTM

    I have a CL program having the following RUNSQLSTM RUNSQLSTM  SRCFILE(AMBDEV/MSRCAMB) SRCMBR(AMBJARRVK)            COMMIT(*NONE)                            AMBJARRVK is a SQL member file in MSRCAMB source file having this SQL statment DELETE FROM GDPF WHERE...

    MaldaTabbah5 pointsBadges:
  • CL Program: Assing select to the variable

    Hi, I have some trouble with my CL Program. Please help me. I have a table like: System name User name Job name tstname1c TOMCATTOMT TOMCATTOM1 ....................... ....................... ....................... tstname1a BOBCATBOBB BOBCATBOB2 ....................... ..........................

    Motorbreath70 pointsBadges:
  • How to retrieve all the records using CL program?

    How do I retrieve all the records using CL program?

    vishwaraj60 pointsBadges:
  • Retrieve system date and time on AS/400

    How do I retrieve the current system date, time and name using CL program on AS400? Pls share the CL source.  

    Mani1017130 pointsBadges:
  • Retrieve Journal Receiver Attributes

    We have different Environments on our Productions system with separate Journals and their corresponding Journal Receivers. Using a CL Program, I want to retrieve the Journal Receiver Attributes of all the currently attached Journal Receiver in the system.

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