TAB to skip field – SYNON
I have a synon screen pgm with 5 input fields – one below another. I am on first field, and on pressing TAB there, I want the cursor to go to third field skipping the second. How can I do that? Plz help.
Answer Question
| December 19, 2009 10:52 AM
Application development, AS/400, CLP, RPG
I have a synon screen pgm with 5 input fields – one below another. I am on first field, and on pressing TAB there, I want the cursor to go to third field skipping the second. How can I do that? Plz help.
Answer Question
| December 19, 2009 10:52 AM
Application development, AS/400, CLP, RPG
CL AS400 iSeries ILE Retrieve Source
Is there any way to retrieve source for an ILE CL program? I’m looking for a function equivalent to the RTVCLSRC command we use for retrieving the source for a CLP ?
Answer Question
| January 6, 2011 9:31 AM
Application development, AS/400, Backup & recovery, CLP, DataCenter, RPG, RPGLE
Is there any way to retrieve source for an ILE CL program? I’m looking for a function equivalent to the RTVCLSRC command we use for retrieving the source for a CLP ?
Answer Question
| January 6, 2011 9:31 AM
Application development, AS/400, Backup & recovery, CLP, DataCenter, RPG, RPGLE
Journal
How can i retrieve a record from a journal so that i can update the said record to another physical file. Because i want to retrieve the record created or updated from the journal so that i can update the other file. Thank you.
Answer Question
| December 12, 2010 9:55 PM
Application development, AS/400, Backup & recovery, CLP, RPG, RPGLE
How can i retrieve a record from a journal so that i can update the said record to another physical file. Because i want to retrieve the record created or updated from the journal so that i can update the other file. Thank you.
Answer Question
| December 12, 2010 9:55 PM
Application development, AS/400, Backup & recovery, CLP, RPG, RPGLE
clear physical file member question
is it possible for me to only clear certain records of a physical while leaving certain records available? I have a file with thousands of records, but I only need the records starting with a certain date. How can I delete everything prior to the date that i need with out totally wiping out the [...]
Answer Question
| December 17, 2009 9:25 AM
Application development, AS/400, Backup & recovery, CLP, DataCenter, RPG, Security
is it possible for me to only clear certain records of a physical while leaving certain records available? I have a file with thousands of records, but I only need the records starting with a certain date. How can I delete everything prior to the date that i need with out totally wiping out the [...]
Answer Question
| December 17, 2009 9:25 AM
Application development, AS/400, Backup & recovery, CLP, DataCenter, RPG, Security
Need Cobol 88 equivalent
I’m coding an RPG program and I need to find a technique that will allow me to evaluate the value of a variable to determine if it matches any one of a list or is within a range of given values. In Cobol I use 88 level entries in working storage. In other languages, SAS [...]
Answer Question
| December 17, 2009 9:50 AM
RPG
I’m coding an RPG program and I need to find a technique that will allow me to evaluate the value of a variable to determine if it matches any one of a list or is within a range of given values. In Cobol I use 88 level entries in working storage. In other languages, SAS [...]
Answer Question
| December 17, 2009 9:50 AM
RPG
CPYFRMIMPF issue
Okay, here’s the deal. I’ve got a tab delimited file that used to load perfectly fine into file using the CPYFRMIMPF command, using the following options; CPYFRMIMPF FROMSTMF(‘/Directory of file/file.txt’) TOFILE(Library/file) MBROPT(*REPLACE) RCDDLM(*CRLF) STRDLM(*NONE) RMVBLANK(*NONE) FLDDLM(*TAB) RPLNULLVAL(*FLDDFT) After much research, I’m pretty sure that the issue lies in the changes to the CPYFRMIMPF command in [...]
Answer Question
| December 17, 2009 3:48 PM
AS/400, DB2 Universal Database, RPG, RPGLE
Okay, here’s the deal. I’ve got a tab delimited file that used to load perfectly fine into file using the CPYFRMIMPF command, using the following options; CPYFRMIMPF FROMSTMF(‘/Directory of file/file.txt’) TOFILE(Library/file) MBROPT(*REPLACE) RCDDLM(*CRLF) STRDLM(*NONE) RMVBLANK(*NONE) FLDDLM(*TAB) RPLNULLVAL(*FLDDFT) After much research, I’m pretty sure that the issue lies in the changes to the CPYFRMIMPF command in [...]
Answer Question
| December 17, 2009 3:48 PM
AS/400, DB2 Universal Database, RPG, RPGLE
When doing a chain the (HI) indicator return with ’1′. But if I do a query on the same file I can see that the record is in the file.
I have a program in RPGIII. In the production environment the users are getting the following error message: RPG1221: (Issued update or delete in SDFBOBS0 without prior READ or CHAIN). I thought i shall put this program in my test environment and try to do the same as what the users have done in the [...]
Answer Question
| April 26, 2012 11:01 AM
Application development, AS/400, RPG, RPGLE
I have a program in RPGIII. In the production environment the users are getting the following error message: RPG1221: (Issued update or delete in SDFBOBS0 without prior READ or CHAIN). I thought i shall put this program in my test environment and try to do the same as what the users have done in the [...]
Answer Question
| April 26, 2012 11:01 AM
Application development, AS/400, RPG, RPGLE
Authorization problem on DDM file in RPG program
I have a RPG program that accesses three DDM files on another iSeries. The program compiles, but I receive error CPF9822-Not authorized to file XXXX in library XXXX. Cannot open DDM file. I have *SECOFR rights on both machines. Can someone help me?
Answer Question
| December 5, 2010 8:50 AM
DB2 Universal Database, RPG, Security
I have a RPG program that accesses three DDM files on another iSeries. The program compiles, but I receive error CPF9822-Not authorized to file XXXX in library XXXX. Cannot open DDM file. I have *SECOFR rights on both machines. Can someone help me?
Answer Question
| December 5, 2010 8:50 AM
DB2 Universal Database, RPG, Security
CPF5152
Hello, I am experiencing a strange problem that is driving me crazy. First what I am attempting to accomplish is to read a DSPF file looking for specific output records and then write to a source file lines of RPG III code to output to those fields. What is happening is that after the 44th [...]
Answer Question
| August 18, 2006 10:34 AM
Application development, CLP, DB2 Universal Database, RPG
Hello, I am experiencing a strange problem that is driving me crazy. First what I am attempting to accomplish is to read a DSPF file looking for specific output records and then write to a source file lines of RPG III code to output to those fields. What is happening is that after the 44th [...]
Answer Question
| August 18, 2006 10:34 AM
Application development, CLP, DB2 Universal Database, RPG
Access Oracle/Sybase/Informix from RPG
Hi, I would like to access Oracle/Sybase/Informix directly from within an RPG program. This is something similar to ODBC but in reverse – my data source is external to the iSeries and my application and APIs, or called routines, internal in the iSeries. The access to the external database should: 1. Not employ another server. [...]
Answer Question
| November 28, 2011 8:29 AM
Application development, AS/400, Database, DataCenter, DB2, DB2 Universal Database, Oracle, RPG, RPGLE, SQL, Web development
Hi, I would like to access Oracle/Sybase/Informix directly from within an RPG program. This is something similar to ODBC but in reverse – my data source is external to the iSeries and my application and APIs, or called routines, internal in the iSeries. The access to the external database should: 1. Not employ another server. [...]
Answer Question
| November 28, 2011 8:29 AM
Application development, AS/400, Database, DataCenter, DB2, DB2 Universal Database, Oracle, RPG, RPGLE, SQL, Web development
How can you send a Reverse Image message to users message que
I am attempting to send a Reverse Image message to a users message que with the SNDMSG command. I am attempting to put the ‘X21′ attribute (Green Reverse Image) on the message so that the message appears in Reverse Image and stands out for the user. I have seen this done before but cannnot remember [...]
Answer Question
| August 11, 2006 9:58 AM
AS/400, CLP, RPG, RPG ILE, RPGLE
I am attempting to send a Reverse Image message to a users message que with the SNDMSG command. I am attempting to put the ‘X21′ attribute (Green Reverse Image) on the message so that the message appears in Reverse Image and stands out for the user. I have seen this done before but cannnot remember [...]
Answer Question
| August 11, 2006 9:58 AM
AS/400, CLP, RPG, RPG ILE, RPGLE
SETLL and READE or CHAIN? Performance Issues
HI, I have a batch RPG programs used to do some updataions and reporting, currently the job takes around 1 sec to process a record. We want to further reduce this time. Changing the run Priorty may make the job run a bit faster, are there any other parameters that can be used? also am [...]
Answer Question
| December 15, 2009 7:34 AM
Application development, AS/400, Billing and customer care, Billing Support Systems, DataCenter, Development, Functional, Performance/Load, Printing, RPG, RPG ILE, RPGLE
HI, I have a batch RPG programs used to do some updataions and reporting, currently the job takes around 1 sec to process a record. We want to further reduce this time. Changing the run Priorty may make the job run a bit faster, are there any other parameters that can be used? also am [...]
Answer Question
| December 15, 2009 7:34 AM
Application development, AS/400, Billing and customer care, Billing Support Systems, DataCenter, Development, Functional, Performance/Load, Printing, RPG, RPG ILE, RPGLE
How to make a batch job run faster (excpet for the run priorty), Code changes?
HI, I have a batch RPG programs used to do some updataions and reporting, currently the job takes around 1 sec to process a record. We want to further reduce this time. Changing the run Priorty may make the job run a bit faster, are there any other parameters that can be used? also am [...]
Answer Question
| December 15, 2009 6:46 AM
Application development, AS/400, Billing and customer care, Billing Support Systems, DataCenter, Development, Performance/Load, RPG, RPG ILE, RPGLE, Software
HI, I have a batch RPG programs used to do some updataions and reporting, currently the job takes around 1 sec to process a record. We want to further reduce this time. Changing the run Priorty may make the job run a bit faster, are there any other parameters that can be used? also am [...]
Answer Question
| December 15, 2009 6:46 AM
Application development, AS/400, Billing and customer care, Billing Support Systems, DataCenter, Development, Performance/Load, RPG, RPG ILE, RPGLE, Software
Date Keyfield in a Physical File
Hi, Is it possible to have a Date as one of the Keyfield in a Physical File and access the same in a RPG/RPGLE Program using the KeyList?
Answer Question
| December 14, 2009 10:58 AM
AS/400, RPG, RPGLE
Hi, Is it possible to have a Date as one of the Keyfield in a Physical File and access the same in a RPG/RPGLE Program using the KeyList?
Answer Question
| December 14, 2009 10:58 AM
AS/400, RPG, RPGLE
Stored Procedures on AS/400
Greetings, I understand SQL stored procedures on the AS/400 generate C source code which is compiled to create a C ILE program object. I could use the same SQL statements in an RPGLE with embedded SQL program and use that to create a RPG stored procedure. Which of the two is more efficient? Thanks for [...]
Answer Question
| December 14, 2009 10:58 AM
Application development, AS/400, Database, DB2, DB2 Universal Database, Development, Oracle, PC/Windows Connectivity, RPG, RPGLE, SQL, SQL Server, Web development, Web development tools, WebSphere Studio
Greetings, I understand SQL stored procedures on the AS/400 generate C source code which is compiled to create a C ILE program object. I could use the same SQL statements in an RPGLE with embedded SQL program and use that to create a RPG stored procedure. Which of the two is more efficient? Thanks for [...]
Answer Question
| December 14, 2009 10:58 AM
Application development, AS/400, Database, DB2, DB2 Universal Database, Development, Oracle, PC/Windows Connectivity, RPG, RPGLE, SQL, SQL Server, Web development, Web development tools, WebSphere Studio
Source highlighting using NetManage Rumba
Has anyone developed a keyboard macro, VB Script or WSCST object that will let you enter the hex values necessary to highlight source code in SEU while using Rumba? I found a few examples for CA/400, but not for Rumba. TIA…Chuck
Answer Question
| December 18, 2009 8:52 PM
Application development, AS/400, DataCenter, PC/Windows Connectivity, RPG, RPGLE
Has anyone developed a keyboard macro, VB Script or WSCST object that will let you enter the hex values necessary to highlight source code in SEU while using Rumba? I found a few examples for CA/400, but not for Rumba. TIA…Chuck
Answer Question
| December 18, 2009 8:52 PM
Application development, AS/400, DataCenter, PC/Windows Connectivity, RPG, RPGLE
Job Schedule Entries Migration
Hi All, We are migrating from an 820 to a new 550 i5 this weekend. Does anyone know how we can migrate the current Job Schedule Entries on the 820 to the 550? Is there an API to the database that holds the Job Schedule Entry details that we can use to extract the info [...]
Answer Question
| December 13, 2009 9:18 AM
Application development, AS/400, Backup & recovery, CLP, DataCenter, DB2 Universal Database, RPG, RPGLE
Hi All, We are migrating from an 820 to a new 550 i5 this weekend. Does anyone know how we can migrate the current Job Schedule Entries on the 820 to the 550? Is there an API to the database that holds the Job Schedule Entry details that we can use to extract the info [...]
Answer Question
| December 13, 2009 9:18 AM
Application development, AS/400, Backup & recovery, CLP, DataCenter, DB2 Universal Database, RPG, RPGLE
Implementing RUP in Retail business which runs on i-Series
A retail company is planning to implement IBM Rational Unified Process for its business which runs on i-Series. Please let me know how well RUP can be implemented here. How well RUP works for i-Series software development? What are the tailoring to be done to this process for i-Series? Also, please comment on the RUP [...]
Answer Question
| July 24, 2006 7:21 AM
Application development, AS/400, Automated, Budgeting, Business/IT alignment, Career development, Compliance, DataCenter, Development, Functional, Laws, Lifecycle development, Performance/Load, Project management, Regulations, ROI & cost justification, RPG, RPGLE, Software Quality Assurance, Software testing, Software testing tools, standards, Vendors
A retail company is planning to implement IBM Rational Unified Process for its business which runs on i-Series. Please let me know how well RUP can be implemented here. How well RUP works for i-Series software development? What are the tailoring to be done to this process for i-Series? Also, please comment on the RUP [...]
Answer Question
| July 24, 2006 7:21 AM
Application development, AS/400, Automated, Budgeting, Business/IT alignment, Career development, Compliance, DataCenter, Development, Functional, Laws, Lifecycle development, Performance/Load, Project management, Regulations, ROI & cost justification, RPG, RPGLE, Software Quality Assurance, Software testing, Software testing tools, standards, Vendors
SQLCOD = -7008 when doing an insert into file using SQLRPGLE-2
Hi, I’m trying to insert selective records from one file into the same file in another library. I have to do this for many file. Am building the query dynamically using SQLRPGLE. Am using a PREPARE statement and an EXECUTE statement to run the query. While the PREPARE statement ends fine, am getting an SQLCOD [...]
Answer Question
| December 11, 2009 12:45 PM
Application development, AS/400, Backup & recovery, CLP, DB2 Universal Database, RPG, RPGLE
Hi, I’m trying to insert selective records from one file into the same file in another library. I have to do this for many file. Am building the query dynamically using SQLRPGLE. Am using a PREPARE statement and an EXECUTE statement to run the query. While the PREPARE statement ends fine, am getting an SQLCOD [...]
Answer Question
| December 11, 2009 12:45 PM
Application development, AS/400, Backup & recovery, CLP, DB2 Universal Database, RPG, RPGLE
SQLCOD = -7008 when doing an insert into file using SQLRPGLE
Hi, I’m trying to insert selective records from one file into the same file in another library. I have to do this for many file. Am building the query dynamically using SQLRPGLE. Am using a PREPARE statement and an EXECUTE statement to run the query. While the PREPARE statement ends fine, am getting an SQLCOD [...]
Answer Question
| January 29, 2010 12:44 PM
Application development, AS/400, Backup & recovery, CLP, DB2 Universal Database, RPG, RPGLE
Hi, I’m trying to insert selective records from one file into the same file in another library. I have to do this for many file. Am building the query dynamically using SQLRPGLE. Am using a PREPARE statement and an EXECUTE statement to run the query. While the PREPARE statement ends fine, am getting an SQLCOD [...]
Answer Question
| January 29, 2010 12:44 PM
Application development, AS/400, Backup & recovery, CLP, DB2 Universal Database, RPG, RPGLE
