CLP

Retriveing massage from submited job in CLP

I have CLP and a cobol program. CL program calls the cobol program in Batch mode by doing SBMJOB. The cobol program processing 1000 records from a database file. If it founds errorneous record in the time of processing, then it stops processing with a system generated error massage and control go...

AS/400 Program To List Physcial Files with Deleted Records

We currently have a program to list Physical Files with Deleted Records. The CLP utilizes the DSPFD command to build an out-file. The parameter for 'Type of Information' is *MBRLIST and 'File Attributes' is *PF. However, the out-file lists the data at the member level. Also, teh job takes TOO LONG...

Database Creation using CLP

Hello Everybody, I have a small question. First I will explain my requirement. Requirement: I have a database file let’s say “PF1”; I am fetching some records from this file based on some criteria. This fetched record I have to write to one database file “PF2” (This contain six...

FTP through CLP program

Hello, I have a script written for 'INPUT' file during the FTP process. The user-id and the password are being hardcoded in the script.To maintain the security I want to encrypt the password alone in the script.May be when the FTP is in action, the password can be retrieved from a file or data...

Best way to retrieve values, SQL or Queries and how?

Hello everybody, my problem is, in a iseries i have ia file and in this file exist one field with 10000 lenght (character) and i want retrieve a value like (  60F: ) but i don´t know in what position, after i find this value i need the follow values. ex: this is a part of one record  {4: ...

How Can I pass multiple USER ID's to QEZSNDMG

Does anyone have an example of passing multple user id's to the API QEZSNDMG?  I have a CL that calls QEZSNDMG and it works fine with one user or *ALLACT.  I need to supply a list of multiple users that I can pass to it.  Anyone have an example of that? Software/Hardware used: CLP on iSeries

Truncating parameters!

I haev a 6 position alpha variable that has a value of '12345 ' (a trailing blank). When I submit a job that does a CALL to a pgm with that variable as a parm, the submitted job has the value of that parm as '12345' with no trailing blank. Both pgms declare the variable as 6 *CHAR. I know there are...

AS/400: Close open files

Dear sirs, could you please help me with the following problem: I want to close all open files that are left open from previous different steps (pgms rpg , rpgle , clp) that were run. I have tried to use a CLP pgm using RCLRSC, RCLRSC *CALLER with no success. Could you please advise me how to close...

STRQMQRY

If you use a CLP to pass parameters to a STRQMQRY command. How do you disable prompting this command.

file transfer via client access

Hi, in order to upload files from pc, i will usually write a FTP script in rpgle and trigger the FTP command in CLP to 'get' the file. due to security reason, FTP now is not allowed to use. May i know is there any way to upload pc file via client access with SCRIPT like FTP. THANKS.

converting s36 procedures into as400 mile clp programs

is there a conversion command to convert s36 procedure into clp programs?

Using SQL Connect Statement in SQLRPGLE

I need to use the SQL CONNECT statement within a SQLRPGLE program to connect from one AS400 system to another. I need to get data from one file to another. Does anyone know how to do this? Can it be done within a program. I have no trouble when I do it on an SQL command line... I use CONNECT to...

Clearing a window in CLP

I am calling a window program from a CLP program. When I try to redisplay the origina screen the window data stays on the screen. How can I clear this old screen data?

How can I use FNDSTRPDM with CL

HOW CAN I USING "FNDSTRPDM" BY CLP AND THE VARIABLE OF "FIND 'string' " LAST CHARACTER IS A SPACE ?

MONMSG

where could i get all the MONMSG list of messages to code in a CLP?

Retreive Stream file size through CL

Hi, How to detemine the file size of a '.TXT' file through CL program? Its a file stored in the IFS folder. Is there any specific command to do this? I need to continuosly look into this folder for the file. Fetch the file size. Wait for some sec and then again retrive the file size. If the...

joblog as400 printing

I'm running a job that could write many joblogs. What I want: if there are any kind of errors (even those answered with an Ignore) the joblog will print, else there is no joblog printed. I can get prints on a hard cancel of a clp but not if answered with an ignore.

I have an OVRDBF command that quit working.

I added 3 fields to each of the files referenced in the OVRDBF command and then recompiled all 5 CLP's that have the same OVRDBF command in them. Here is a copy of the CLP.... CHGVAR VAR(&TITLE) VALUE('SETLMAST' *CAT &YEARC) CPYF ...

Will RUNRMTCMD hold the host session until the program execution completes in the remote machine?

Hi, When executing RUNRMTCMD to run a long runnibg program in a remote iSeries partition, will the session on the host machine be held until the long running program completes in the remote partition? Any chance that a 'fire and forget' kind of effect can be achieved? i.e. I would like to have...

AS/400 CL Auto Reply to "Load Next Tape messages"

Would like to auto reply to this message without amending the system reply list entries, rather just from within the Backup CLP itself.