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
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
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
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
converting a numeric to character
How do I get a number into char format so I can manipulate the string
Answer Question
| June 18, 2008 5:21 AM
RPG, RPGLE
How do I get a number into char format so I can manipulate the string
Answer Question
| June 18, 2008 5:21 AM
RPG, RPGLE
Logical file to include only one of many matching records in secondaryu file
I have a one to many relationship between 2 files. Although there are multiple matching records in the secondary file, the fields I am interested in are common. THerefore i only want one of the secondary records to join to the primary record – avaioding duplicate logical records. I know this could probably be achieved [...]
Answer Question
| December 24, 2009 8:03 AM
DB2 Universal Database, RPG, RPGLE
I have a one to many relationship between 2 files. Although there are multiple matching records in the secondary file, the fields I am interested in are common. THerefore i only want one of the secondary records to join to the primary record – avaioding duplicate logical records. I know this could probably be achieved [...]
Answer Question
| December 24, 2009 8:03 AM
DB2 Universal Database, RPG, RPGLE
Running a job in SQL 2005 by calling a batch file from a As400 CL program
Hi, I already asked this question before but did not get any reply. Anybody please help.. I am calling a job on AS400 which uses RUNRMTCMD to execute a batch file on sqlserver 2005 server. This batch file uses sqlcmd command to run a job on sqlserver. When I execute this batch file manually from [...]
Answer Question
| December 24, 2009 10:43 AM
AS/400, Availability, DataCenter, Desktops, Development, Management, Microsoft Windows, Networking, OS, Patch management, RPG, RPGLE, Security, Servers, SQL, SQL Server
Hi, I already asked this question before but did not get any reply. Anybody please help.. I am calling a job on AS400 which uses RUNRMTCMD to execute a batch file on sqlserver 2005 server. This batch file uses sqlcmd command to run a job on sqlserver. When I execute this batch file manually from [...]
Answer Question
| December 24, 2009 10:43 AM
AS/400, Availability, DataCenter, Desktops, Development, Management, Microsoft Windows, Networking, OS, Patch management, RPG, RPGLE, Security, Servers, SQL, SQL Server
RPGLE & SQL
I am writing my first SQl in an RPG The statement I am using is: UPDATE AQUA20/XNMSGX SET ISTS = ‘d’, ISTATE = ‘a’ WHERE ISTS=’C’ and ISTATE=’C'and idate<20010501 1. Does the statement look okay 2. Can I, and how would I, use a variable in the statement – the date I am checking against [...]
Answer Question
| October 25, 2006 7:25 AM
RPG, RPGLE
I am writing my first SQl in an RPG The statement I am using is: UPDATE AQUA20/XNMSGX SET ISTS = ‘d’, ISTATE = ‘a’ WHERE ISTS=’C’ and ISTATE=’C'and idate<20010501 1. Does the statement look okay 2. Can I, and how would I, use a variable in the statement – the date I am checking against [...]
Answer Question
| October 25, 2006 7:25 AM
RPG, RPGLE
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
Variable page heading in query
I have created a query in which I am passing parameters. The query works great but I was wondering is there a way to make the page heading variable? For example, if the user needed a report on a particular vendor and this parameter was passed to my query, I would want the report heading [...]
Answer Question
| December 24, 2009 1:35 PM
AS/400, RPG
I have created a query in which I am passing parameters. The query works great but I was wondering is there a way to make the page heading variable? For example, if the user needed a report on a particular vendor and this parameter was passed to my query, I would want the report heading [...]
Answer Question
| December 24, 2009 1:35 PM
AS/400, RPG
Learning FTP from the bottom up…
Are there any good resources available on the web that can give me the basics (most often used/needed) FTP commands. Or, can anyone give me the details of the most commonly used commands. I’ve got to strart doing some FTP’ing in this new job.
Answer Question
| October 11, 2006 4:59 AM
AS/400, DataCenter, Email, PC/Windows Connectivity, RPG, RPGLE
Are there any good resources available on the web that can give me the basics (most often used/needed) FTP commands. Or, can anyone give me the details of the most commonly used commands. I’ve got to strart doing some FTP’ing in this new job.
Answer Question
| October 11, 2006 4:59 AM
AS/400, DataCenter, Email, PC/Windows Connectivity, RPG, RPGLE
Alternate Collating Sequence
I have a logical file keyed by email address and defined with ALTSEQ and dynamic select/omit. My problem is if I perform a READEQ for a specific key value, only records with lower-case keys are returned. I expected the upper-case entries to also be returned. Can anyone shed any light on why this might occur [...]
Answer Question
| December 24, 2009 3:26 PM
AS/400, DB2 Universal Database, RPG
I have a logical file keyed by email address and defined with ALTSEQ and dynamic select/omit. My problem is if I perform a READEQ for a specific key value, only records with lower-case keys are returned. I expected the upper-case entries to also be returned. Can anyone shed any light on why this might occur [...]
Answer Question
| December 24, 2009 3:26 PM
AS/400, DB2 Universal Database, RPG
Query Security
I have written several queries which I don’t want others to change. I edited the authority for this query and changed the object authority to *EXCLUDE for user *PUBLIC and all other authorized users. However, users are still able to access and change my queries. Why? What do I need to do?
Answer Question
| October 6, 2006 8:33 AM
RPG, RPGLE, Security
I have written several queries which I don’t want others to change. I edited the authority for this query and changed the object authority to *EXCLUDE for user *PUBLIC and all other authorized users. However, users are still able to access and change my queries. Why? What do I need to do?
Answer Question
| October 6, 2006 8:33 AM
RPG, RPGLE, Security
CLP training tutorial
hello, I was wondering if there were any CLP programming tutorials available? Or maybe even some sort of online training? Cedric
Answer Question
| October 5, 2006 5:45 PM
CLP, RPG
hello, I was wondering if there were any CLP programming tutorials available? Or maybe even some sort of online training? Cedric
Answer Question
| October 5, 2006 5:45 PM
CLP, RPG
Tab delimited file
I have been asked to produce a file in an RPG program. The file is being used in some kind of interface and needs to be ‘tab delimited’ What is tab delimited? How do I create a tab-delimited file? Thanks
Answer Question
| December 23, 2009 12:42 PM
Application development, RPG, RPGLE
I have been asked to produce a file in an RPG program. The file is being used in some kind of interface and needs to be ‘tab delimited’ What is tab delimited? How do I create a tab-delimited file? Thanks
Answer Question
| December 23, 2009 12:42 PM
Application development, RPG, RPGLE
Monitoring VRYCFG
Hello, Well, I need some advice because I’m one more time a little bit lost in my learning of AS/400 programming. Here is what I’m trying to do: Everytime that the AS/400 receives a VARY OFF on 1 specific device, I would like to execute a program after the VARY OFF is complete. I was [...]
Answer Question
| October 5, 2006 9:16 AM
Application development, AS/400, CLP, DataCenter, RPG, RPG ILE, RPGLE
Hello, Well, I need some advice because I’m one more time a little bit lost in my learning of AS/400 programming. Here is what I’m trying to do: Everytime that the AS/400 receives a VARY OFF on 1 specific device, I would like to execute a program after the VARY OFF is complete. I was [...]
Answer Question
| October 5, 2006 9:16 AM
Application development, AS/400, CLP, DataCenter, RPG, RPG ILE, RPGLE
Send a program completion message to a user
A user call an update program – which will complete in a nanosecons as it reads 1 record and updates it. How Can I send a message to the user from the pgm giving completion data? Program could be CL or RPG3/4
Answer Question
| December 23, 2009 6:01 AM
Application development, RPG, RPGLE
A user call an update program – which will complete in a nanosecons as it reads 1 record and updates it. How Can I send a message to the user from the pgm giving completion data? Program could be CL or RPG3/4
Answer Question
| December 23, 2009 6:01 AM
Application development, RPG, RPGLE
