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
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
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
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
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
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
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
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
calling an external web service from RPG
Our web guys have created a web service that we need to access from an RPG program. we have the URL http://999.99.99.99/mywebservice.asmx data will be passed to and from via SOAP format. Martin.
Answer Question
| October 6, 2006 2:48 PM
AS/400, Programming Languages, RPGLE, Web development, Web services, Web Services Standards
Our web guys have created a web service that we need to access from an RPG program. we have the URL http://999.99.99.99/mywebservice.asmx data will be passed to and from via SOAP format. Martin.
Answer Question
| October 6, 2006 2:48 PM
AS/400, Programming Languages, RPGLE, Web development, Web services, Web Services Standards
Api usage
Hi! Any one that knows where (in which library) to find the CEERARN0 api? The crtpgm command can’t find the module. Best regards! //MikEhr
Answer Question
| September 26, 2006 7:20 AM
Application development, AS/400, RPGLE
Hi! Any one that knows where (in which library) to find the CEERARN0 api? The crtpgm command can’t find the module. Best regards! //MikEhr
Answer Question
| September 26, 2006 7:20 AM
Application development, AS/400, 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
