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
Single quotes around a CL variable
The easiest way to do the above please
Answer Question
| November 7, 2006 6:47 AM
Application development, CLP
The easiest way to do the above please
Answer Question
| November 7, 2006 6:47 AM
Application development, CLP
Display Footers in Subfiles
Hi, I have a dual display subfile. I am able to do display the screens allright but it’s the footer record i am unable to display at all. I have made sure that the second subfile record doesn’t overlap my footer area (by footer, i mean the area where i want to display my Function [...]
Answer Question
| November 6, 2006 10:57 AM
Application development, RPG, RPGLE
Hi, I have a dual display subfile. I am able to do display the screens allright but it’s the footer record i am unable to display at all. I have made sure that the second subfile record doesn’t overlap my footer area (by footer, i mean the area where i want to display my Function [...]
Answer Question
| November 6, 2006 10:57 AM
Application development, RPG, RPGLE
Using S/36 object members (load and subroutine) on AS/400
Hello, We are looking for IBM-supplied commands that will convert and/or run S/36 object members (load and subroutine members) to useable AS/400 system objects. The fact is that we lost the RPG source code from the S/36; so there is no source to compile on the AS/400. We look forward to your help. OUMAROU Daouda
Answer Question
| November 6, 2006 7:07 AM
Application development, DataCenter, RPG
Hello, We are looking for IBM-supplied commands that will convert and/or run S/36 object members (load and subroutine members) to useable AS/400 system objects. The fact is that we lost the RPG source code from the S/36; so there is no source to compile on the AS/400. We look forward to your help. OUMAROU Daouda
Answer Question
| November 6, 2006 7:07 AM
Application development, DataCenter, RPG
MONMSG and SNDRPY
Dear, I’m trying to write a small program to run my backup job via BRMS… and I would like to check the different errors and reply automatically to few of them. Ok, I can monitor the error messages through MONMSG but how can I reply to them ? I know that I have to use [...]
Answer Question
| December 25, 2009 3:00 AM
Application development, CLP, RPG, RPG ILE
Dear, I’m trying to write a small program to run my backup job via BRMS… and I would like to check the different errors and reply automatically to few of them. Ok, I can monitor the error messages through MONMSG but how can I reply to them ? I know that I have to use [...]
Answer Question
| December 25, 2009 3:00 AM
Application development, CLP, RPG, RPG ILE
FTP from Client site
I am trying to receive data from a client site into an externally described file on my ISerie. Data will be received daily and the file name is date stamped, (for example:filea103106, filea110106)my problem is that since it needs to be copied into MYLIB/MYFILE, I cannot use the MGET filea* to copy it in that [...]
Answer Question
| December 25, 2009 10:39 AM
Application development, AS/400
I am trying to receive data from a client site into an externally described file on my ISerie. Data will be received daily and the file name is date stamped, (for example:filea103106, filea110106)my problem is that since it needs to be copied into MYLIB/MYFILE, I cannot use the MGET filea* to copy it in that [...]
Answer Question
| December 25, 2009 10:39 AM
Application development, AS/400
create computations on the fly
We are primarily a COBOL shop. We have some COBOL ILE and some RPG. I have a need to replicate a function on the I-series that is currently done in Excel. This function allows them to create formulas on the fly to arrive at pricing information. I can work through issues with interactive maintenance of [...]
Answer Question
| December 26, 2009 12:47 PM
Application development, AS/400, CLP, COBOL, Development, Programming Languages, Retail/point-of-sale applications, RPG, RPG ILE, RPGLE, Web development
We are primarily a COBOL shop. We have some COBOL ILE and some RPG. I have a need to replicate a function on the I-series that is currently done in Excel. This function allows them to create formulas on the fly to arrive at pricing information. I can work through issues with interactive maintenance of [...]
Answer Question
| December 26, 2009 12:47 PM
Application development, AS/400, CLP, COBOL, Development, Programming Languages, Retail/point-of-sale applications, RPG, RPG ILE, RPGLE, Web development
Transition from RPG fixed-format to Free-Format
We are an iSeries installation (V5R3) with a team of 6 developers. Our background is good old-fashioned RPG but 2 of our team members have started coding in free-format, having bought a book but with no formal training undertaken. It is a given that the future is in free-format, but, going forward, I would like [...]
Answer Question
| June 16, 2008 1:43 AM
Application development
We are an iSeries installation (V5R3) with a team of 6 developers. Our background is good old-fashioned RPG but 2 of our team members have started coding in free-format, having bought a book but with no formal training undertaken. It is a given that the future is in free-format, but, going forward, I would like [...]
Answer Question
| June 16, 2008 1:43 AM
Application development
MACPAC from V5R2 to V5R3
We are looking to upgrade from V5R2 to V5R3 and we are a macpac SHOP. I understand that there are some required PTF’s from MACPAC support that are required to go to V5R3. Has anyone gone to V5R3 with out these so called PTF’s? Anyone have any idea what these PTF’s are? What could MACPAC [...]
Answer Question
| October 26, 2006 9:10 PM
Application development, AS/400, DataCenter
We are looking to upgrade from V5R2 to V5R3 and we are a macpac SHOP. I understand that there are some required PTF’s from MACPAC support that are required to go to V5R3. Has anyone gone to V5R3 with out these so called PTF’s? Anyone have any idea what these PTF’s are? What could MACPAC [...]
Answer Question
| October 26, 2006 9:10 PM
Application development, AS/400, DataCenter
Increase Size of Network Storage Area
I have a client that needs to increase the size of the NWS being used with Windows Server 2003. It is a mapped drive for all users. Can anyone help with the steps required to change the size and maintain the drive mapping? They are on V5R3. Any suggestions will be appreciated.
Answer Question
| November 3, 2006 5:27 PM
Application development, AS/400, DataCenter
I have a client that needs to increase the size of the NWS being used with Windows Server 2003. It is a mapped drive for all users. Can anyone help with the steps required to change the size and maintain the drive mapping? They are on V5R3. Any suggestions will be appreciated.
Answer Question
| November 3, 2006 5:27 PM
Application development, AS/400, DataCenter
Looking for a Jacada User Group
I am trying to determine if anyone has created a Jacada User Group or would be interested in starting a Jacada User Group. My company currently uses the JIS product.
Answer Question
| November 2, 2006 4:07 PM
Application development, Development, PC/Windows Connectivity, Software, Web development, Web development tools
I am trying to determine if anyone has created a Jacada User Group or would be interested in starting a Jacada User Group. My company currently uses the JIS product.
Answer Question
| November 2, 2006 4:07 PM
Application development, Development, PC/Windows Connectivity, Software, Web development, Web development tools
Optical storage
I am trying to copy database files from the iSeries to a DVD (optical storage) and would like the files on the DVD created in ASCII text format. Similar to a data transfer from the iSeries, you can specify the file type ASCII text. The database files are actually spooled files that were copied to [...]
Answer Question
| December 25, 2009 9:47 AM
Application development, AS/400, Backup & recovery, DataCenter, DB2 Universal Database
I am trying to copy database files from the iSeries to a DVD (optical storage) and would like the files on the DVD created in ASCII text format. Similar to a data transfer from the iSeries, you can specify the file type ASCII text. The database files are actually spooled files that were copied to [...]
Answer Question
| December 25, 2009 9:47 AM
Application development, AS/400, Backup & recovery, DataCenter, DB2 Universal Database
Tools for DDS to DDL migration
Hi, My Profile: I have a legacy DDS defined DB2/400 database and my IT staff are telling me that for true SQL/ODBC access we either need to migrate the database over to DDL defined tables or add unique indexes to the existing DDS structure. My Question: Do we really need to alter the DDS database [...]
Answer Question
| October 26, 2006 11:21 AM
Application development, Database, DB2, DB2 Universal Database, Oracle
Hi, My Profile: I have a legacy DDS defined DB2/400 database and my IT staff are telling me that for true SQL/ODBC access we either need to migrate the database over to DDL defined tables or add unique indexes to the existing DDS structure. My Question: Do we really need to alter the DDS database [...]
Answer Question
| October 26, 2006 11:21 AM
Application development, Database, DB2, DB2 Universal Database, Oracle
QDLS and the IFS
How can I access the QDLS library in a CLLE program? I am using the copy database to an optical file command and CLLE program (CPYDBOPT). I created a folder called “Optical”. I can see this folder using iSeries Navigator. I don’t see a QDLS library on my iSeries when use I use the work [...]
Answer Question
| October 20, 2006 11:59 AM
Application development, Backup & recovery, CLP, RPGLE
How can I access the QDLS library in a CLLE program? I am using the copy database to an optical file command and CLLE program (CPYDBOPT). I created a folder called “Optical”. I can see this folder using iSeries Navigator. I don’t see a QDLS library on my iSeries when use I use the work [...]
Answer Question
| October 20, 2006 11:59 AM
Application development, Backup & recovery, CLP, RPGLE
Connect:Direct CDSND command
Has anybody used this software to send data? We are sending a native file, and were wondering if there was a way to have the file converted to tab delimited on the CDSND command? Or, do we have to tab delimit it to the IFS and CDSND from there ?
Answer Question
| October 21, 2006 5:43 AM
Application development, AS/400, CLP, DB2 Universal Database, PC/Windows Connectivity
Has anybody used this software to send data? We are sending a native file, and were wondering if there was a way to have the file converted to tab delimited on the CDSND command? Or, do we have to tab delimit it to the IFS and CDSND from there ?
Answer Question
| October 21, 2006 5:43 AM
Application development, AS/400, CLP, DB2 Universal Database, PC/Windows Connectivity
iSeries (AS/400) – Wanting to print to PDF using GhostScript or other software
We have PostScript files on the AS/400 and we need to convert them to PCL for printing and also to PDF. Having much trouble getting Ghostscript even to compile on the AS/400, so I am looking for another “free” method to do what we need. Our software runs in a browser window connected to the [...]
Answer Question
| October 26, 2006 4:29 PM
Application development, AS/400, CLP, DataCenter, Development, Networking, Printers, Printing, Web development
We have PostScript files on the AS/400 and we need to convert them to PCL for printing and also to PDF. Having much trouble getting Ghostscript even to compile on the AS/400, so I am looking for another “free” method to do what we need. Our software runs in a browser window connected to the [...]
Answer Question
| October 26, 2006 4:29 PM
Application development, AS/400, CLP, DataCenter, Development, Networking, Printers, Printing, Web development
Array Corruption
I have written an RPGLE pgm in which I took an array with a size of 400 (20 fields with a length of 20) and did a MOVEA to put it inside a character field of 400. I then passed this field to another program and I did a MOVEA to populate the array in [...]
Answer Question
| December 24, 2009 11:14 AM
Application development, CLP, RPG, Security
I have written an RPGLE pgm in which I took an array with a size of 400 (20 fields with a length of 20) and did a MOVEA to put it inside a character field of 400. I then passed this field to another program and I did a MOVEA to populate the array in [...]
Answer Question
| December 24, 2009 11:14 AM
Application development, CLP, RPG, Security
Zebra printers on an iSeries platform
I am on an assignment that has me pulling out what little hair I have remaining. Zebra printers use a language caled ZPL to print thermal labels. Problem is, there is no tool I can locate on the iSeries that produces ZPL code. Zebra offers a product that is PC based. It produces ZPL code [...]
Answer Question
| July 30, 2008 1:10 PM
Application development, AS/400, Printers, Printing, RPG ILE, RPGLE
I am on an assignment that has me pulling out what little hair I have remaining. Zebra printers use a language caled ZPL to print thermal labels. Problem is, there is no tool I can locate on the iSeries that produces ZPL code. Zebra offers a product that is PC based. It produces ZPL code [...]
Answer Question
| July 30, 2008 1:10 PM
Application development, AS/400, Printers, Printing, RPG ILE, RPGLE
Subfiles – RtnCsrLoc
I understand that you can use the RtnCsrLoc to retrieve the cursor position and field name. However, is there a way to force values into RtnCsrLoc? This would be best stated with an example. I have 2 fields on my subfile control record. The first Payment type and the second credit card number. My problem [...]
Answer Question
| October 11, 2006 12:57 PM
Application development, RPGLE
I understand that you can use the RtnCsrLoc to retrieve the cursor position and field name. However, is there a way to force values into RtnCsrLoc? This would be best stated with an example. I have 2 fields on my subfile control record. The first Payment type and the second credit card number. My problem [...]
Answer Question
| October 11, 2006 12:57 PM
Application development, RPGLE
Using API : unlink()
Hello All, Is anyone aware of “authorities” issues related to this API? I am creating .PDF files in the IFS area of our iSeries box and some users are unable to recreate a .PDF if they did not create it. In an attempt to avoid this I would like to use this API to “unlink” [...]
Answer Question
| December 24, 2009 9:12 AM
Application development, AS/400, RPGLE
Hello All, Is anyone aware of “authorities” issues related to this API? I am creating .PDF files in the IFS area of our iSeries box and some users are unable to recreate a .PDF if they did not create it. In an attempt to avoid this I would like to use this API to “unlink” [...]
Answer Question
| December 24, 2009 9:12 AM
Application development, AS/400, RPGLE
