• find physical files with large record counts that are unused

    How can I capture the number of records (not file size) for numerous physical files via a cl command in order that I may download the information and find the ones with the largest number of records? I need to free up disk space so I need to find the files that have records but have not been...

    Hayleypatrick5 pointsBadges:
  • CL for AS400 To FTP file To PC

    Hi Guys, I am just wondering if anyone of you know any CL that can be used to ftp from as400 to a pc.. The current issue that we have now is that a user will run the query, then i would like the CL/Script to actually ftp/transfer the file to a pc automatically. the file will be in an outq of the...

    jinteik17,790 pointsBadges:
  • Need to write a CL program to track user logins

    HI, I WANT HOW TO WRITE A CL PROGRAMME TO KNOW A USER IS LOGGED IN OR NOT.MEANS IN A SERVER NUMBER OF USERS OR THERE SO I WANT TO FIND OUT WHICH USER IS LOGIN STATE WHICH OR NOT LOG-OFF STATE.WHEN I RUN A PGM TO PROVIDE USER NAME IT WILL SHOW THE LOGIN OR LOGOFF STATUS...

    KIRAN9SDR15 pointsBadges:
  • CL for Backup Alerts

    Hi, I have to set up alert at a specific time on AS400 which will check if the backup job is running. If the backup is not running at that specific time,it should send an alert'Backup Not Running' else it should send an alert'Backup is running'/'Backup is in Message Wait'. Can anyone please suggest...

    Hugheswilliams345 pointsBadges:
  • system information into a file

    How can I retrieve system CPU,Memory,disk usage on AS/400 into a file?

    ten20081,150 pointsBadges:
  • writing to a flat file/stream file

    can we write to a flat file/stream file or both, a variable value using CL program?

    ten20081,150 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:
  • SUBSSYSTEMS IN AS/400

    Hi, Team How Can we start and End "all" subsystems at once in AS/400 through command line or by anyother way? as per my knowledge we can End SBS all at once useing command ENDSBS SBS(*ALL)  but we can't start  all SBS  at once using command line.  I Guess using CL Programing we can start!! pls...

    qmaster1,675 pointsBadges:
  • When submitting a procedure via CL program, i do not get any abnormal end message.

    When submitting a procedure via CL program, i do not get any abnormal end message even though the procedure has not not completed normally, is there anyway by which we can find the cause of the failure of the completion of the procedure normally.

    JohnsonMumbai1,160 pointsBadges:
  • 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:
  • 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:

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