Convert Spool file to DB file
Hi, I have a spool file which I created by WRKACTJOB (*print).. Is it possible to convert the spool file format to a database file….. What does an OVRPRTF command do …? Thanks, Yogesh

Answer Question   |  May 18, 2009  11:19 AM
CL, CL/400, Override with Printer File, OVRPRTF, Spool files, Work with Active Jobs, WRKACTJOB

When I call CL by 3 parm. (‘ ‘) change to (‘)
When I call CL by use 3 parm like this command = CALL PGM(CTLMNUCUP) PARM(‘MENUA’ ’1′ ‘CALL PGMA (”)’) In pgm it show Parm3 = ‘CALL PGMA (‘) What the method I can solve? thk u.

Answer Question   |  May 18, 2009  6:59 AM
CL, CL Parameters, CL/400

How to find out number of members in Source file ?
Hi All, i want to find out how many number of members are available in one source file. For example i have created one source file (QRPGSRC) in (LIBRARY1) now i want to find how many sources are available in LIBRARY1/QRPGSRC this source in my RPGILE program. Do we have any AS400 command or API [...]

Answer Question   |  May 17, 2009  9:15 AM
AS/400 commands, CL, QRPGSRC, RPGILE

strsql
can you use the strsql command within an AS400 cl program?

Answer Question   |  September 9, 2010  2:37 PM
CL, CL Program, STRSQL

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

Update a flat file through CL
Hi, I have copied a message from MSGQ into a CL variable. Is it possible to write that message in a flat fiile through CL.

Answer Question   |  May 8, 2009  1:21 PM
CL, CL/400, Flat files

How to Retrieve MSGW status in WRKACTJOB in CL variable
Hi, While Job monitoring if any job goes in MSGW status … then is there any CL command which retrieves the status (exactly MSGW not *ACTIVE) and display it on the screen. Rather than doing manually job monitoring (Pressing F5 for a long time to look into the status of the job) if a CL [...]

Answer Question   |  May 8, 2009  1:13 PM
CL, CL/400, MSGW status, WRKACTJOB

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

Creating multiple files from a single code base and FTP.
This is a two part question. 1. I’m looking to use a COBOL program to create multiple files in a standard library. Is there a way to programatically write multiple files from a single program. I had someone indicate that I could call to CL instream and actually create multiple files on the fly. 2. [...]

Answer Question   |  May 6, 2009  2:52 PM
AS/400 FTP, CL, COBOL, TCP/IP

Program calls on AS/400
How i can check that my previous call to a program from other program was successful. Only after successful call and run only i can call another program. How to do check this in RPG and CL?

Answer Question   |  April 28, 2009  7:53 AM
AS/400 development, CL, RPG, RPG/400

OVRDBF Not working as supposed to
Here’s the program flow CL1 calls RPG1 RPG1 calls CL2 CL2 has OVRDBF on fileA that is being used in RPG1 When the control gies back to RPG1, the file is not overriden. So I thought it might have ended at call level and I tried to do OVRDBF in RPG1 after the control come [...]

Answer Question   |  April 18, 2009  6:12 PM
CL, OVRDBF, RPG

CPYTOPCD gettig an error in CL
Hello, This is my command in CL CPYTOPCD FROMFILE(QS36F/&SVPF) + TOFLR(‘c:testfoldertext.txt’) + TODOC(&SVPF) REPLACE(*YES) I get an error at run time. Error message as follows: 13308 – CPYTOPCD FROMF QCA ILE(QS36F/Y15162612) TO FLR(‘c:testfoldertext .txt’) TODOC(‘Y15162612 ‘) REPLACE(*YES) Folder name not correct QHU. ‘Y15162612 ‘ QHU is not a correct docume nt or folder name. Error [...]

Answer Question   |  April 17, 2009  8:51 PM
CL, CL Errors, CPYTOPCD

AS/400 user profile update
What is the CL code to DISABLE a number of AS400 profiles using a specific user list

Answer Question   |  April 15, 2009  9:01 AM
AS/400 administration, AS/400 Control Language, AS/400 user profiles, CHGUSRPRF, CL

Retrieve pdf file through JAVA from IFS
How can I retrieve a pdf file stored on IFS generated by CL program through JAVA screen?

Answer Question   |  April 15, 2009  12:07 PM
CL, IFS, Java, PDF

how can we use more than 1 file in CL ?
Multiple files to used in CL

Answer Question   |  April 17, 2009  1:41 PM
CL, CL programming

How to retrieve the current version of AS400 you are working on?
Hi, Does anyone know how to retrieve the current version, release and model number of the AS400 box you are working on. We can view this information in spool files, but I want to retrieve this information through both CL and RPG program. Regards Shruti.

Answer Question   |  April 7, 2009  12:42 PM
AS/400 upgrades, AS/400 Version, CL, RPG

How to create a code using diff colors in RPG & CL
How to create a code using diff colors in RPG & CL

Answer Question   |  April 3, 2009  4:04 AM
CL, RPG, RPG/400

Qshell error from a CLP
i correct CPFB9C8 qshell error from my cl call

Answer Question   |  February 18, 2010  12:45 AM
AS/400 Control Language, CL, Qshell, QShell Error CPFB9C8

Comparing ID and password in an AS/400 login screen
Dear friends iam quite new to this AS/400 . could you please let me know how to compare the id and password in a login screen..how to connect the cl program and display file to perform login operation .Do i need to write rpg code for that ..Pls help me out with this code in [...]

Answer Question   |  March 30, 2009  6:39 AM
AS/400 login, AS/400 passwords, AS/400 user sessions, CL, CL/400, RPG, RPG/400

CL/400
I would like to convay my Thanks ReshmaG & Gilly400. My main requirement is I have a Physical file called PF1.On this there are 20-logical files are depended . I have changed some attributes on my PF1. Now I want to recompile all the Lgical Files , which are depended on PF1. I am writing [...]

Answer Question   |  March 26, 2009  10:35 AM
AS/400 Control Language, CL, CL/400, Logical File, Physical File