• While calling a command via a CL program exposes my command line.

    While calling a command via a CL program exposes my command line. Is it possible to hide the command line while executing the command via cl. I need to do this as iam executing the cl with adopted authority.

    JohnsonMumbai1,480 pointsBadges:
  • Save IXS CL program

    Does anyone out there have a CL program which saves all the objects on an IXS?

    WoodEngineer8,225 pointsBadges:
  • How to retrieve the jobq in which my current job is running in CL?

    I have a CL program which will run as a SBMJOB. Now I want to see whether it is running in QBATCH jobq. If not in QBATCH, I have to resubmit it into QBATCH. How I can do it in CL?

    JustinA40 pointsBadges:
  • Rename file in CL

    Hi all. I need to check if the file exist, and rename it. t How do I check file existing in CL? Thank you.

    Larisagas265 pointsBadges:
  • Displaying on the message line through CL

    Thru CL how can I display a message on the message line?

    22917560 pointsBadges:
  • CL date extraction in AS/400

    I want to take out date value from today to last 7 days in CL command. Kindly help

    Sangay635 pointsBadges:
  • FNDSTRPDM – how do i find joblog

    I am using FNDSTRPDM command in my CL program for each file/field and running through RPG programs if the string is found. If I specify the wrong file (QRPGLESRC) and the program is found in QRPGSRC, I get the error PDM0055, which i can monitor. However, if the program is found and the string is...

    Dhaloo25 pointsBadges:
  • Accessing OUTQs and writers in AS/400

    I have been tasked with writing a CL to accept the following incoming parameters USER NAME, OUTQ NAME, LIBRARY NAME, & RETURN CODE.

    UARTJ230 pointsBadges:
  • Compiling a CL program

    I have a CL pgm in that i used the OVRDSPF command. Now i changed the display file. I'm sure i need to compile the RPG programs that are using the display file. Have a doubt if i need to compile the CL pgm or not?

    Kvrs8070 pointsBadges:
  • What date is returned after midnight rollover on AS/400 job queue?

    We have nightly jobs that are queued up to release at 23:59 each night. Depending on how many are released at once, it may or may not make it into the jobq before midnight. The main CL program calls a second CL program after midnight. The called CL program uses the RTVJOBA command to get date....

    Canuhp235 pointsBadges:
  • CL program for measuring tape backup

    i need an example of cl program that reads tape volume and executes the commands in their ok.

    as400tarek105 pointsBadges:
  • Using AS400 COBOL or CL Program to Call an Excel File and Pass Parameters Back and Forth from 400 to Excel Back to 400

    [html xmlns=""> I am beginning my investigation to figure out how to use either a 400/COBOL program or a CL program to call an excel spreadsheet that requires three parameters to a calculation and to return a value back to my 400/COBOL program of CL program so that I then can use that value in my...

    400Programmer185 pointsBadges:
  • CL Programming

    Hi Gurus, in cl how to write download file code.and use it in rpg? Is there any command for download file? Thanks & Regards, Sudheer

    Sudheerk9950 pointsBadges:
  • passing variable in CL Program using QMQRY and SQL

    Hi, I'm setting up a process where I can add or delete a record in a physical file. I'm using a simple CL program that runs a couple QM Queries. QMQRY - REVEALADD INSERT INTO mylib/myfile (myfile) VALUES(user) QMQRY - REVEALDLT DELETE FROM mylib/myfile WHERE myfile = '&USER' CL code...

    Bggas400160 pointsBadges:
  • How to delete data from IFS directory?

    How to write the program for deletion of data from IFS directory? Any cl program?  

    Sms121185 pointsBadges:
  • Need to write a CL program to track user logins

    HI, I WANT HOW TO WRITE A CL PROGRAMME TO KNOW A USER IS LOGGED IN OR NOT.MEANS IN A SERVER NUMBER OF USERS OR THERE SO I WANT TO FIND OUT WHICH USER IS LOGIN STATE WHICH OR NOT LOG-OFF STATE.WHEN I RUN A PGM TO PROVIDE USER NAME IT WILL SHOW THE LOGIN OR LOGOFF STATUS...

    KIRAN9SDR15 pointsBadges:
  • I want to send a DB2 file via email from AS400 to MS outlook using MMAIL/SENDMIME command.

    I want to send a DB2 file via email from AS400 to MS outlook.  I use command MMAIL/SENDMIMe inside my CL program. I've 2 issues. 1. whenever an email reaches to recipient, it attaches some .dat file which doesn't have anything in it. 2. the attachment is in notepad, it removes the readability of...

    Nutan70 pointsBadges:
  • How can I make the job generate just the higher severity messages?

    Everytime a batch job ended abnormally, it generates thousands of pages of job logs.  The jobd is set to logclpgm *no,  msg logging 4/0/*nolist. The job log has all the details of the record read between api programs.  How can I make the job generate just the higher severity messages?  

    Cmt645 pointsBadges:
  • how can i use like in cl program?

    how can i write this statment in cl program? Q -   select name from empname where name like %@name% thanks

    Engrania25 pointsBadges:
  • Download from iSeries directly to an Excel xls file – no CSV

    I need a little help! Is there anything out there that I can incorporate into a CL program that will download a database file to Excel with an xls extension so no further converting is necessary. I tried the CVTPFXLS but get Pointer not set for location referenced.

    Sillyhp35 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