strpccmd
CL program uses this command to download file from AS/400 machine on to the PC using TTO.But download is not happening properly.can someone help?

Answer Question   |  November 6, 2008  2:02 PM
CL, CL programming, STRPCCMD

How to add CRLF to a CL Message
I would like to add a CRLF so part of a message in a CL command will go to a new line.

Answer Question   |  February 2, 2009  5:12 PM
AS/400 command keys, CL, CL Commands, CRLF, iSeries

New member creation through CL
I need to create members dynamicaly once my file size is full through Cl.How can i do this?How can i set range to this new members?

Answer Question   |  November 3, 2008  6:12 AM
AS/400 administration, AS/400 Control Language, CL

Data Extract
What is the easiest way to extract data from a pipe-delimited text file?

Answer Question   |  September 13, 2010  2:37 PM
CL, DB2, Pipe-Delimited Text File, RPG

Append date to FTP file name
I want to append the date to the file name I am putting on the pc. I am using a cl batch program to process the files on a daily basis. The files are identified in a member in a source file. (PUT ftpdbf/filea filea102408.txt). The files from the 400 are created with a cpysplf [...]

Answer Question   |  August 31, 2009  6:04 AM
AS/400 FTP, CL, CL batch program, CLP, CPYSPLF

WRKQRY
How do I create CL program that will execute WRKQRY command?

Answer Question   |  November 24, 2009  7:57 PM
CL, CL programming, WRKQRY

CL Program
My management has ask me to disable the ability of users to access to command line access from an application by limting capabilities *YES. I need to write a CL that will allow me to place RUNQRY into the application menu and need help creating the CL program. Can anyone assist?

Answer Question   |  August 27, 2010  5:18 PM
CL, CL Program

How to delete a user’s spoolfile in batch by date range?
Would like to know is there a way to delete a user’s spool file in batch by date range? Is there any CL I can refer to.Please help. FYI, my iSeries model = 20 running on OS/400 V5R3M0. Thank you in advance for your help. Mod Note: This question was submitted to our Moderator mailbox.

Answer Question   |  October 29, 2009  3:52 PM
CL, iSeries, OS/400, Spool files, V5R3

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

Convert date to match database field with L data type?
The field in file is defined with data type L (2008-09-29). My date range in display file is MMDDYY. How do I convert prompt date so I can opnqryf on field in data base file?

Answer Question   |  September 30, 2008  2:12 PM
CL, CL/400, CVTDAT

Record lock
I have ecounter a situation where my program is updating a record which is locked by another user. Can anybody suggest on developing a process using CL program which can handle such kind of situation where my CL program will send a message to the user who has put a lock and after waiting for [...]

Answer Question   |  October 6, 2011  10:06 AM
CL, COBOL/400

Pointer In CL
How we point the particular record in file on the base of key in CL Programming.

Answer Question   |  September 26, 2008  11:48 AM
CL, CL programming, Pointers

File access in Rpg
Hi All, Suppose you have 3 members in a database file. How to read records from all the members without using CL (OVRDBF) ie it should be handled exclusively in an RPG program? Thanks Venkat

Answer Question   |  September 25, 2008  12:59 PM
CL, OVRDBF, RPG

AS/400 SQL Procedure call from CL program
I am calling an SQL stored procedure (counts records for a value) from a CL program. I want to send the value to compare to the CL SQL pricedure and get back the count. How do I define the count variable (&COUNT ?) in the CL program? I am using STRQMQRY to call.

Answer Question   |  July 31, 2010  4:39 PM
CL, SQL stored procedures, STRQMQRY

CL/400
I have taken 2 parameters(like date and date types). A. If suppose date type is j,Now i want to convert date to *MDY format B. if date type is M,now i want to convert date to *JUL format C. sending a Program message with the value of converted date.(With use of CVTDAT in cl coding)Please [...]

Answer Question   |  July 31, 2010  11:40 AM
CL, CL/400, CVTDAT

Immbedding parameters in CL program
Hi, I am having trouble immbedding parameters in a CL program with quotes, within a ADDJOBSCDE command. See below. ADDJOBSCDE JOB(&JOB) CMD(RUNC90JOB SEQ(*SUBJB) + PGM(UN798CL) PARM(”” *TCAT &PARM *CAT + ””)) FRQ(*ONCE) + JOBD(C90FILES/QBATCHASMD) JOBQ(QPGMR) The problem is with the 4 quotes the system adds a quote after the translation, which I do not want. [...]

Answer Question   |  September 15, 2008  12:44 AM
Add Job Schedule Entry, ADDJOBSCDE, CL, CLP

How to create CL file from Java class
i m creating a .sh file on the fly from my java code to perform db2 export operation in the code given below. Can I do the same in as/400 to create a cl file on the fly . path = new File(batchfilepath+”.sh”); path.delete(); path.createNewFile(); String exitString = “No”; PrintWriter print = new PrintWriter(new FileWriter(path)); [...]

Answer Question   |  July 30, 2010  6:33 AM
CL, DB2/400, Java classes

Did anyone use DATA structures In CL
As of V5R4 it is possible to use Data structures in CL similar to RPG. The most useful thing to use is for qualified commands where the qualifie parameter is a File and Libraray. but itl looks to me that it does not work when the parameter is a data structure and the program is [...]

Answer Question   |  July 30, 2010  7:38 AM
CL, CLLE, Data structures

CPYTOIMPF ‘To File’ problem
The following command: ===> CPYTOIMPF FROMFILE(LTCLIB/WPELG01P) TOFILE(LTCLIB/WPELGCSV) MBROPT(*REPLACE) STRDLM(*NONE) produces error To-file WPELGCSV in LTCLIB not allowed. The explanation says the To file must be an externally defined PF, which it is. I need to remove the double quote marks from the CSV file I am trying to produce. Both the From and To files [...]

Answer Question   |  July 30, 2010  5:22 PM
CL, CPYTOIMPF, RPGLE

Virtual Tape CL Program
Does anyone have an example cl using virtual tape for backup. I have tested with this but am looking for a way to incorporate into a custom cl backup procedure.

Answer Question   |  September 9, 2008  2:38 PM
AS/400 backup, CL, Tape Backups, Virtual tape