Two OPNQRYF on same file
I have a file which has account opened date and account changed date. In my RPG program, I need to extract all those accounts opened today. and do some calculations. Then I need to extract all those accounts that are changed today and status is not ‘Cancelled’ My file doesn’t have either opened date or [...]
Answer Question
| April 26, 2013 6:13 AM
AS/400, OPNQRYF, RPG Program
I have a file which has account opened date and account changed date. In my RPG program, I need to extract all those accounts opened today. and do some calculations. Then I need to extract all those accounts that are changed today and status is not ‘Cancelled’ My file doesn’t have either opened date or [...]
Answer Question
| April 26, 2013 6:13 AM
AS/400, OPNQRYF, RPG Program
Consuming Web Service from AS/400 Java
I have to consume a WebService that is located on another computer, my program is in the AS/400, I’m doing it in Java and I have problems with the packages and Classpath, if anyone has used these services and can help me and send to me a complete example or tells me where to find [...]
Answer Question
| April 26, 2013 8:00 PM
AS/400, Java, WebServices
I have to consume a WebService that is located on another computer, my program is in the AS/400, I’m doing it in Java and I have problems with the packages and Classpath, if anyone has used these services and can help me and send to me a complete example or tells me where to find [...]
Answer Question
| April 26, 2013 8:00 PM
AS/400, Java, WebServices
Search for a data in the file in all the library
I have a file which has an ID field and description. The same file is present in many library. I am trying to create an utility which will ask for the ID and it should display all the library which has the file with that ID in it. How can I achieve this? How to [...]
Answer Question
| April 25, 2013 7:06 AM
AS/400, AS/400 Library
I have a file which has an ID field and description. The same file is present in many library. I am trying to create an utility which will ask for the ID and it should display all the library which has the file with that ID in it. How can I achieve this? How to [...]
Answer Question
| April 25, 2013 7:06 AM
AS/400, AS/400 Library
Subfile choice auto advance
I am using SFLSNGCHC(*AUTOSLT) to use subfile records as like choice. but I cannot do the auto advanced record like CHECK(ER). Is there any way can we use auto forward option in subfile selection?
Answer Question
| April 24, 2013 11:27 AM
AS/400, AS/400 Subfiles
I am using SFLSNGCHC(*AUTOSLT) to use subfile records as like choice. but I cannot do the auto advanced record like CHECK(ER). Is there any way can we use auto forward option in subfile selection?
Answer Question
| April 24, 2013 11:27 AM
AS/400, AS/400 Subfiles
How to display message in display file from a MSGF
How to display a message (essentially error message) at the bottom in display file (DSPF) from a Message File (MSGF)? Also in order to display more than one message, how do I go about that? I have a MSGF, wherein all the messages are pre-defined, which we have to use. Would greatly appreciate your prompt [...]
Answer Question
| April 24, 2013 6:27 AM
AS/400 - DDS, DSPF, MSGF
How to display a message (essentially error message) at the bottom in display file (DSPF) from a Message File (MSGF)? Also in order to display more than one message, how do I go about that? I have a MSGF, wherein all the messages are pre-defined, which we have to use. Would greatly appreciate your prompt [...]
Answer Question
| April 24, 2013 6:27 AM
AS/400 - DDS, DSPF, MSGF
Tools for AS/400
I am looking for a tool that we can develop on AS/400. Please suggest the list of tools.
Answer Question
| April 23, 2013 7:27 PM
AS/400, AS/400 tools
I am looking for a tool that we can develop on AS/400. Please suggest the list of tools.
Answer Question
| April 23, 2013 7:27 PM
AS/400, AS/400 tools
Spool print in Times New Roman
How do you print the spool file in Times New Roman. Report is not PRTF. (Coded internal). I am modifing this program and been asked if we can do it. On the OVRPRTF, the Font Identifier is asking for a Character Value for the Times New Roman. Does anyone know what this Character Value is? [...]
Answer Question
| April 29, 2013 7:00 PM
IBM i, Spool file
How do you print the spool file in Times New Roman. Report is not PRTF. (Coded internal). I am modifing this program and been asked if we can do it. On the OVRPRTF, the Font Identifier is asking for a Character Value for the Times New Roman. Does anyone know what this Character Value is? [...]
Answer Question
| April 29, 2013 7:00 PM
IBM i, Spool file
Renewal of SSL certificate on AS/400
Hi, I have renewed the SSL certificate of my iSeries system. While renewing certificate, I haven’t got any option to specify the number of days to renew the certificate. It is getting renewed for 1 year by default. How to increase these number of days for SSL certificate while renewing it. Thanks & regards, Ketan [...]
Answer Question
| April 23, 2013 1:53 PM
AS/400, SSL certificate
Hi, I have renewed the SSL certificate of my iSeries system. While renewing certificate, I haven’t got any option to specify the number of days to renew the certificate. It is getting renewed for 1 year by default. How to increase these number of days for SSL certificate while renewing it. Thanks & regards, Ketan [...]
Answer Question
| April 23, 2013 1:53 PM
AS/400, SSL certificate
WRKQRY query
In WRKQRY, while selecting the collating sequence, what is option 2-Query for iSeries English? I am trying to learn the options in WRKQRY and came across this. F1 help details are not digesting. Please help.
Answer Question
| April 23, 2013 10:44 AM
AS/400, iSeries, WRKQRY
In WRKQRY, while selecting the collating sequence, what is option 2-Query for iSeries English? I am trying to learn the options in WRKQRY and came across this. F1 help details are not digesting. Please help.
Answer Question
| April 23, 2013 10:44 AM
AS/400, iSeries, WRKQRY
How to connect my AS/400 to my PC
Hi Can you please tell me how I can connect my AS/400 to my PC? My HMC is broken. Here is the scenario. Please explain to me in very simple words because I do not want to read IBM’s 300 pages book. 1. I have an AS/400 Model 520. I have internet so I have [...]
Answer Question
| April 23, 2013 10:08 PM
AS/400, Client Access 5.9
Hi Can you please tell me how I can connect my AS/400 to my PC? My HMC is broken. Here is the scenario. Please explain to me in very simple words because I do not want to read IBM’s 300 pages book. 1. I have an AS/400 Model 520. I have internet so I have [...]
Answer Question
| April 23, 2013 10:08 PM
AS/400, Client Access 5.9
SFLLIN
Using SFLLIN to create a two column display. Would like to tab down first column and then next column. col1-row1, col1-row2, col1-row3 etc. then col2-row1, col2-row2 ..instead of default col1-row1, col2,row1,col1-row2, col2-row2 Any idea how to control the tab key?
Answer Question
| April 22, 2013 8:54 PM
AS/400, DSPF, SFLLIN
Using SFLLIN to create a two column display. Would like to tab down first column and then next column. col1-row1, col1-row2, col1-row3 etc. then col2-row1, col2-row2 ..instead of default col1-row1, col2,row1,col1-row2, col2-row2 Any idea how to control the tab key?
Answer Question
| April 22, 2013 8:54 PM
AS/400, DSPF, SFLLIN
iSeries native job scheduler -QJOBSCD
I had heard that the job QJOBSCD is related to native job scheduler and it is responsible for the job submission to JOBQ but when I had given command WRKACTJOB JOB(QJOBSCD), I could not find the job. It’s still active and the job scheduler is working fine.
Answer Question
| April 22, 2013 1:41 PM
AS/400, AS/400 jobs, iSeries
I had heard that the job QJOBSCD is related to native job scheduler and it is responsible for the job submission to JOBQ but when I had given command WRKACTJOB JOB(QJOBSCD), I could not find the job. It’s still active and the job scheduler is working fine.
Answer Question
| April 22, 2013 1:41 PM
AS/400, AS/400 jobs, iSeries
Display file level check identifier change
Hi all! I have a display file in LIB001 and its having many screen files and Window file, I just wanted to add one more screen file in this case. 1. Do I need to compile the Display file? 2. If compile the display file, its linked with many RPG, CL programs, so obviously I [...]
Answer Question
| April 22, 2013 8:40 AM
AS/400, AS/400 Display File
Hi all! I have a display file in LIB001 and its having many screen files and Window file, I just wanted to add one more screen file in this case. 1. Do I need to compile the Display file? 2. If compile the display file, its linked with many RPG, CL programs, so obviously I [...]
Answer Question
| April 22, 2013 8:40 AM
AS/400, AS/400 Display File
SFTP
I need to transfer a file using SFTP. It’s a PF with a 180 character field. When I try the put command from an iSeries library, the file goes over as binary. If I copy it to the IFS and transfer from there, it goes over as text. But, I cannot have this unencrypted file [...]
Answer Question
| April 22, 2013 12:36 AM
ASCII, iSeries, SFTP
I need to transfer a file using SFTP. It’s a PF with a 180 character field. When I try the put command from an iSeries library, the file goes over as binary. If I copy it to the IFS and transfer from there, it goes over as text. But, I cannot have this unencrypted file [...]
Answer Question
| April 22, 2013 12:36 AM
ASCII, iSeries, SFTP
How to use SETLL and READE to solve this program
I have to write those records in PF whose criteria is as follows: * [b] C – [/b] = ‘y’ * [b] record must be latest for particular id [/b]here is the data – pf name – FILEA (to be read) and FILEB ( to be write) [b] A B C [/B] 10 1 N [...]
Answer Question
| April 19, 2013 7:09 AM
AS/400, Physical File
I have to write those records in PF whose criteria is as follows: * [b] C – [/b] = ‘y’ * [b] record must be latest for particular id [/b]here is the data – pf name – FILEA (to be read) and FILEB ( to be write) [b] A B C [/B] 10 1 N [...]
Answer Question
| April 19, 2013 7:09 AM
AS/400, Physical File
Show error message to user after a CPYF command ended in error in CL program
I have a copy command in my CL program. I have specified tofile and tomember parameters. I have given CRTFILE(*NO) so that I don’t want to create a source file if it is not existing. I want to show a message “Sourcefile is invalid” when the source file is not an existing one. I want [...]
Answer Question
| April 19, 2013 5:27 AM
AS/400, CL Program
I have a copy command in my CL program. I have specified tofile and tomember parameters. I have given CRTFILE(*NO) so that I don’t want to create a source file if it is not existing. I want to show a message “Sourcefile is invalid” when the source file is not an existing one. I want [...]
Answer Question
| April 19, 2013 5:27 AM
AS/400, CL Program
Changing user profiles in a CL program
Since I’m not much of a programmer I was wondering if someone could offer some suggestions on three programs I need to write. My first program will need to delete the JOBD associated with the user profile in QGPL and replace it with a different JOBD. The profiles that will have to be changed will [...]
Answer Question
| April 18, 2013 7:04 PM
CL Program, JOBD, QGPL
Since I’m not much of a programmer I was wondering if someone could offer some suggestions on three programs I need to write. My first program will need to delete the JOBD associated with the user profile in QGPL and replace it with a different JOBD. The profiles that will have to be changed will [...]
Answer Question
| April 18, 2013 7:04 PM
CL Program, JOBD, QGPL
SQL creating an unwanted duplicate of file
The other day a colleague ran an SQL statement to update a field in a file to a constant where 2 other fields were equal to constants (so no joining was needed, etc.) When finished, there was a duplicate copy of the file in the first library in the library list. (Which is higher than [...]
Answer Question
| April 18, 2013 1:50 PM
DB2, SQL statement
The other day a colleague ran an SQL statement to update a field in a file to a constant where 2 other fields were equal to constants (so no joining was needed, etc.) When finished, there was a duplicate copy of the file in the first library in the library list. (Which is higher than [...]
Answer Question
| April 18, 2013 1:50 PM
DB2, SQL statement
Transfer AS/400 to Excel
Hi there again, Odd question…I am trying to transfer targets and there are more than a few. My Question: Is it possible to transfer more than on file simultaneously from iSeries to multiple Excel spreadsheets, or does this need to happen one at a time. Trying to cut down the continuous transfer. Thanks guys.
Answer Question
| April 18, 2013 11:44 AM
AS/400, Microsoft Excel 2010
Hi there again, Odd question…I am trying to transfer targets and there are more than a few. My Question: Is it possible to transfer more than on file simultaneously from iSeries to multiple Excel spreadsheets, or does this need to happen one at a time. Trying to cut down the continuous transfer. Thanks guys.
Answer Question
| April 18, 2013 11:44 AM
AS/400, Microsoft Excel 2010
Date conversion
I have a character field wISODate of length 8A. It holds value in the form of yyyymmdd. I want to convert this to an ISO date field. Decclaration D wDAte S D D wISODate S 8A Assume wISODate has value ’20121001′ *YMD0 Move wISODate wDAte Any other better method is there instead of using Move?
Answer Question
| April 18, 2013 6:00 AM
AS/400, AS/400 Fields
I have a character field wISODate of length 8A. It holds value in the form of yyyymmdd. I want to convert this to an ISO date field. Decclaration D wDAte S D D wISODate S 8A Assume wISODate has value ’20121001′ *YMD0 Move wISODate wDAte Any other better method is there instead of using Move?
Answer Question
| April 18, 2013 6:00 AM
AS/400, AS/400 Fields
