• Help required in writing a CL program which will monitor QSYSOPR msgq for specific h/w failure msg ID’s and shoot email ?

    Hi All – Could any one help me in writing a CL program which will monitor the QSYSOPR msgq for specific h/w failure MSGID's and shoot email ? Regards, Madhu

    Madhura030 pointsBadges:
  • Deleting SAVED journal receivers

    I want to delete journal receivers in a library that have the the status of SAVED. Can anyone offer some CL code to do this in a program? Each receiver begins with AMQA and followed by 6 numerics. I guess I would write out to an outfile then read the outfile to delete the receivers.

    northwoods175 pointsBadges:
  • Show error message to user after a CPYF command ended in error in CL program

    I have a copy command in my CL program. I have specified tofile and tomember parameters. I have given CRTFILE(*NO) so that I don't want to create a source file if it is not existing. I want to show a message "Sourcefile is invalid" when the source file is not an existing one. I want to show the...

    RamvishakRamesh2,410 pointsBadges:
  • Changing user profiles in a CL program

    Since I'm not much of a programmer I was wondering if someone could offer some suggestions on three programs I need to write. My first program will need to delete the JOBD associated with the user profile in QGPL and replace it with a different JOBD. The profiles that will have to be changed will...

    northwoods175 pointsBadges:
  • Making changes in a user profile with a CL program

    I am going to need to write a CL program that will read a list downloaded from an Excel spreadsheet onto the AS/400. The CL will scan through the file that will delete the job description associated with the user profile in QGPL and will replace the deleted job description with a new JOBD that has...

    Rrbond07135 pointsBadges:
  • Column heading issue with RUNQRY in CL

    I have a CL program which has a RUNQRY. I have two input files and I have defined the result fields. I have given an expression and I have used column heading. The issue is after executing the query, if I do a RUNQRY on the outfile, I am not able to see the column headings of the defined fields....

    RamvishakRamesh2,410 pointsBadges:
  • Execute from a source member list

    I saw a colleague run something, and I know he built the user defined option (F16) "EX" in the WRKxxxPDM display, I don't know the CMD/CL routine or Syntax for the source file/type. Thanks in advance! Dan

    dinks5715 pointsBadges:
  • Program is expecting a file not used in this call

    I have 2 different environments using 2 different library lists. A user takes an option from a menu and a CL program is called with overrides to a database file and then an interactive RPG program is called. The user then exits this program and then goes to the other environment (different...

    Sofarsogood60 pointsBadges:
  • Determine if a submitted job has completed

    Hello ALL --- I have a CL program that executes a command which calls a CL utility program. The utility program submits a job that involves the building of a save file. The original CL program will then restore the contents of the save file into a library and obviously must wait until the submitted...

    mikechance81275 pointsBadges:
  • Convert an *iso date to *longjul in CLP

    I am trying to convert an *iso date to a *longjul date in a CL program so I can subtract 6 days from today. It is crashing with a message "Date contains too many or too few numeric characters." My code is : Definitions dcl var(&julend) type(*char) len(7) dcl var(&jul) type(*dec) len(8 0)...

    bluedragon630 pointsBadges:
  • Need to email a spool file from a CL program.

    We currently use TMAIL to email spool files from CL programs. I looked at SNDDST but I believe you can't email a spool file using that command. Is there another alternative?

    UARTJ105 pointsBadges:
  • compiling cl program, ownership issues

    i added a commment line to a current CL program. when i went to compile it thefollowing error message appeared Owner of object COPPK1 and object being replaced not the same. any ideas?

    edewing15 pointsBadges:
  • Writing CL to run programs, need to monitor for program completion: IF/THEN?

    I'm trying to write a process that will start a program, monitor it for completion and decide to either proceed to the next program if goes END OF JOB, or display a message and terminate the running CL if the program not have successful END OF JOB. I have written a CL that will run all the programs...

    EagerNewb50 pointsBadges:
  • Need to Identify whether a program is using by any user

    I need to create a program which need to verify whether a specific program is using by any other user in the environment, before allowing the user to use the program. Is there any way we can identify in CL or RPG that a program is using by how many users at a specified time?

    Cursorposition195 pointsBadges:
  • How to give If condition in CL/400 program

    Hi, I want to give two If conditions in a cl program to make sure the value of field is between the Range. I am trying to write following line of code but syntax error is coming,any idea/suggestions How can I do comparison at a same time: IF COND(%SST(&ODOBNM 7 4) *LE %SST(&VAR1 7 4)) and...

    6r1,485 pointsBadges:
  • Update a file from CL program

    Why it is said we cannot update a file through CL? We can use RunsqlStm or Runqry to update a record right? If I select a particular record by using Rcvf or opnqryf and then perform runqry/runsqlstm, will it pick the desired record?

    RamvishakRamesh2,410 pointsBadges:
  • Recompile CL program

    Hi, We added few new fields to an exising Physical file. When I check for the dependents for the changed Physical file in ALDON it shows 250 dependent objects. Do I need to recompile all 250 objects? Thanks, Elan

    elan0030 pointsBadges:
  • SQL 9010 Error when using RUNSQLSTM

    I have a CL program having the following RUNSQLSTM RUNSQLSTM  SRCFILE(AMBDEV/MSRCAMB) SRCMBR(AMBJARRVK)            COMMIT(*NONE)                            AMBJARRVK is a SQL member file in MSRCAMB source file having this SQL statment DELETE FROM GDPF WHERE...

    MaldaTabbah5 pointsBadges:
  • Delete objects on AS/400

    Hi I have a list of objects arranged alphabetically, I want to delete these objects in that order from a iseries server, can somebody help me how to write a CL for this?

    ten20081,150 pointsBadges:
  • CL Program Fails after upgrading to V6R1M0

    Since last year we have been running a cl program to delete spool files from QEZJOBLOG output queue after taking backup using brms. The spool files are deleted till a specified date which is mentioned by the operator while calling the program. But after upgrading the OS from V5R4M0 to V6R1M0 the...

    Haaiderali215 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