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
The server with this database is no longer responding
I am trying to access a link in a Database on the LNS through the lotus client but it is throwing the error message ‘The server with this DB is no longer responding Should notes switch to a replica on other server’. The link is accessible from a other client.I have shutdown the firewall also. [...]
Answer Question
| September 29, 2006 9:51 AM
Application development, AS/400, AS/400 careers, Backup & recovery, CLP, DB2 Universal Database, Lotus Domino, Printing, RPG, RPGLE, Security
I am trying to access a link in a Database on the LNS through the lotus client but it is throwing the error message ‘The server with this DB is no longer responding Should notes switch to a replica on other server’. The link is accessible from a other client.I have shutdown the firewall also. [...]
Answer Question
| September 29, 2006 9:51 AM
Application development, AS/400, AS/400 careers, Backup & recovery, CLP, DB2 Universal Database, Lotus Domino, Printing, RPG, RPGLE, Security
ISO date Formats and Move
I need to do 2 things . Perform day additions and deductions on a date format yyyymmdd. Am I correct in thinking this is *ISO format? And is there any example code of arithmetic? 2. Also I have been advised on RPG4 not to use MOVE to change char to dec. Is this correct, and [...]
Answer Question
| October 2, 2006 8:53 AM
RPG, RPGLE
I need to do 2 things . Perform day additions and deductions on a date format yyyymmdd. Am I correct in thinking this is *ISO format? And is there any example code of arithmetic? 2. Also I have been advised on RPG4 not to use MOVE to change char to dec. Is this correct, and [...]
Answer Question
| October 2, 2006 8:53 AM
RPG, RPGLE
As400 files – a basic question from a newbie
I know this is going to sound silly – a file has a format/formats. What is a ‘member’?
Answer Question
| December 23, 2009 3:16 AM
AS/400, Backup & recovery, CLP, DataCenter, Printing, RPG, RPGLE, Web development
I know this is going to sound silly – a file has a format/formats. What is a ‘member’?
Answer Question
| December 23, 2009 3:16 AM
AS/400, Backup & recovery, CLP, DataCenter, Printing, RPG, RPGLE, Web development
Timestamp Data Type
Hi I am writing an RPG400 program which is populating a file, this file has one field in it defined as a TIMESTAMP field of 26 long. How do i populate this field with RPG400, everything i have tried so far has failed. Thanks in advance for any help
Answer Question
| December 12, 2010 10:23 PM
RPG
Hi I am writing an RPG400 program which is populating a file, this file has one field in it defined as a TIMESTAMP field of 26 long. How do i populate this field with RPG400, everything i have tried so far has failed. Thanks in advance for any help
Answer Question
| December 12, 2010 10:23 PM
RPG
