• AS/400 CL program

    Can we read and write in AS/400 CL program?

    new40075 pointsBadges:
  • STRSQL command

    Can you use the STRSQL command within an AS/400 CL program?

    Pb5410 pointsBadges:
  • Read records for a particular period in RPG

    Hi all! I have a date period in RPG as month and year like 072012 and 022013 both are character fields. I'm passing this fields from OPNQRYF in CL program to RPG. How can I read records from a master for this particular period in RPG? Surey

    Sureyz2,465 pointsBadges:
  • 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.

    northwoods180 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,505 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...

    northwoods180 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,505 pointsBadges:
  • How to write a CL program if SQL query is giving some record

    Hi, How can a CL program can be written based on some SQL query which gives some records. If SQL query is giving some records as output then using SNDEMLMSG command, how can that CL program be written? SNDEMLMSG command will send an email to specific user based on SQL query's output if any thing...

    6r1,590 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?

    edewing20 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:
  • How to send a mail through CL

    How to send a mail through CL?

    gsivakkp86225 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,590 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