• CL Command definition parameter with Mixed valid values

    Hello, I want to create a command with a parameter same as Stream file code page in CPYTOSTMF. It shoud allow only 1 - 32657, *STMF, *PCASCII, *STDASCII. Can someone explain how could I declare parameter to have this ? Thanks Sim

    sim400310 pointsBadges:
  • Reorganization of V5R4 while active

    We are currently on operating system V5R4. We are a 24/7 shop and as a result, I have not had the opportunity to do a lot of reorgs. I just discovered there is a reorg while active command. Can someone tell me how to use this? Does this come with the operating system or is it a separate module we...

    GHENDER200 pointsBadges:
  • Data Extract

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

    farmgirl165 pointsBadges:
  • Retrieving system name using a CLP

    How to retrieve the iseries or AS400 SYSTEM NAME USING A clp program?

    MELINDAD5 pointsBadges:
  • 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.

    Burmanr10 pointsBadges:
  • 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 CLLE. in CL it works.

    77060 pointsBadges:
  • 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...

    Hn25 pointsBadges:
  • 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...

    Lwk25 pointsBadges:
  • Using the command RCVMSG

    There are numerous reports which automatically print throughout the day. Often there may be a message waiting on the printer and because no one was expecting any reports, no one discovers the problem until hours later. (By this time there may be quite a few reports waiting to print) I was...

    GHENDER200 pointsBadges:
  • SAVDLO command: Folder name

    I am running an i5 with v5r4.  I am trying to same a given folder using SAVDLO *all FLR('QDLS/TempFlr') but it keeps telling me the folder is not specified correctly or not found.  I can use WRKLNK and get to it just fine.  Suggestions?

    ProjMan25 pointsBadges:
  • delete records from a directory with IFS root using CL

    How to delete records from a directory with IFS root using CL based on the timestamp of the records.

    Manish8465 pointsBadges:
  • Job Information

    I want to retrieve Job number & user name for a particular job name. I come to know that through 'QUSLJOB'or 'QUSRJOBI' we can retrieve Job number & user name for a given job name.Is it possible ? I tried doing in the system through CL but it retrieves the current job name info running in the...

    Sundaras4005 pointsBadges:
  • Calling non-as/400 programs via an RPGLE or CL program

    Can it be done? If so, how would I go about doing this? Let's say I just have a small VB program I wrote that displays a picture. Can I let's say somehow link the VB program call to a CF key, like CF08?

    Eric Witham690 pointsBadges:
  • CL/400 – I want to know about QRYSLT(Please see below explanation)

    Hi, I am not well versed with code in CL/400, i know the concepts. I want to know what is he doing in the below code. e.g usibng the symbols '|>' and '||' and '<|' IF COND(&TODUE7 *NE '0000000') THEN(DO) CHGVAR VAR(&QRYSL) VALUE(&QRYSL |> ' *AND (ODUDT *GE + ' || &FRDUE7 || ') *AND')...

    svankipu620 pointsBadges:
  • CPYF selecting a record by a variable

    Hi friends, I have a CL and I dont know how making a cpyf selecting records with a variable, like this example: 5722SS1 V5R3M0 040528 Control Language DLTOLDSPLF/CARGA TDBSBC14 04/06/08 19:54:32 Page 1 Program . . . . . . . . . . . . . . . . . . . : CARGA Library . . . . . . . . . . . . . . . . . ....

    SILVARB440 pointsBadges:
  • can Synon create a CL code

    How CL code is implemented in Synon

    Devanand051015 pointsBadges:
  • SNDUSRMSG equivalent in RPG (including VALUES and DFT)

    Some time ago I found a piece of code by Scott Klemens regarding the implementation of SNDUSRMSG in RPG using QMHSNDM and QMHRCVPM. I need to do the exact same thing, however I also need to pass the values for the VALUES and DFT keywords used with SNDUSRMSG. Does anybody have an idea on how to do...

    Roelpeeters5 pointsBadges:
  • Error when executing RUNSQLSTM from CL program

    I am trying to use the RUNSQLSTM command. I get the error message "statement not allowed" Not really trying anything fancy. In CL program RUNSQLSTM SRCFILE(jwe/QCLSRC) SRCMBR(SQL1) + COMMIT(*NONE) In SQL1 I have SELECT mstid, SUBSTR(ftxref,1,1) AS ftxref_1, SUBSTR(HEX(SUBSTR(ftxref,2,7)),1,9) AS...

    Tcwalls5 pointsBadges:
  • CL error message

    What is the full form of CPF in CPF0864 ????? Please Help......

    Vishal2370 pointsBadges:
  • Maximum number of CL variables with IBM i 6.1

    What is the maximum number of variables that you may define using the DCL command in a CL program on an IBM i version 6.1 system? Also: Where is this documented, if you know? I couldn't find it in the online help, Information Center, or CL Programming PDF. Thanks!

    I5os10 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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.