Stored Procedures called from RPG programs
I created a stored procedure that returns a result set. I am using it in a PHP program and all works great. Pass in a account Id and returns all hits for valid records for that account. We have a excel report and subfile screen that runs off a green screen that needs to retreive [...]
Answer Question
| December 23, 2010 1:41 PM
AS/400, CLP, RPG, RPGLE, Web development
I created a stored procedure that returns a result set. I am using it in a PHP program and all works great. Pass in a account Id and returns all hits for valid records for that account. We have a excel report and subfile screen that runs off a green screen that needs to retreive [...]
Answer Question
| December 23, 2010 1:41 PM
AS/400, CLP, RPG, RPGLE, Web development
Reg Data extraction from one environment to another
Hi Consider i have testing library and development library in my library list. Say for eg, given a shipment ID i need to copy all the relevant data from testing enviroment to development environment. Since the file objects reside in testing and dev environment how will i be able to fetch data from particular environment. [...]
Answer Question
| January 17, 2007 4:26 AM
Application development, AS/400, CLP, RPGLE
Hi Consider i have testing library and development library in my library list. Say for eg, given a shipment ID i need to copy all the relevant data from testing enviroment to development environment. Since the file objects reside in testing and dev environment how will i be able to fetch data from particular environment. [...]
Answer Question
| January 17, 2007 4:26 AM
Application development, AS/400, CLP, RPGLE
RPG Calling Java
Hi, We have an RPG program making a Java call several times in a job. The Java call fails after certain number of calls and the number of calls is fixed. In one of the systems we noticed that the number of calls to the Java method after which the job abends is 262141. Is [...]
Answer Question
| December 29, 2009 10:09 AM
AS/400, DataCenter, RPGLE
Hi, We have an RPG program making a Java call several times in a job. The Java call fails after certain number of calls and the number of calls is fixed. In one of the systems we noticed that the number of calls to the Java method after which the job abends is 262141. Is [...]
Answer Question
| December 29, 2009 10:09 AM
AS/400, DataCenter, RPGLE
Program works in debug but not run time
I have an RPGLE program that works when run in debug mode but will not update the file when run outside of debug. I have looked at the obvious, such as library list to ensure using same versions of programs. At a loss……
Answer Question
| December 29, 2009 10:57 AM
AS/400, RPG, RPGLE
I have an RPGLE program that works when run in debug mode but will not update the file when run outside of debug. I have looked at the obvious, such as library list to ensure using same versions of programs. At a loss……
Answer Question
| December 29, 2009 10:57 AM
AS/400, RPG, RPGLE
Printing a barcode from the O specs of an RPG program
Specifically, I need information on how to print a barcode from the O specs of an RPG program. I found an example to print a barcode by passing hex in the O specs, but I didn’t understand the how to part. I realize this is an older way of printing a barcode as I am [...]
Answer Question
| January 10, 2007 9:16 PM
Printing, RPG, RPGLE
Specifically, I need information on how to print a barcode from the O specs of an RPG program. I found an example to print a barcode by passing hex in the O specs, but I didn’t understand the how to part. I realize this is an older way of printing a barcode as I am [...]
Answer Question
| January 10, 2007 9:16 PM
Printing, RPG, RPGLE
Getting job log info into RPGLE program
I’m looking for an easy way to get “error” information from the job log into my RPGLE Program. I’m “monitoring” a CHAIN to a file for an “unable to allocate” error, and would like to pop-up a window to display who is locking the record. How do I go about doing this? Thanks
Answer Question
| January 5, 2007 10:49 AM
CLP, RPGLE
I’m looking for an easy way to get “error” information from the job log into my RPGLE Program. I’m “monitoring” a CHAIN to a file for an “unable to allocate” error, and would like to pop-up a window to display who is locking the record. How do I go about doing this? Thanks
Answer Question
| January 5, 2007 10:49 AM
CLP, RPGLE
using SQL statements…………..
Hi All, I have a problem. I have a string variable STR which contains SQL statements…… Like insert into lib1/fil1 select * from lib2/fil2 variable STR is changable…means I update the values of library and files at run time…in the variable STR.. I want to execute the SQL statements contained in string STR… How can [...]
Answer Question
| December 23, 2010 9:52 AM
CLP, DB2 Universal Database, RPGLE
Hi All, I have a problem. I have a string variable STR which contains SQL statements…… Like insert into lib1/fil1 select * from lib2/fil2 variable STR is changable…means I update the values of library and files at run time…in the variable STR.. I want to execute the SQL statements contained in string STR… How can [...]
Answer Question
| December 23, 2010 9:52 AM
CLP, DB2 Universal Database, RPGLE
Using two same files from different libraries in a RPGLE program.
Hi All, Please guide me for the following problem. I got stuck into it. I want to operate same file from two different libraries in a RPGLE program. Remember we are taking the file names at runtime.So we don?t know the structure of files. Like the record format name etc. Again somehow I retrieve the [...]
Answer Question
| December 28, 2009 4:15 AM
CLP, DB2 Universal Database, RPGLE
Hi All, Please guide me for the following problem. I got stuck into it. I want to operate same file from two different libraries in a RPGLE program. Remember we are taking the file names at runtime.So we don?t know the structure of files. Like the record format name etc. Again somehow I retrieve the [...]
Answer Question
| December 28, 2009 4:15 AM
CLP, DB2 Universal Database, RPGLE
Is it possible to reorganize a very big transaction in one night?
I want to reorganize a very big transaction file in day end process and it cannot finish within 1 night. The problem is RGZPFM command lock that file ,so the day after , user cannot use that file because it is locked. Do you have any ideas to help me?
Answer Question
| December 28, 2009 4:43 AM
Application development, AS/400, AS/400 careers, Backup & recovery, CLP, DataCenter, DB2 Universal Database, Printing, RPG, RPGLE, Security
I want to reorganize a very big transaction file in day end process and it cannot finish within 1 night. The problem is RGZPFM command lock that file ,so the day after , user cannot use that file because it is locked. Do you have any ideas to help me?
Answer Question
| December 28, 2009 4:43 AM
Application development, AS/400, AS/400 careers, Backup & recovery, CLP, DataCenter, DB2 Universal Database, Printing, RPG, RPGLE, Security
CRTBNDRPG defaults
How/Where/can I…change the printer file defaults for the CRTBNDRPG program command. I need to change the page lenght so that listings will print properly on a laser printer
Answer Question
| December 19, 2010 7:04 PM
AS/400, DataCenter, RPGLE
How/Where/can I…change the printer file defaults for the CRTBNDRPG program command. I need to change the page lenght so that listings will print properly on a laser printer
Answer Question
| December 19, 2010 7:04 PM
AS/400, DataCenter, RPGLE
Never Ending Program
I have a program which updates several A/R balance files. This program needs to run continuously every so many seconds to update our customers’ balances. How can I make this program a never ending program?
Answer Question
| December 25, 2009 3:00 PM
CLP, RPG, RPGLE
I have a program which updates several A/R balance files. This program needs to run continuously every so many seconds to update our customers’ balances. How can I make this program a never ending program?
Answer Question
| December 25, 2009 3:00 PM
CLP, RPG, RPGLE
Using RPG constants in Static Embedded SQL
I have tried to use an RPG IV constant (D-Spec with a “C” usage and value) in embedded, static SQL as a host variable and the compiler fails. I was told this was possible, but so far I do not know how to do this. Not surprisingly, IBM documentation is practically worthless in trying to [...]
Answer Question
| December 25, 2009 8:26 PM
Application development, AS/400, RPGLE
I have tried to use an RPG IV constant (D-Spec with a “C” usage and value) in embedded, static SQL as a host variable and the compiler fails. I was told this was possible, but so far I do not know how to do this. Not surprisingly, IBM documentation is practically worthless in trying to [...]
Answer Question
| December 25, 2009 8:26 PM
Application development, AS/400, RPGLE
Using an array in embedded SQL in RPGLE
Is there a way to specify a host array element in a where clause in embedded SQL? This is what I am trying to do: C+ Where TkPart01 = dPart(01) C+ and TkQty01 = dQty(01) C+ and TkPart02 = dPart(02) C+ and TkQty02 = dQty(02) There’s more to it than that but that should give [...]
Answer Question
| November 30, 2006 11:17 AM
Application development, DB2 Universal Database, Development, RPGLE, SQL
Is there a way to specify a host array element in a where clause in embedded SQL? This is what I am trying to do: C+ Where TkPart01 = dPart(01) C+ and TkQty01 = dQty(01) C+ and TkPart02 = dPart(02) C+ and TkQty02 = dQty(02) There’s more to it than that but that should give [...]
Answer Question
| November 30, 2006 11:17 AM
Application development, DB2 Universal Database, Development, RPGLE, SQL
Read a externally described file and write the record to another externally decribed file using RPGLE.
The syntax that I have found is READ Filename (results) Datastructure name. Write filerecord name (results) Datastructure name. What is it that I am missing? I use externally described ‘DS’ in SQL programs for Fetch all the time. This application requires RPGLE. Compile error. RNF7701 20 1 The data structure is not allowed for the [...]
Answer Question
| October 15, 2008 2:16 PM
RPGLE
The syntax that I have found is READ Filename (results) Datastructure name. Write filerecord name (results) Datastructure name. What is it that I am missing? I use externally described ‘DS’ in SQL programs for Fetch all the time. This application requires RPGLE. Compile error. RNF7701 20 1 The data structure is not allowed for the [...]
Answer Question
| October 15, 2008 2:16 PM
RPGLE
Cataloging Stored Procedures
Need to know if anyone has a package or process to do the actual storing of information around a Stored Procedure? My area is being tasked with becoming the Librian for all of our stored procedures whether created with true Sequel or RGP with imbedded SQL. I am looking for a way out side of [...]
Answer Question
| December 25, 2009 6:55 AM
Application development, AS/400, Data mining/analysis, RPGLE
Need to know if anyone has a package or process to do the actual storing of information around a Stored Procedure? My area is being tasked with becoming the Librian for all of our stored procedures whether created with true Sequel or RGP with imbedded SQL. I am looking for a way out side of [...]
Answer Question
| December 25, 2009 6:55 AM
Application development, AS/400, Data mining/analysis, RPGLE
Debugging Group Jobs
Is there anybody to help me in getting the procedure for debugging a group job. Thank you for any help in advance. regards, Deepa
Answer Question
| December 13, 2010 1:47 AM
Application development, RPGLE
Is there anybody to help me in getting the procedure for debugging a group job. Thank you for any help in advance. regards, Deepa
Answer Question
| December 13, 2010 1:47 AM
Application development, RPGLE
CPYTOIMPF Nightmare
I am using this to transfer data from the S400 to the IFS. The data has to be tab delimited. I am the sending the data to a UNIX box. the problem is I am a getting a carriage return at the end of fields – and it appears to be random. Here is my [...]
Answer Question
| November 9, 2006 12:30 PM
Application development, CLP, RPG, RPGLE
I am using this to transfer data from the S400 to the IFS. The data has to be tab delimited. I am the sending the data to a UNIX box. the problem is I am a getting a carriage return at the end of fields – and it appears to be random. Here is my [...]
Answer Question
| November 9, 2006 12:30 PM
Application development, CLP, RPG, RPGLE
MS SQL Server 2000
Hi All, Can we connect remotely (from outside LAN) to a MS SQL server 2000 using enterprise manager? If so, what are the steps?
Answer Question
| November 13, 2006 12:53 AM
Access, Application development, Backup & recovery, CLP, Data analysis, Data mining/analysis, Data warehousing applications, Database, DataCenter, DB2, DB2 Universal Database, Desktops, Email, IBM Marketing Sound Off, Management, Microsoft Office, Microsoft Windows, Oracle, OS, Patch management, PC/Windows Connectivity, Printing, RPG, RPGLE, Security, Servers, SQL, SQL Server, Web development
Hi All, Can we connect remotely (from outside LAN) to a MS SQL server 2000 using enterprise manager? If so, what are the steps?
Answer Question
| November 13, 2006 12:53 AM
Access, Application development, Backup & recovery, CLP, Data analysis, Data mining/analysis, Data warehousing applications, Database, DataCenter, DB2, DB2 Universal Database, Desktops, Email, IBM Marketing Sound Off, Management, Microsoft Office, Microsoft Windows, Oracle, OS, Patch management, PC/Windows Connectivity, Printing, RPG, RPGLE, Security, Servers, SQL, SQL Server, Web development
OPNQRYF’s MAPFLD
I am trying to create an OPNQRYF and use MAPFLD. I need to place conitionally one of two fields into ALPHANAME, I defined in MAPFLD. These fields are conditionally placed as follows: LNAME ===> ALPHANAME if LNAME is filled. BUS_NAME==> ALPHANAME if LNAME is blank APHANAME is defined this way in MAPFLD. I would be [...]
Answer Question
| November 8, 2006 1:25 PM
Application development, AS/400, Data analysis, Database, DB2, DB2 Universal Database, IBM, IBM Marketing Sound Off, Oracle, RPGLE
I am trying to create an OPNQRYF and use MAPFLD. I need to place conitionally one of two fields into ALPHANAME, I defined in MAPFLD. These fields are conditionally placed as follows: LNAME ===> ALPHANAME if LNAME is filled. BUS_NAME==> ALPHANAME if LNAME is blank APHANAME is defined this way in MAPFLD. I would be [...]
Answer Question
| November 8, 2006 1:25 PM
Application development, AS/400, Data analysis, Database, DB2, DB2 Universal Database, IBM, IBM Marketing Sound Off, Oracle, RPGLE
SYNON vs COBOL
Hi All, This query is related to performance. I am currently in the process of changing an application from COBOL to Synon. The application uses a lot of I/O involving files. Upon converting the application to Synon, I find that the performance has declined – COBOL takes 8 minutes whereas Synon is taking 35 minutes. [...]
Answer Question
| December 25, 2009 11:27 AM
Application development, AS/400, CLP, DB2 Universal Database, Development, RPG, RPGLE
Hi All, This query is related to performance. I am currently in the process of changing an application from COBOL to Synon. The application uses a lot of I/O involving files. Upon converting the application to Synon, I find that the performance has declined – COBOL takes 8 minutes whereas Synon is taking 35 minutes. [...]
Answer Question
| December 25, 2009 11:27 AM
Application development, AS/400, CLP, DB2 Universal Database, Development, RPG, RPGLE
