LIKE function in RPGLE
can i use like function instead of using subst.in rpgle Software/Hardware used: rgple
can i use like function instead of using subst.in rpgle Software/Hardware used: rgple
5 pts.
Problem with & in RPGLE
I'm using XML-SAX in a RPGLE-program to read an XML-file which works pretty fine. Though, when I come to an entity with "Boys "&" Girls" (I added extra " in this example between the "&" just to make it visual) i run into trouble. The handler does not seem to recognise anything after...
I'm using XML-SAX in a RPGLE-program to read an XML-file which works pretty fine. Though, when I come to an entity with "Boys "&" Girls" (I added extra " in this example between the "&" just to make it visual) i run into trouble. The handler does not seem to recognise anything after...
Stored Procedure
I've to use stored procedure in RPGLE program. my code is CallP OESP_PORD_001(IPAT#:OPNXT#:PRJUK) I get error name or indicator not defined...i checked the library, parameters and everything are in place....Am I calling the SP with the right syntax? i tried to then change this whole using...
I've to use stored procedure in RPGLE program. my code is CallP OESP_PORD_001(IPAT#:OPNXT#:PRJUK) I get error name or indicator not defined...i checked the library, parameters and everything are in place....Am I calling the SP with the right syntax? i tried to then change this whole using...
email from RPGLE with hyperlink
I need to imbed a hyperlink into the body of an email so the recipient merely clicks on the link to be routed to a report in Business Objects. Software/Hardware used: iseries rpgle
I need to imbed a hyperlink into the body of an email so the recipient merely clicks on the link to be routed to a report in Business Objects. Software/Hardware used: iseries rpgle
How can we know from which program my RPGLE program is called from.
Hi All, I have one RPGLE program (PROG1)is calling from 10 programs, I got one requirement i.e if my program PROG1 called from 10 different programs my program PROG1 should perform 10 different functionality in my PROG1. So if i want to write code for 10 different functionalities in PROG1, first...
Hi All, I have one RPGLE program (PROG1)is calling from 10 programs, I got one requirement i.e if my program PROG1 called from 10 different programs my program PROG1 should perform 10 different functionality in my PROG1. So if i want to write code for 10 different functionalities in PROG1, first...
Trigger program written in RPGLE
I have a trigger program that have 3 files declared in F-Specs (no UsrOpn keyword). Everytime it ends, it sets the LR indicator on. Does the trigger program slow down processing when the trigger file is updated in a batch program? Should I remove the code that turns on the LR indicator? ...
I have a trigger program that have 3 files declared in F-Specs (no UsrOpn keyword). Everytime it ends, it sets the LR indicator on. Does the trigger program slow down processing when the trigger file is updated in a batch program? Should I remove the code that turns on the LR indicator? ...
SQL cursor question
hi, i've SQLRPGLe program in which i'm writing a cursor to select all records, order them by a field A (suppose employee number). And once all the rows fetched for an employee and printed, print the count at the bottom. Repeat this for all the subsequent employees.... i'm not sure how to...
hi, i've SQLRPGLe program in which i'm writing a cursor to select all records, order them by a field A (suppose employee number). And once all the rows fetched for an employee and printed, print the count at the bottom. Repeat this for all the subsequent employees.... i'm not sure how to...
Scrolling Message in RPGLE
Does anyone know how to create a scolling message on the bottom of a display screen? I am programming on the AS400 in RPGLE
Does anyone know how to create a scolling message on the bottom of a display screen? I am programming on the AS400 in RPGLE
Using SRCDBG with an SQLRPGLE module
I'm trying to debug a RPGLE module created with CRTSQLRPGI. The STRDBG program returns an error message stating the program "cannot be accessed". There is no DBGVIEW option on the CRTSQLRPGI command, so even if I get the debug to work. will I see any source data? Thanks. Software/Hardware used:...
I'm trying to debug a RPGLE module created with CRTSQLRPGI. The STRDBG program returns an error message stating the program "cannot be accessed". There is no DBGVIEW option on the CRTSQLRPGI command, so even if I get the debug to work. will I see any source data? Thanks. Software/Hardware used:...
Get user id in CGI RPG program
Please, kindly advise on this issue I am having. Program is coded in RPG and is a CGI module. I tried to get user-id from program data structure, but this "UserID 254 263", but it shows QTMHHTTP, because this pgr runs on HTTP server. How else can I obtain real user-id of the user who is envoking...
Please, kindly advise on this issue I am having. Program is coded in RPG and is a CGI module. I tried to get user-id from program data structure, but this "UserID 254 263", but it shows QTMHHTTP, because this pgr runs on HTTP server. How else can I obtain real user-id of the user who is envoking...
To Check the junk Values in RPGLE character field
How to check the junk values in character filed except the If loop? All values that can be entered from keybord are accepetable in this field. Need to check any other characters (jucnk values) stored in this field. Software/Hardware used: AS400
How to check the junk values in character filed except the If loop? All values that can be entered from keybord are accepetable in this field. Need to check any other characters (jucnk values) stored in this field. Software/Hardware used: AS400
Access to 'object in use' attribute of IFS object from QSYS RPGLE
If you open a document which is stored in the IFS with OpenOffice, examining the object with Navigator allows you to see the 'in Use' property - it says that there is 1 Netserver reference. Examining DSPLNK for the same object shows no such 'in use' attribute. How do I get to that attribute in...
If you open a document which is stored in the IFS with OpenOffice, examining the object with Navigator allows you to see the 'in Use' property - it says that there is 1 Netserver reference. Examining DSPLNK for the same object shows no such 'in use' attribute. How do I get to that attribute in...
USROPN file in SQLRPGLE
I have a SQLRPGLe program. Certain files are not available at client terminal depending upon the applications purchased by client. I have a common program called from all applications and hence i user open the files based on the application types. my confusion is if i refer a file directly in SQL...
I have a SQLRPGLe program. Certain files are not available at client terminal depending upon the applications purchased by client. I have a common program called from all applications and hence i user open the files based on the application types. my confusion is if i refer a file directly in SQL...
Get user id within rpgle
How do I get the user id within /Free and send command to clear a workfile? Thanks!
How do I get the user id within /Free and send command to clear a workfile? Thanks!
comments in rpgile
How can i write my comments in colours ..... i have seen some code written by one of the indian company which has its comments with different colours like red,blue,white....
How can i write my comments in colours ..... i have seen some code written by one of the indian company which has its comments with different colours like red,blue,white....
Modify MS Access using iSeries RPGLE
I have to intergrate a third party product that uses an MS Access database with my AS/400 machine and be able to both update the Access data as well as read data from the Access database to use on the 400. Does anyone know how I can do this?
I have to intergrate a third party product that uses an MS Access database with my AS/400 machine and be able to both update the Access data as well as read data from the Access database to use on the 400. Does anyone know how I can do this?
file transfer via client access
Hi, in order to upload files from pc, i will usually write a FTP script in rpgle and trigger the FTP command in CLP to 'get' the file. due to security reason, FTP now is not allowed to use. May i know is there any way to upload pc file via client access with SCRIPT like FTP. THANKS.
Hi, in order to upload files from pc, i will usually write a FTP script in rpgle and trigger the FTP command in CLP to 'get' the file. due to security reason, FTP now is not allowed to use. May i know is there any way to upload pc file via client access with SCRIPT like FTP. THANKS.
SQL embedded in RPGLE
RPGLE program with five modules updating different set of files. Main module calls others each time a customer is being processed to change some specific detail in many files. There are many customers, so the modules are called many times (LR is set on only at the end of the whole process). Each...
RPGLE program with five modules updating different set of files. Main module calls others each time a customer is being processed to change some specific detail in many files. There are many customers, so the modules are called many times (LR is set on only at the end of the whole process). Each...
Printing Physical File Records
I wanted to print the Records in Physical File with out using 1. RPGLE Program 2. Query I wanted to print the PF records using WRKMBRPDM and Option 6 Please help me to find the solution
I wanted to print the Records in Physical File with out using 1. RPGLE Program 2. Query I wanted to print the PF records using WRKMBRPDM and Option 6 Please help me to find the solution
