iseries – Display file – Unicode
How to make iseries display file display multilanguage characters.
Answer Question
| July 15, 2009 7:36 AM
Character encoding, iSeries development, Multilingual support, Unicode
How to make iseries display file display multilanguage characters.
How to connect to an AS/400 database from a remote PHP script
Hello. I have a requirement to use a PHP script running under Windows to access a remote DB2/400 on an iSeries. Can anyone please assist in what PHP coding would be needed, thank you! Regards Paul
Answer Question
| May 26, 2009 10:13 PM
AS/400 connectivity, AS/400 development, DB2/400, iSeries connectivity, iSeries development, PHP, Remote access
Hello. I have a requirement to use a PHP script running under Windows to access a remote DB2/400 on an iSeries. Can anyone please assist in what PHP coding would be needed, thank you! Regards Paul
Transform DB2 to XML from AS/400
I have been requested to create XML files from AS/400 DB2 files to be used to update data on a client’s web server. I have looked at IBM’s XML Toolkit for iSeries, but the examples are all about parsing XML input and nothing about creating XML from native AS/400 database files. Is there something in [...]
Answer Question
| November 4, 2010 3:36 PM
AS/400 development, DB2, DB2/400, iSeries development, XML, XML Toolkit for iSeries
I have been requested to create XML files from AS/400 DB2 files to be used to update data on a client’s web server. I have looked at IBM’s XML Toolkit for iSeries, but the examples are all about parsing XML input and nothing about creating XML from native AS/400 database files. Is there something in [...]
Java on iSeries
Can anyone suggest me the link to learn Java on i-series? I am an experienced AS/400 programmer with knowledge on Java.
Answer Question
| April 29, 2009 7:15 AM
iSeries, iSeries development, iSeries Java programming, Java
Can anyone suggest me the link to learn Java on i-series? I am an experienced AS/400 programmer with knowledge on Java.
RPG vs Java vs Others
Hi, With the possibilities of using all sorts of C and Java type functions now available in RPG and bearing in mind that (in my experience) Java is difficult to tune to perform reasonably on the i-Series is there any benefit for an RPG programmer to learn Java? Or would some other language be a [...]
Answer Question
| November 4, 2009 11:22 AM
iSeries, iSeries development, iSeries Java programming, Java, RPG
Hi, With the possibilities of using all sorts of C and Java type functions now available in RPG and bearing in mind that (in my experience) Java is difficult to tune to perform reasonably on the i-Series is there any benefit for an RPG programmer to learn Java? Or would some other language be a [...]
Synon/2E – No member source genned
I created a file in the model and it did not generate a source member.
Answer Question
| April 21, 2009 11:41 AM
AS/400 development, iSeries development, Synon, Synon/2E
I created a file in the model and it did not generate a source member.
Program utility required
I have had a request from a developer for the following: Utility program required so that a PF file and library can be specifed with starting date / time and ending date / time. This utility will then extract all the current journal records for that file, including the journal fields e.g. user, program, date, [...]
Answer Question
| April 17, 2009 10:54 AM
AS/400, Display Journal, DSPJRN, iSeries, iSeries development
I have had a request from a developer for the following: Utility program required so that a PF file and library can be specifed with starting date / time and ending date / time. This utility will then extract all the current journal records for that file, including the journal fields e.g. user, program, date, [...]
Java on iSeries
We have a java program running on web sphere on linux. The java program is zipped as jar and deployed in an IFS directory and we use RPGILE to call the java program. Would it be possible to deploy war file instead of jar file in IFS directory and call the java program in the [...]
Answer Question
| February 5, 2009 4:12 AM
IFS Directory, iSeries, iSeries development, JAR file, Java, Java ARchive, RPGILE, WAR file, Web ARchive, WebSphere
We have a java program running on web sphere on linux. The java program is zipped as jar and deployed in an IFS directory and we use RPGILE to call the java program. Would it be possible to deploy war file instead of jar file in IFS directory and call the java program in the [...]
Can embedded SQL in a SQLRPGLE program be used as a stored procedure?
I am successfully using (external) stored procedures with many RPGLE programs. (Some of these are SQLRPGLE programs because they return a result set.) All of this works fine. But if I try to replace some of the RPG I/O in a RPGLE program with embedded SQL, creating a SQLRPGLE program, and run it as a [...]
Answer Question
| January 15, 2009 10:09 PM
Embedded SQL, iSeries development, iSeries RPG programming, RPG, RPGLE, SQL, SQLRPGLE, Stored Procedures
I am successfully using (external) stored procedures with many RPGLE programs. (Some of these are SQLRPGLE programs because they return a result set.) All of this works fine. But if I try to replace some of the RPG I/O in a RPGLE program with embedded SQL, creating a SQLRPGLE program, and run it as a [...]
WEB / iSeries
Where do you foresee browser-based iSeries access applications going, with regard to development portals, user interface methodologies, etc. ?
Answer Question
| January 13, 2009 3:00 PM
iSeries applications, iSeries development, iSeries/WEB future, User interface design
Where do you foresee browser-based iSeries access applications going, with regard to development portals, user interface methodologies, etc. ?
Using the SQL IN clause in SQLRPGLE
Can I use a variable with the IN clause in an iSeries SQLRPGLE program? Can I use: WHERE CUSTID IN(:CUSTNUMS) Instead of: WHERE CUSTID IN(145,1600,352)
Answer Question
| December 19, 2008 10:09 PM
IN statement, iSeries, iSeries development, SQL statements, SQLRPGLE, WHERE statement
Can I use a variable with the IN clause in an iSeries SQLRPGLE program? Can I use: WHERE CUSTID IN(:CUSTNUMS) Instead of: WHERE CUSTID IN(145,1600,352)
iSeries: Accessing src PF member using Java/400
I am a veteran iSeries programmer but new to Java. We have a requirement of reading src PF member as record (each line) and to be transmitted. Also, incoming streams to be created as a src PF member by adding the recs in it. Which Java/400 class can be used to read from a member [...]
Answer Question
| November 17, 2008 6:28 AM
BufferedReader, IFSFile, iSeries, iSeries development, iSeries Java programming, Java, Java classes, Java/400, Physical File, QSYSObjectPathName, SequentialFile
I am a veteran iSeries programmer but new to Java. We have a requirement of reading src PF member as record (each line) and to be transmitted. Also, incoming streams to be created as a src PF member by adding the recs in it. Which Java/400 class can be used to read from a member [...]
How to pause execution of a macro to allow user input of variable data in iSeries
I am exploring the possibilities to speed up input when testing by taking advantage of macros. The problem is when variable data has to be keyed into a field in the middle of the sequence. Reading the help-topics on WAIT I thought I could use the WaitForCursor-option, but it does not change the system mode [...]
Answer Question
| March 24, 2011 12:27 PM
iSeries, iSeries development, iSeries macros
I am exploring the possibilities to speed up input when testing by taking advantage of macros. The problem is when variable data has to be keyed into a field in the middle of the sequence. Reading the help-topics on WAIT I thought I could use the WaitForCursor-option, but it does not change the system mode [...]
Listing the IFS to a file
We need to list the contents of the IFS and then list the contents of each directory. We need to output this to a file so that we can put it on a PC. We can see how to read a directory when we know the path. However we can’t see how to list the [...]
Answer Question
| August 6, 2008 2:39 PM
IFS, iSeries, iSeries development, iSeries programming commands
We need to list the contents of the IFS and then list the contents of each directory. We need to output this to a file so that we can put it on a PC. We can see how to read a directory when we know the path. However we can’t see how to list the [...]
simple code
Hi friends, Can you give the solution for the below mention simple code.and explain.what is output D CHR1 S 4A INZ(‘PEN’) D CHR2 S 10A INZ(‘MYGET’) D CHR3 S 8A INZ(‘GOOD’) D CHR4 S 22A INZ C MOVEL CHR1 CHR4 C MOVE CHR2 CHR4 C EVAL CHR4=CHR3 C MOVE CHR1 CHR4
Answer Question
| May 10, 2010 5:20 AM
iSeries development
Hi friends, Can you give the solution for the below mention simple code.and explain.what is output D CHR1 S 4A INZ(‘PEN’) D CHR2 S 10A INZ(‘MYGET’) D CHR3 S 8A INZ(‘GOOD’) D CHR4 S 22A INZ C MOVEL CHR1 CHR4 C MOVE CHR2 CHR4 C EVAL CHR4=CHR3 C MOVE CHR1 CHR4
Find # days between 2 dates in Query 400
I have never used this function but it looks like the startdate and enddate must be alpha expressions for this to work. Is that correct?
Answer Question
| April 23, 2010 3:50 PM
AS/400 Query, iSeries development
I have never used this function but it looks like the startdate and enddate must be alpha expressions for this to work. Is that correct?
single page subfile
Hello friend, Currently i m learning as/400.i am confidence when i make load all subfile and expandable subfile…but when i go for single page subfile…i always stucked….i dont understand..page up and page down subroutine…..if anybody hv full progrm for single page subfile plzz mail me…. my email id is swapnil.amit83@yahoo.com
Answer Question
| April 29, 2008 12:39 PM
iSeries development, Subfile
Hello friend, Currently i m learning as/400.i am confidence when i make load all subfile and expandable subfile…but when i go for single page subfile…i always stucked….i dont understand..page up and page down subroutine…..if anybody hv full progrm for single page subfile plzz mail me…. my email id is swapnil.amit83@yahoo.com
finding source files
I have been given the job of findind all source physical files on out AS400 In the pass there wre no standards for naming them. Have to locate all of these source physical file on our AS400 and them creat a spreensheet of all menbers trying to locate and drop the duplicate source code. Any [...]
Answer Question
| April 19, 2010 7:42 PM
AS/400, iSeries development, WRKOBJPDM
I have been given the job of findind all source physical files on out AS400 In the pass there wre no standards for naming them. Have to locate all of these source physical file on our AS400 and them creat a spreensheet of all menbers trying to locate and drop the duplicate source code. Any [...]
AS/400 what keyword is used on the RPG IV definition specification to rename a subfield in an externaly defined data structure
what keyword is used on the RPG IV definition specification to rename a subfield in an externaly defined data structure
Answer Question
| April 9, 2008 8:02 AM
AS/400, iSeries development, RPG
what keyword is used on the RPG IV definition specification to rename a subfield in an externaly defined data structure
how can we use ponter in function keys?
usually we are using if *in03=*off like that instead of this i want to give directly IF EXIT like that I think some pointers are used to this i am not sure about that please replay me this question.
Answer Question
| April 16, 2008 12:31 PM
iSeries development, RPGLE
usually we are using if *in03=*off like that instead of this i want to give directly IF EXIT like that I think some pointers are used to this i am not sure about that please replay me this question.





