Detecting FTP errors
Hi! I have a program that reads an FTP log and sends the user a message if there’s an error (4xx or 5xx). But there are some errors that do not indicate which is the error code (like connection errors). How can I capture these errors? Thanx in advance. Meli
Answer Question
| May 16, 2006 10:47 AM
CLP, RPGLE
Hi! I have a program that reads an FTP log and sends the user a message if there’s an error (4xx or 5xx). But there are some errors that do not indicate which is the error code (like connection errors). How can I capture these errors? Thanx in advance. Meli
Answer Question
| May 16, 2006 10:47 AM
CLP, RPGLE
The Right DDS Combination
Hi All, I have been spinning my wheels and was hoping for help. I have a subfile where an option calls another RPG program that displays a window for data capture. When the user takes the same option against multiple records in the subfile the window appears the first time overlaying the subfile screen, but [...]
Answer Question
| May 16, 2006 5:27 PM
AS/400, Printing, RPG, RPGLE
Hi All, I have been spinning my wheels and was hoping for help. I have a subfile where an option calls another RPG program that displays a window for data capture. When the user takes the same option against multiple records in the subfile the window appears the first time overlaying the subfile screen, but [...]
Answer Question
| May 16, 2006 5:27 PM
AS/400, Printing, RPG, RPGLE
Performance issue
Hi I am using an OPNQRYF in a program which is used quite frequently. Now, the program takes about 20 secs when called once. I tried to create some logicals which can expedite the access to files but there has not been any appreciable change in the performance. Can anyone suggest any other method which [...]
Answer Question
| December 7, 2009 10:47 AM
Application development, AS/400, AS/400 careers, Backup & recovery, CLP, DataCenter, DB2 Universal Database, Email, IBM Marketing Sound Off, PC/Windows Connectivity, Printing, RPG, RPGLE, Security, Web development
Hi I am using an OPNQRYF in a program which is used quite frequently. Now, the program takes about 20 secs when called once. I tried to create some logicals which can expedite the access to files but there has not been any appreciable change in the performance. Can anyone suggest any other method which [...]
Answer Question
| December 7, 2009 10:47 AM
Application development, AS/400, AS/400 careers, Backup & recovery, CLP, DataCenter, DB2 Universal Database, Email, IBM Marketing Sound Off, PC/Windows Connectivity, Printing, RPG, RPGLE, Security, Web development
compile commands in RPG
hey all! i am working on a project where i have to use compile commands for various member types, such as CRTRPGPGM for RPG, CRTPF for PF and so on.. but these commands have to run in the background, and the user should know nothing of it, i.e. it should be program oriented. how can [...]
Answer Question
| December 7, 2009 2:40 AM
Application development, AS/400, AS/400 careers, Backup & recovery, CLP, DataCenter, DB2 Universal Database, Email, IBM Marketing Sound Off, PC/Windows Connectivity, Printing, RPG, RPGLE, Security, Web development
hey all! i am working on a project where i have to use compile commands for various member types, such as CRTRPGPGM for RPG, CRTPF for PF and so on.. but these commands have to run in the background, and the user should know nothing of it, i.e. it should be program oriented. how can [...]
Answer Question
| December 7, 2009 2:40 AM
Application development, AS/400, AS/400 careers, Backup & recovery, CLP, DataCenter, DB2 Universal Database, Email, IBM Marketing Sound Off, PC/Windows Connectivity, Printing, RPG, RPGLE, Security, Web development
WRKNAMSMTP updating from CL
I am sure that this question has been asked many times before but have never seen any answers. Since there is no UPDNAMSMTP command how can I update the System alias table programatically from CL or RPG ?
Answer Question
| December 7, 2009 6:01 AM
CLP, Exchange, RPG, RPGLE
I am sure that this question has been asked many times before but have never seen any answers. Since there is no UPDNAMSMTP command how can I update the System alias table programatically from CL or RPG ?
Answer Question
| December 7, 2009 6:01 AM
CLP, Exchange, RPG, RPGLE
Program Status Data Structure
Hi All, For position 191 – 198 in the SDS, is this always the Date the Job Entered the system? For example, we have a CL that starts at 23:50 on say 5/10, it does some processing and on the way out it calls an RPG at say 0:35 on 5/11. Will the date in [...]
Answer Question
| December 7, 2009 1:54 PM
Application development, AS/400, CLP, RPG, RPGLE
Hi All, For position 191 – 198 in the SDS, is this always the Date the Job Entered the system? For example, we have a CL that starts at 23:50 on say 5/10, it does some processing and on the way out it calls an RPG at say 0:35 on 5/11. Will the date in [...]
Answer Question
| December 7, 2009 1:54 PM
Application development, AS/400, CLP, RPG, RPGLE
souce file listing
hi all! i wanna know how can i retrieve the names of the components of a Source Physical File i.e. the names of the souce code (members) within a particular Source Physical File…i want ot retrieve the names and store in a database file and later use them for subfile operations. kindly help me out!!!!!! [...]
Answer Question
| December 7, 2009 8:15 AM
Application development, AS/400, CLP, DB2 Universal Database, RPG, RPGLE
hi all! i wanna know how can i retrieve the names of the components of a Source Physical File i.e. the names of the souce code (members) within a particular Source Physical File…i want ot retrieve the names and store in a database file and later use them for subfile operations. kindly help me out!!!!!! [...]
Answer Question
| December 7, 2009 8:15 AM
Application development, AS/400, CLP, DB2 Universal Database, RPG, RPGLE
STRPCCMD
I am trying to use this command to open a PDF document from an iSeries ‘green screen’ It all works okay until I try to open one with a large path name – the command can only handle 123 characters. Does anyone know a way to get around this ? An API perhaps.
Answer Question
| May 10, 2006 6:27 AM
AS/400, RPGLE
I am trying to use this command to open a PDF document from an iSeries ‘green screen’ It all works okay until I try to open one with a large path name – the command can only handle 123 characters. Does anyone know a way to get around this ? An API perhaps.
Answer Question
| May 10, 2006 6:27 AM
AS/400, RPGLE
Record locking (or lack of it)
Bare with me a minute before you throw rocks, but is there a difference in record locking between a Chain and Read? Here’s what I’m looking at. We have a control file that contains the next note number. In all our applications we either chain or setll/read the control file, get the number, add one [...]
Answer Question
| May 3, 2006 2:22 PM
Application development, RPGLE
Bare with me a minute before you throw rocks, but is there a difference in record locking between a Chain and Read? Here’s what I’m looking at. We have a control file that contains the next note number. In all our applications we either chain or setll/read the control file, get the number, add one [...]
Answer Question
| May 3, 2006 2:22 PM
Application development, RPGLE
AS400 Console
What effects are caused if you vary off your console session on the AS400 and you do not have any other consoles to take over? I want to move my console to another location in my DataCenter, but I have to disconnect it from the AS400 and reconnect it. Will varying the device off to [...]
Answer Question
| May 3, 2006 10:55 AM
Application development, AS/400, AS/400 careers, Backup & recovery, CLP, DataCenter, DB2 Universal Database, Email, IBM Marketing Sound Off, PC/Windows Connectivity, Printing, RPG, RPGLE, Security, Web development
What effects are caused if you vary off your console session on the AS400 and you do not have any other consoles to take over? I want to move my console to another location in my DataCenter, but I have to disconnect it from the AS400 and reconnect it. Will varying the device off to [...]
Answer Question
| May 3, 2006 10:55 AM
Application development, AS/400, AS/400 careers, Backup & recovery, CLP, DataCenter, DB2 Universal Database, Email, IBM Marketing Sound Off, PC/Windows Connectivity, Printing, RPG, RPGLE, Security, Web development
ILE Program won’t compile
Hi, I’m just starting to get into ILE and i’ve created a Module with a with a Prototype, Procedure and Procedure-Interface definition. The problem is program from where i am trying to call the procedure. I won’t compile. I get the error “The name or indicator is not defined.” There some where in the calling [...]
Answer Question
| December 6, 2009 4:45 PM
AS/400, RPGLE
Hi, I’m just starting to get into ILE and i’ve created a Module with a with a Prototype, Procedure and Procedure-Interface definition. The problem is program from where i am trying to call the procedure. I won’t compile. I get the error “The name or indicator is not defined.” There some where in the calling [...]
Answer Question
| December 6, 2009 4:45 PM
AS/400, RPGLE
Generating Excel spread sheets from Sequel on the iseries
I produce an excel spread sheet from sequel on the as400 and e-mail it to a user. The user performs some data entry on the spread sheet. The spread sheet is then transfered to a AS400 Physical file and a program is called that updates a AS400 data base. The problem is when they enter [...]
Answer Question
| December 6, 2009 8:48 AM
Application development, AS/400, Data analysis, Development, RPG, RPGLE
I produce an excel spread sheet from sequel on the as400 and e-mail it to a user. The user performs some data entry on the spread sheet. The spread sheet is then transfered to a AS400 Physical file and a program is called that updates a AS400 data base. The problem is when they enter [...]
Answer Question
| December 6, 2009 8:48 AM
Application development, AS/400, Data analysis, Development, RPG, RPGLE
HOUSE KEEPING STREAM FILES
I would like to write a utility which housekeeps stream files in the ifs based upon how many days ago the file was CREATED. Does any body know an API for this (an API which is easy enough to work with ‘RPG’ and/or ‘CL’ and NOT ‘C’) The DSPLNK CL command doesn’t provide the creation [...]
Answer Question
| April 26, 2006 9:13 PM
AS/400, CLP, DataCenter, RPG, RPGLE
I would like to write a utility which housekeeps stream files in the ifs based upon how many days ago the file was CREATED. Does any body know an API for this (an API which is easy enough to work with ‘RPG’ and/or ‘CL’ and NOT ‘C’) The DSPLNK CL command doesn’t provide the creation [...]
Answer Question
| April 26, 2006 9:13 PM
AS/400, CLP, DataCenter, RPG, RPGLE
AS400 files created using DDS
Is there a way of creating specific non-display fields within an AS400 physical file created via DDS SRC?
Answer Question
| December 7, 2009 9:03 AM
Application development, RPGLE
Is there a way of creating specific non-display fields within an AS400 physical file created via DDS SRC?
Answer Question
| December 7, 2009 9:03 AM
Application development, RPGLE
Determine Java Version from RPG
I have multiple solutions dependent upon the version of java or the lack of java on an iSeries, all controlled from RPG. From RPG,how can I determine if java is installed on the machine and if installed, what version? Any ideas?
Answer Question
| December 4, 2009 11:49 PM
Application development, Development, Java, RPG ILE, RPGLE
I have multiple solutions dependent upon the version of java or the lack of java on an iSeries, all controlled from RPG. From RPG,how can I determine if java is installed on the machine and if installed, what version? Any ideas?
Answer Question
| December 4, 2009 11:49 PM
Application development, Development, Java, RPG ILE, RPGLE
Sending pcn files to the iseries
I have excel files on our server that I pass to the iseries as physical files. I do this through Client access ustn the data transfer to ISeries utility. I provide the PC location and file name, the system I wnat to go to and the library and file in the Iseries I want to [...]
Answer Question
| April 17, 2006 4:26 PM
Application development, AS/400, Development, RPG, RPGLE
I have excel files on our server that I pass to the iseries as physical files. I do this through Client access ustn the data transfer to ISeries utility. I provide the PC location and file name, the system I wnat to go to and the library and file in the Iseries I want to [...]
Answer Question
| April 17, 2006 4:26 PM
Application development, AS/400, Development, RPG, RPGLE
Physical / Logical file definitions
Can a logical file have fields that differ in definition of type than the physical? I’ve got a physical file with fields defined as: FLD1 A 20 1 20 FLD2 S 8 0 21 28 FLD3 S 11 2 29 39 and the logical defined as: FLD1 A 20 1 20 FLD2 P 8 0 [...]
Answer Question
| December 3, 2009 3:08 PM
DB2 Universal Database, RPG, RPGLE
Can a logical file have fields that differ in definition of type than the physical? I’ve got a physical file with fields defined as: FLD1 A 20 1 20 FLD2 S 8 0 21 28 FLD3 S 11 2 29 39 and the logical defined as: FLD1 A 20 1 20 FLD2 P 8 0 [...]
Answer Question
| December 3, 2009 3:08 PM
DB2 Universal Database, RPG, RPGLE
400 to 400 printing
I need to have a spoolfile on AS400#1 that is directed to an outq on AS400#2 as it is created and/or move it manually from outq on #1 to outq on #2. A remote outq exist on #2 but I seem to be missing something on how to access it from #1. The remote outq [...]
Answer Question
| November 19, 2010 10:18 AM
AS/400, DataCenter, Printing, RPGLE
I need to have a spoolfile on AS400#1 that is directed to an outq on AS400#2 as it is created and/or move it manually from outq on #1 to outq on #2. A remote outq exist on #2 but I seem to be missing something on how to access it from #1. The remote outq [...]
Answer Question
| November 19, 2010 10:18 AM
AS/400, DataCenter, Printing, RPGLE
System Setting For Created Libraries
Hi Everyone. An odd question, when we create new libraries on the 400 they are automatically flagged in the SETUPBCKUP screens for Daily/Weekly and Monthly backup. Where can I change this attribute for new libraries created on the system? Thanks, Rayden.
Answer Question
| November 15, 2010 2:29 PM
Application development, AS/400, Backup & recovery, DataCenter, DB2 Universal Database, RPG, RPGLE
Hi Everyone. An odd question, when we create new libraries on the 400 they are automatically flagged in the SETUPBCKUP screens for Daily/Weekly and Monthly backup. Where can I change this attribute for new libraries created on the system? Thanks, Rayden.
Answer Question
| November 15, 2010 2:29 PM
Application development, AS/400, Backup & recovery, DataCenter, DB2 Universal Database, RPG, RPGLE
Cursor Progression on protected fields
I want to use FLDCSRPRG to control the cursor movement on fields I have protected. The fields are protected because I need the user to prompt a lookup window and enter only correct selections from a specific table in these filds. However, If I protect the field with DSPATR(PR), the FLDCSRPRG does not work, the [...]
Answer Question
| March 22, 2006 11:48 AM
AS/400, RPG, RPGLE
I want to use FLDCSRPRG to control the cursor movement on fields I have protected. The fields are protected because I need the user to prompt a lookup window and enter only correct selections from a specific table in these filds. However, If I protect the field with DSPATR(PR), the FLDCSRPRG does not work, the [...]
Answer Question
| March 22, 2006 11:48 AM
AS/400, RPG, RPGLE
