STRQMQRY in batch on i5
Can STRQMQRY be run in batch? I am getting error message: Global variable prompting is not allowed in batch mode. I am passing 2 parameters from a display screen Software/Hardware used: iSeries, SQL, CL
Can STRQMQRY be run in batch? I am getting error message: Global variable prompting is not allowed in batch mode. I am passing 2 parameters from a display screen Software/Hardware used: iSeries, SQL, CL
35 pts.
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...
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...
RPG Programming Standards
I'M LOOKING FOR RPG PROGRAMMING STANDARDS. We have always had standards example if you create a report the report should have the date, title, program name, page numbers. Does anyone have a stanards document or is there anything on the web? I appreciate your help! Software/Hardware...
I'M LOOKING FOR RPG PROGRAMMING STANDARDS. We have always had standards example if you create a report the report should have the date, title, program name, page numbers. Does anyone have a stanards document or is there anything on the web? I appreciate your help! Software/Hardware...
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.
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.
How to get IP address of as400 machine in CL pgm
Hi CAn any 1 tell me how to get the IP address of the AS400 machine in CL program.Are there any API for this.I need to pass this IP to run a java program thrugh CL.. Thankx in advance Supriyob Software/Hardware used: AS400
Hi CAn any 1 tell me how to get the IP address of the AS400 machine in CL program.Are there any API for this.I need to pass this IP to run a java program thrugh CL.. Thankx in advance Supriyob Software/Hardware used: AS400
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 ...
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 ...
SNDUSRMSG equivalent in RPG (including VALUES and DFT)
Some time ago I found a piece of code by Scott Klemens regarding the implementation of SNDUSRMSG in RPG using QMHSNDM and QMHRCVPM. I need to do the exact same thing, however I also need to pass the values for the VALUES and DFT keywords used with SNDUSRMSG. Does anybody have an idea on how to do...
Some time ago I found a piece of code by Scott Klemens regarding the implementation of SNDUSRMSG in RPG using QMHSNDM and QMHRCVPM. I need to do the exact same thing, however I also need to pass the values for the VALUES and DFT keywords used with SNDUSRMSG. Does anybody have an idea on how to do...
IFS File Attributes
How do you retrieve the Creation Date of a link file object (an STMF) into a CL program?
How do you retrieve the Creation Date of a link file object (an STMF) into a CL program?
upload to as/400
hi, my user can only use client access to upload and download file only (please assume there is only this method), is it possible for me to write a batch file to automate the upload and download. just like ftp, i can always write a script to put all the 'GET' command and trigger the FTP in CLP...
hi, my user can only use client access to upload and download file only (please assume there is only this method), is it possible for me to write a batch file to automate the upload and download. just like ftp, i can always write a script to put all the 'GET' command and trigger the FTP in CLP...
SAVOBJ with OBJ as variable
Can we use variable in SAVOBJ like SAVOBJ OBJ(&OBJLIST).? I have a file containing list of objects to be saved. I was planning to read and concatenate the object names in &OBJLIST and later use in SAVOBJ. But getting a "Value 'xxxxx xxxxx' for OBJ not a name or generic name. I think the quotes...
Can we use variable in SAVOBJ like SAVOBJ OBJ(&OBJLIST).? I have a file containing list of objects to be saved. I was planning to read and concatenate the object names in &OBJLIST and later use in SAVOBJ. But getting a "Value 'xxxxx xxxxx' for OBJ not a name or generic name. I think the quotes...
Save selected files using RSTOBJ
I have written a pgm for our package installation which basically extract the objetcs from a save file shipped to customer along with the pgm. Now, before restoring the objects I need to take backup of the required object from the application lib. I have a PF file shipped with the save file which...
I have written a pgm for our package installation which basically extract the objetcs from a save file shipped to customer along with the pgm. Now, before restoring the objects I need to take backup of the required object from the application lib. I have a PF file shipped with the save file which...
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
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
Calling a procedure from a CL program
Hi, how do we call a procedure, with parameters from a CL program? Does anyone have examples?
Hi, how do we call a procedure, with parameters from a CL program? Does anyone have examples?
how to convert spool files to pdf
I am trying to convert spool files to PDF fromat na d having special Arabic charracters any bod gelp ?
I am trying to convert spool files to PDF fromat na d having special Arabic charracters any bod gelp ?
Run SEQUEL Viewpoint Client Report from CL
How can you run a Viewpoing client report from a batch CL job?
How can you run a Viewpoing client report from a batch CL job?
Create a Stored Procedure using CL and RPGLE programs
I have an RPGLE program called from a CL program for database files overrides. I want to call the same programs from a stored prodecure on SQL Server from within a Web application. I am brand new to SQL Server but am pretty good on the AS400.
I have an RPGLE program called from a CL program for database files overrides. I want to call the same programs from a stored prodecure on SQL Server from within a Web application. I am brand new to SQL Server but am pretty good on the AS400.
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 ?
HOW CAN I USING "FNDSTRPDM" BY CLP AND THE VARIABLE OF "FIND 'string' " LAST CHARACTER IS A SPACE ?
self-submitting cl pgm doesn't release screen
The interactive code in the CL pgm calls an RPG subfile pgm. The user makes selection, the CL pgm steps to the SBMJOB command, the CL pgm is executing the Batch portion, but the screen is hung up with "X system" displayed until batch job is done. The RPG is turning "ON" *inlr and RETURN is...
The interactive code in the CL pgm calls an RPG subfile pgm. The user makes selection, the CL pgm steps to the SBMJOB command, the CL pgm is executing the Batch portion, but the screen is hung up with "X system" displayed until batch job is done. The RPG is turning "ON" *inlr and RETURN is...
