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
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...
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...
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.
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...
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.
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,...
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,...
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 war file using...
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 war file using...
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...
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...
WEB / iSeries
Where do you foresee browser-based iSeries access applications going, with regard to development portals, user interface methodologies, etc. ?
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)
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 (e.g...
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 (e.g...
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...
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...
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 IFS to a file. Does anyone know how to do this?
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 IFS to a file. Does anyone know how to do this?
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 ...
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 ...
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?
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...
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...
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 help on...
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 help on...
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
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.
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.


