• 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 fields)....

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

    JeffWilson20 pointsBadges:
  • 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 command in various cl...

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

    Boulevard55 pointsBadges:
  • converting s36 procedures into as400 mile clp programs

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

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

    JCCPT5 pointsBadges:
  • 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?

    Habegger10 pointsBadges:
  • 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 ?

    TSCTHOMAS5 pointsBadges:
  • Synon/Cool:2E – internal/external func performance question

    I have a situation where I have to call a synon function multiple times (for each record in a file one after another) from another synon function. The called function does some calculatons. Will there be any performance improvement if I make the called func an internal function and have an external...

    Rituraj0 pointsBadges:
  • RCVF In CL

    I am using nested RCVF to read PF's in a CL program. The second iteration of the inner loop does not happen because the pointer is set to end of file. How do I reset the pointer to start at the begining? I have tried OVRDBF, OPNQRYF, POSDBF and deleting and recreating the PF. Thank you for your...

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

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

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

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

    Chandlerbing81840 pointsBadges:
  • 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 FROMFILE(*LIBL/&TITLE) TOFILE(SM1099) + MBROPT(*REPLACE) FMTOPT(*MAP...

    BobAnnBri5 pointsBadges:
  • File pointer is being reset to the top in a CLP program

    I am processing the *OUTFILE from a DSPOBJD command. Trying to create a logical file. When the CRTDUPOBJ fails the program loops to the RCVF command but the same record is being read again...WHY??

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

    tjgm88995 pointsBadges:
  • Collecting System Performance Values.

    I need to get some values like total CPU usage, Number of active jobs by catagory, excessive CPU usage by a job (which may be looping), Jobs with messages waiting to be answered and similar information. I have to write these values to a file every five minutes. These values will be graphically...

    Ashnirody100 pointsBadges:
  • Complete backup via CLP

    Isn't it possible to wrap the commands issued via GO SAVE option 21 in a CLP and run it via job scheduled entry, assuming proper authority, etc.?

    GLinds0125 pointsBadges:
  • Question on LoadAll Subfile.

    Hi, How to load more than 9999 records in the case of loadall subfile??? And i don't want delete previously loaded records. Thanks, Rama Krishna

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

Following