scheduling a job
I have a job that needs to run the 5th of each month. I’ve looked into JOBSCDE but I haven’t see where I could schedule the job thru that. Do you know of an easy way to make that occur??
Answer Question
| December 15, 2009 2:33 PM
Application development, AS/400, DataCenter
I have a job that needs to run the 5th of each month. I’ve looked into JOBSCDE but I haven’t see where I could schedule the job thru that. Do you know of an easy way to make that occur??
Answer Question
| December 15, 2009 2:33 PM
Application development, AS/400, DataCenter
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
AS400 Development/Testing
Hi, To minimise our laboratory costs, I’m looking at a solution, which will allow me to test our products with an AS400 using the latest OS400 versions, without having to purchase an iSeries. Crazy? Maybe! SAP provide MiniSap (Windows based), which is a basic version of their system, but can be used for testing and [...]
Answer Question
| August 24, 2010 9:38 AM
Application development, AS/400, DataCenter, IBM Marketing Sound Off, Printing, Web development
Hi, To minimise our laboratory costs, I’m looking at a solution, which will allow me to test our products with an AS400 using the latest OS400 versions, without having to purchase an iSeries. Crazy? Maybe! SAP provide MiniSap (Windows based), which is a basic version of their system, but can be used for testing and [...]
Answer Question
| August 24, 2010 9:38 AM
Application development, AS/400, DataCenter, IBM Marketing Sound Off, Printing, Web development
Override the file name during batch FTP
We use ftp to send iseries files to our server. We use a script in a member in QTXTSRC. This script contains the library/file name to PUT. We would like change the file name in the CL to contain a date stamp and then use this file name to sent to the server. How can [...]
Answer Question
| December 15, 2009 1:04 PM
Application development, AS/400, DataCenter, Development
We use ftp to send iseries files to our server. We use a script in a member in QTXTSRC. This script contains the library/file name to PUT. We would like change the file name in the CL to contain a date stamp and then use this file name to sent to the server. How can [...]
Answer Question
| December 15, 2009 1:04 PM
Application development, AS/400, DataCenter, Development
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
cpyfrmimpf
We would like to automate a file transfer, and I thought to use the cpyfrmimpf cl command. The problem is that the .CSV file we wish to copy to our DB2 database has a header row that does not match the column data…some data must appear to the transfer as numeric. When I remove the [...]
Answer Question
| August 16, 2006 4:09 PM
Application development
We would like to automate a file transfer, and I thought to use the cpyfrmimpf cl command. The problem is that the .CSV file we wish to copy to our DB2 database has a header row that does not match the column data…some data must appear to the transfer as numeric. When I remove the [...]
Answer Question
| August 16, 2006 4:09 PM
Application development
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
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
Read Screen Data w/o Enter Key Being Pressed
I have both simple (non-subfile) and subfile dds-created screens. Would like the users to be able to press F10=Save to save screen data, without needing to press the Enter key to capture the data first. (Edits automatically run immediately after control returned to pgm.) Is this even possible? Especially with subfiles??? Programming in COBOL. Any [...]
Answer Question
| August 7, 2006 11:33 PM
Application development
I have both simple (non-subfile) and subfile dds-created screens. Would like the users to be able to press F10=Save to save screen data, without needing to press the Enter key to capture the data first. (Edits automatically run immediately after control returned to pgm.) Is this even possible? Especially with subfiles??? Programming in COBOL. Any [...]
Answer Question
| August 7, 2006 11:33 PM
Application development
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
Default Menu standards
How do I change the default menu layout template that is displayed after taking SDA option #2 to reflect our company standards? In other words; After typing the command “STRSDA 2″, the Design Menus prompt screen is displayed requesting a menu source file, library and menu name. Once that information is supplied and enter is [...]
Answer Question
| July 6, 2006 3:00 PM
Application development
How do I change the default menu layout template that is displayed after taking SDA option #2 to reflect our company standards? In other words; After typing the command “STRSDA 2″, the Design Menus prompt screen is displayed requesting a menu source file, library and menu name. Once that information is supplied and enter is [...]
Answer Question
| July 6, 2006 3:00 PM
Application development
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
Displaying Chinese on 5250 screens
Hello, I need to change some CL driven green-screen menus to display Chinese instead of English. We don’t need to change the applications or data behind the menus … just the menus themselves which are actually driven by message files with a display file and some CLP. Does anyone know of a straightforward solution on [...]
Answer Question
| December 11, 2009 3:48 PM
Application development, CLP, Printing, RPG
Hello, I need to change some CL driven green-screen menus to display Chinese instead of English. We don’t need to change the applications or data behind the menus … just the menus themselves which are actually driven by message files with a display file and some CLP. Does anyone know of a straightforward solution on [...]
Answer Question
| December 11, 2009 3:48 PM
Application development, CLP, Printing, RPG
DDS
Is there any way (field attribute, key word, etc.) to keep the beloved end user from not using the field exit key when entering a value in a numeric field ?? We have users who will continually use the tab key or just hit enter when entering a 1 (for example) in a field, thereby [...]
Answer Question
| July 10, 2006 11:38 AM
Application development, AS/400, RPG, RPGLE
Is there any way (field attribute, key word, etc.) to keep the beloved end user from not using the field exit key when entering a value in a numeric field ?? We have users who will continually use the tab key or just hit enter when entering a 1 (for example) in a field, thereby [...]
Answer Question
| July 10, 2006 11:38 AM
Application development, AS/400, RPG, RPGLE
Deleted Users
Hi Is there any way we can know about deleted userprofiles in AS400? We have an audit process wherein the auditor have asked for a list of all the users deleted. Can any one suggest where can I get such a list? pgsdeb
Answer Question
| November 22, 2010 7:44 AM
Application development, AS/400, AS/400 careers, Backup & recovery, CLP, DataCenter, DB2 Universal Database, Security
Hi Is there any way we can know about deleted userprofiles in AS400? We have an audit process wherein the auditor have asked for a list of all the users deleted. Can any one suggest where can I get such a list? pgsdeb
Answer Question
| November 22, 2010 7:44 AM
Application development, AS/400, AS/400 careers, Backup & recovery, CLP, DataCenter, DB2 Universal Database, Security
