When submitting a procedure via CL program, i do not get any abnormal end message.
When submitting a procedure via CL program, i do not get any abnormal end message even though the procedure has not not completed normally, is there anyway by which we can find the cause of the failure of the completion of the procedure normally.

Answer Question   |  March 8, 2010  1:02 PM
CL programming, CL programs, CLP, Stored Procedures

SMTP users
Do all users need their own directory entry to send emails. Is there a way for anyone to signon to the system and use a CL program that sends an email message by SNDDST.

Answer Question   |  November 25, 2009  11:58 AM
CL programs, Email (systems), SMTP, SNDDST

OVRDBF AT DIFFERENT CALL LEVELS
HI ,      I am using the command  ovrdbf file(file1) tofile(file2) in the CL program and i am calling an RPG program again in that i want to override the same file(file2) to different members(using qcmdexe). how to do that?  

Answer Question   |  November 16, 2009  1:40 PM
CL programs, OVRDBF

Callin CLP with parameter
Hi, I have a CL program which needs two Parametersa as a input, when i call a pgm with values, the value are not properly passed. It gives me decimal data error. For instance i gave values as Call pgm(clpgm) Parm(’14′ ‘aaaaa’) But it takes value as F1F44040404040. Hel me out soon. Thanks in advance [...]

Answer Question   |  October 20, 2009  9:40 AM
CL programming, CL programs, DDS

Telnet CL program on AS400
Does anyone know if it is possible to write a CL or RPG program that will automate a telnet session to a second device to change data?   I have a multiple fuel controllers that I need to telnet into daily and change the current fuel price. I would like to automate this. Does any onw [...]

Answer Question   |  October 15, 2009  10:28 PM
AS/400, CL programs, Telnet

CL Program
How to create ‘n’ number of userprofile from CL Program.

Answer Question   |  September 28, 2009  12:25 PM
CL, CL programming, CL programs

OVRDBF
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

Answer Question   |  September 2, 2009  12:08 PM
CL programs, OVRDBF

How to get IP address of as400 machine in CL pgm
Hi CAn any 1 tell me how to get the IP address of the AS400 machine in CL program.Are there any API for this.I need  to pass this IP to run a java program thrugh CL.. Thankx in advance Supriyob  

Answer Question   |  October 22, 2009  11:00 AM
API, AS/400 Management, CL, CL programs

Displaying data through DSPF and CL programm.!
I would like to be able to display one record from my PF with DSP file through a CL program on my screen. I have these sources: CL program: ******************************************** QSYSPRT          1  QPADEV0021  USERNAME      pgm              DCLF       FILE(MyLib/SPOOLTMP) RCDFMT(S) +                                  OPNID(DSP)                                                                                                           DCLF       FILE(Mylib/SPOOLTEMP) RCDFMT(SPOOLTEMP) +                           OPNID(PF)                                                                                                            RCVF       DEV(*FILE) RCDFMT(SPOOLTEMP) [...]

Answer Question   |  October 11, 2009  2:07 PM
CL, CL programming, CL programs, DSPF, PF

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 submitting the [...]

Answer Question   |  July 24, 2009  9:11 PM
CL programs, CPI8072, SNDNETOBJ, SNDNETSPLF, V5R4

CL pgm required to copy data
I need to create a CL pgm to copy data from 2 files into one. The first file’s name to be copied is constant but the second file’s name changes on a daily basis. Could anyone help with the syntax required to do this? Thx

Answer Question   |  May 12, 2009  1:50 PM
CL, CL programs

How i can display or print my CL commands
I everybody, i need print or display all commands that i have inside in my CL programs sources in QCLSRC? it is possible and how? thanks everybody.

Answer Question   |  May 7, 2009  6:23 PM
AS/400, AS/400 printing, CL, CL Commands, CL programs, CLPROGRAM, iSeries

Order of files using READDIR
I am receiving multiple files and placing them in a directory on the IFS. In a CL, I open the directory OPENDIR then READDIR to process all files. It begins reading the last file written when I need it to start with the first file written. How can this be solved in a CL program?

Answer Question   |  April 28, 2009  5:41 PM
CL programs, IFS, OPENDIR, READDIR

DDS with temporary name for Physical file
Good day all ! On AS400 I have a CL program that creates a temporary Physical file with variable name. File name is created with “user_id + job_name + time”. How can I create a logical file, specifying in DDS for logical file that my PFILE is temporary and has variable name ? Thanks !

Answer Question   |  January 19, 2010  1:41 PM
CL programs, DDS, Logical File, Physical File

My CL program is running CPYTOIMPF cmd & causes an SQL error
Message Id: SQ999999 Error occurred in SQL Call Level Interface. A procedure call encountered an error. The error code is 10. When I F1 on the line in the job log and then F9 for details, I see this: From program QSQCLI in QSYS, module SQLSEA, procedure SQLSetEnvAttr at stmt 5793 and To program QCPEXPRT [...]

Answer Question   |  February 17, 2009  4:35 PM
CL programs, CPYTOIMPF, SQ999999, SQL error messages

How to strip comments from CL program?
Anyone know of a utility that will strip comments out of a CL program? We have many programs with more comments than actual code (for history purposes) and I’d like to see just the actual code. And no, I don’t want to RTVCLSRC and lose indentation, etc.

Answer Question   |  December 14, 2011  8:06 PM
CL, CL Comment Stripping, CL programs, CL utility

Decimal data error
For testing an RPG program, I changed the CL program which submits the RPG program to a “call”. The change was to include a new parameter (numeric) to the RPG program. After testing, the Call was changed back to SBMJOB, but when tested again, the RPG program bombed with ‘decimal data error’. What could the [...]

Answer Question   |  December 15, 2008  6:35 PM
CL, CL programs, RPG, RPG Programs, SBMJOB

CL modification to retrieve the data in LDA
An application exists in production, which submits a job to do some business processing. The program gets invoked from a CL. The program is proprietary and does not have a source. It’s known that this program uses LDA while processing. How can the CL program, which submits the job, be modified to retrieve the data [...]

Answer Question   |  December 12, 2008  6:04 PM
CL, CL programs, LDA

Retrieving system name using a CLP
How to retrieve the iseries or AS400 SYSTEM NAME USING A clp program?

Answer Question   |  August 22, 2010  1:28 PM
CL, CL programs, CLP, iSeries

create user based on (not navigator- I know how in navigator.
How do I create a user based on another user from a cl program.

Answer Question   |  August 25, 2008  6:37 PM
CL, CL programs, User profiles