• Java User Profile Usage

    On the I-series, I hava a java application being run within a CL program using the RUNJVA command. How can I get the java app to use a different user profile/job description than the CL program itself.

    Developer555 pointsBadges:
  • Invoking A Menu Option From Within A Pgm

    Our Operations dept type the command [Go Backup] and take option 1 Is it possible to automate these actions from within a CL pgm? Thanks Martin

    Riccam30 pointsBadges:
  • Is it possible to get an alert when database page faults exceeds a certain amount.

    Is it possible to get an alert when database page faults exceeds a certain amount. Iam referring to the page faults which appear when we give the WRKSYSSTS command.  Or write a pgm which could monitor the page faults and sent an alert. 

    JohnsonMumbai1,160 pointsBadges:
  • Pipe Delimited CSV File

    I have the following Pipe Delimited data in a physical file: Dealer Name¦Deal Number¦Buy/Sell¦ Joseph Camm¦80740¦S¦IG¦5000000.00¦ After issueing a CPYTOPCD command, I end up with: Dealer NameÝDeal NumberÝBuy/SellÝIG1ÝAMOUNT_amountÝ David CammÝ80740ÝSÝIGÝ5000000.00Ý How do I get...

    Ricca100 pointsBadges:
  • CPYTOPCD as an XLS

    I am using CPYTOPCD and emailing the resulting *.csv and *.txt files successfully. However, I am now trying to send the data as an XLS. Although the file is sent, the data does not appear in the different cells as I would expect, the whole string (although comma delimited) appears a whole string...

    Ricca100 pointsBadges:
  • WRKQRY

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

    Chardyjr45 pointsBadges:
  • Unable to run CPYSPLF command multiple times to same output file in a single CL.

    Iam running CPYSPLF command to an output file once, I process the resultant output file thereafter when i move on to the next spool file by again running the CPYSPLf Command on the same output file which required existing data to be cleared and overwritten with the data received from the second...

    JohnsonMumbai1,160 pointsBadges:
  • SAVOBJ

    I am trying to use the SAVOBJ command to copy files to a save file. Is there a way to add to the save file and not write over it with each SAVOBJ call? I know I can create a list of files and send all of them to one save file but I would rather just add to the save file if possible. Thanks

    Nward35 pointsBadges:
  • List of Outfiles

    I've seen a list of the System Supplied Outfiles in one of the manuals. Can anyone direct me to that manual ? Thanks, Bill Poulin

    wpoulin2,480 pointsBadges:
  • Parameter list is not refreshed from previous calls

    I created a command with validity checker defined. The validation work fine but the parameter list is not refreshed from previous calls to the command. I've defined a simple list for "user name " parameter in my command. If I give 3 user names (A, B, & C) in the list, in the next call even if I...

    Rohithsharma8415 pointsBadges:
  • Callin CLP with parameter

    Hi, I have a CL program which needs two Parametersa as a input, when i call a pgm with values, the value are not properly passed. It gives me decimal data error. For instance i gave values as Call pgm(clpgm) Parm('14' 'aaaaa') But it takes value as F1F44040404040. Hel me out soon. Thanks in advance...

    Keepsmilin5 pointsBadges:
  • Displaying data through DSPF and CL programm.!

    I would like to be able to display one record from my PF with DSP file through a CL program on my screen. I have these sources: CL program: ******************************************** QSYSPRT          1  QPADEV0021  USERNAME      pgm              DCLF      ...

    Avrelivs80 pointsBadges:
  • not a valid Query Management variable.

    Hi, can someone please help me, I am trying to use the QMQRY function to run an update statement. I pass it a variable from the program. Get the following error. is not a valid Query Management variable. Error found on STRQMQRY command. Function check. CPF0001 unmonitored by PGMFCTSEC at statement...

    Pmh5 pointsBadges:
  • Can i declare a display file and a physical file in a single CL

    Can i declare a display file and a physical file in a single CL.  Also can u share a sample program, which uses the parameters entered in the display file (using SNDRCV command) and processes records from a physical file.

    JohnsonMumbai1,160 pointsBadges:
  • managing authorization list

    a long time ago, I retrieved a CL from this site to manage authorization list. It displayed all the list to an output file and the CL uses the input file to properly balance the users and objects authority. Does anyone have something similar?

    Getitright10 pointsBadges:
  • Jobs goes into Message Wait after reaching End Of File.

    I am using the below programs to Delete Temporary Files from Specific Libraries on monthly basis after taking a Entire System Backup. [strong]The File and Library Names are stored in a Output File called MNTHDELE in QGPL and the Column Names are &ODLBNM for File Name and &ODOBNM for Library...

    Haaiderali215 pointsBadges:
  • Controlling JDE app outage times during CL reorg

    We currently run a weekly reorg controlled by a CL program. Until recently we had a four hour window and are now looking to do the reorgs with the smallest possible JDE application outage. Any recommendations?

    AS400 - Ask the Expert485 pointsBadges:
  • how can we use more than 1 file in CL ?

    Multiple files to used in CL

    Khadar90 pointsBadges:
  • Delete old spool files

    The following question was recently submitted by a user via e-mail: I am trying to create a program in CL to delete old spool files on the AS400. I am using the following code, but my program does not recognize any of the commands. Does anyone have any suggestions or solutions? Thank you very much....

    JennyMack4,280 pointsBadges:
  • How to extract data to the various excel sheets in a CL.

    Hi, I am new to the CL (Command Language) used by the as/400. I need to generate a spreadsheet of data from the as400. I would like to have all the data stored in one excel file instead of multiple excel files. Can someone show me how to use the various sheets in excel to store the data and how to...

    Djsqueeze5 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