Available Certifications for AS/400 Developers
Hi All, I have been working on AS400 as a Developer on RPG IV, CL and DB2/400 for around 4 years and i wanted to do any certification regards to AS400. Actually I’m planned to write RPG IV Certification Exam(Certification No :268), but recently i came to know from my friend that this certification is [...]
Answer Question
| April 4, 2012 12:47 PM
AS/400, AS/400 certification, AS/400 development, RPG IV
Hi All, I have been working on AS400 as a Developer on RPG IV, CL and DB2/400 for around 4 years and i wanted to do any certification regards to AS400. Actually I’m planned to write RPG IV Certification Exam(Certification No :268), but recently i came to know from my friend that this certification is [...]
Answer Question
| April 4, 2012 12:47 PM
AS/400, AS/400 certification, AS/400 development, RPG IV
STRSBS for single environment in AS/400
Dear Friends, I want to know about STRSBS for single Environment, in my System 3 different environment like A) Development (DVP) B) Testing (TST) C) Production 1 (510) D) Production 2 (710) Now I want STRSBS for 510 Environment only and rest of all Environments will be work but not 510 it should be hold, [...]
Answer Question
| August 25, 2010 3:28 AM
AS/400, AS/400 development, STRSBS
Dear Friends, I want to know about STRSBS for single Environment, in my System 3 different environment like A) Development (DVP) B) Testing (TST) C) Production 1 (510) D) Production 2 (710) Now I want STRSBS for 510 Environment only and rest of all Environments will be work but not 510 it should be hold, [...]
Answer Question
| August 25, 2010 3:28 AM
AS/400, AS/400 development, STRSBS
Sending an email with a link to a .csv file that’s too large to email
My program creates a .csv that is copied to the IFS. It is too large to attach to email. I want to send an email with a link to the file. How do I do that?
Answer Question
| August 19, 2010 5:18 PM
AS/400 development, CSV file format, IFS, iSeries, V5R4
My program creates a .csv that is copied to the IFS. It is too large to attach to email. I want to send an email with a link to the file. How do I do that?
Answer Question
| August 19, 2010 5:18 PM
AS/400 development, CSV file format, IFS, iSeries, V5R4
How to make password characters invisible in AS400?
I am designing a login screen in AS400 box. How do I make the characters invisible while entering the password? Need Help!!
Answer Question
| July 2, 2010 11:09 AM
AS/400, AS/400 development, DSPF, RPG, RPG ILE
I am designing a login screen in AS400 box. How do I make the characters invisible while entering the password? Need Help!!
Answer Question
| July 2, 2010 11:09 AM
AS/400, AS/400 development, DSPF, RPG, RPG ILE
RPGLE /free syntax question
I am modifing some code I found, and trying to add multiple ‘or’ statement. I have tried several different way to get the code to compile, but I always get errors. Can someone please tell me the proper syntax for the following statement below?? if Jobbstatus = ‘MSGW’ and SubShort = ‘QBATCH’ or + [...]
Answer Question
| May 19, 2010 1:41 PM
AS/400 administration, AS/400 backup, AS/400 development, RPGLE
I am modifing some code I found, and trying to add multiple ‘or’ statement. I have tried several different way to get the code to compile, but I always get errors. Can someone please tell me the proper syntax for the following statement below?? if Jobbstatus = ‘MSGW’ and SubShort = ‘QBATCH’ or + [...]
Answer Question
| May 19, 2010 1:41 PM
AS/400 administration, AS/400 backup, AS/400 development, RPGLE
finding parameters in as/400 program objects
how do you find the parameters passed to a program if we dont have source and we have only object and cannot debug it
Answer Question
| May 2, 2010 5:59 PM
AS/400 development
how do you find the parameters passed to a program if we dont have source and we have only object and cannot debug it
Answer Question
| May 2, 2010 5:59 PM
AS/400 development
iSeries – DBCS
Hi We have an application with front-end (Java in RS/6000) and the back-end (COBOL in iSeries). Currently, the front-end browser panels send the data through MQ to iSeries. But before sending data to iSeries, the Java will do conversion from ASCII to EBCDIC programmatically for character encoding from Unicode to EBCDIC. For example, If the [...]
Answer Question
| November 16, 2011 5:22 AM
AS/400 development, DBCS
Hi We have an application with front-end (Java in RS/6000) and the back-end (COBOL in iSeries). Currently, the front-end browser panels send the data through MQ to iSeries. But before sending data to iSeries, the Java will do conversion from ASCII to EBCDIC programmatically for character encoding from Unicode to EBCDIC. For example, If the [...]
Answer Question
| November 16, 2011 5:22 AM
AS/400 development, DBCS
creating menus
Hi anybody tell me how can we add the parameters to a new menu thru SDA. eg: for DSPUSRPRF i need to provide the user profile name. Instead i want to give &user1 and want to supply it by prompting. thanks
Answer Question
| December 16, 2009 2:06 PM
AS/400 development, AS/400 user profiles, DSPUSRPRF
Hi anybody tell me how can we add the parameters to a new menu thru SDA. eg: for DSPUSRPRF i need to provide the user profile name. Instead i want to give &user1 and want to supply it by prompting. thanks
Answer Question
| December 16, 2009 2:06 PM
AS/400 development, AS/400 user profiles, DSPUSRPRF
AS/400 call stack
Hi how can i know the list of called programs in the existing active call stack? Plz help
Answer Question
| December 17, 2009 8:19 AM
AS/400 Call stack, AS/400 development, V6R1
Hi how can i know the list of called programs in the existing active call stack? Plz help
Answer Question
| December 17, 2009 8:19 AM
AS/400 Call stack, AS/400 development, V6R1
How to see the source for the AS/400 objects?
I am having a server at my office which has a project application running on it.I need to access the Cl/RPG/CMD/PNLGRP and file objects on it to modify them and restore.I tried for the DSPOBJD and *SERVICE to find the source library and file but couldn’t retrieve from that combination. I think the library may [...]
Answer Question
| December 15, 2009 11:59 AM
AS/400 development, AS/400 objects, RPG
I am having a server at my office which has a project application running on it.I need to access the Cl/RPG/CMD/PNLGRP and file objects on it to modify them and restore.I tried for the DSPOBJD and *SERVICE to find the source library and file but couldn’t retrieve from that combination. I think the library may [...]
Answer Question
| December 15, 2009 11:59 AM
AS/400 development, AS/400 objects, RPG
Retrieving Source (DDS) from object file
I lost my physical source file (DDS),but its object is there.I can view the contents of it.Can I retrieve the source file(DDS) from its object?? Please help…………..
Answer Question
| December 17, 2009 8:29 AM
AS/400 development, DDS
I lost my physical source file (DDS),but its object is there.I can view the contents of it.Can I retrieve the source file(DDS) from its object?? Please help…………..
Answer Question
| December 17, 2009 8:29 AM
AS/400 development, DDS
Member Level ID
Every evening we create Save Files of our Production Libraries on our Production System. The next morning we FTP these Save Files to our Development System and do Restores to our Production Libraries on our Development System. We use TurnOver to handle the changes to our SQL Tables, Indexes, and Views. The issue is that [...]
Answer Question
| October 26, 2009 3:43 PM
AS/400 database, AS/400 development, iSeries database
Every evening we create Save Files of our Production Libraries on our Production System. The next morning we FTP these Save Files to our Development System and do Restores to our Production Libraries on our Development System. We use TurnOver to handle the changes to our SQL Tables, Indexes, and Views. The issue is that [...]
Answer Question
| October 26, 2009 3:43 PM
AS/400 database, AS/400 development, iSeries database
AS/400: Close open files
Dear sirs, could you please help me with the following problem: I want to close all open files that are left open from previous different steps (pgms rpg , rpgle , clp) that were run. I have tried to use a CLP pgm using RCLRSC, RCLRSC *CALLER with no success. Could you please advise me [...]
Answer Question
| October 22, 2009 9:24 PM
AS/400 development, CLP, RCLRSC
Dear sirs, could you please help me with the following problem: I want to close all open files that are left open from previous different steps (pgms rpg , rpgle , clp) that were run. I have tried to use a CLP pgm using RCLRSC, RCLRSC *CALLER with no success. Could you please advise me [...]
Answer Question
| October 22, 2009 9:24 PM
AS/400 development, CLP, RCLRSC
Stored Procedure
hi, I’m calling a Stored procedure from RPGLEV program. I’m getting error pointer not set for location referenced. the SP has 3 parameters, numeric, numeric, Character my call stmt is CallP SP_Prototype(num1:num2:Char1) the program crahses….any thoughts???? thanks, NG
Answer Question
| September 9, 2009 8:32 PM
AS/400, AS/400 development, RPG
hi, I’m calling a Stored procedure from RPGLEV program. I’m getting error pointer not set for location referenced. the SP has 3 parameters, numeric, numeric, Character my call stmt is CallP SP_Prototype(num1:num2:Char1) the program crahses….any thoughts???? thanks, NG
Answer Question
| September 9, 2009 8:32 PM
AS/400, AS/400 development, RPG
AS/400 Tool
i want 2 create as/400 tool in my prj which will save time Could anybody gimme some idea reagrding as/400 tools.
Answer Question
| September 4, 2009 12:43 PM
AS/400 3rd party tools, AS/400 development, Software development
i want 2 create as/400 tool in my prj which will save time Could anybody gimme some idea reagrding as/400 tools.
Answer Question
| September 4, 2009 12:43 PM
AS/400 3rd party tools, AS/400 development, Software development
DDS function keys with point and click functionality
I feel kind of stupid about this, but when did the DDS function keys become point and click action? I have always used “CMD” and not “F#=” and totally missed this functionality. I’m almost afraid of the answer.
Answer Question
| August 27, 2009 3:56 PM
AS/400 command keys, AS/400 development, DDS
I feel kind of stupid about this, but when did the DDS function keys become point and click action? I have always used “CMD” and not “F#=” and totally missed this functionality. I’m almost afraid of the answer.
Answer Question
| August 27, 2009 3:56 PM
AS/400 command keys, AS/400 development, DDS
DB2 connection in VBscript
I need to delete some records from a DB2 database on an AS400 using VBscript.
Answer Question
| August 19, 2009 2:25 AM
AS/400 development, DB2/400, VBScript
I need to delete some records from a DB2 database on an AS400 using VBscript.
Answer Question
| August 19, 2009 2:25 AM
AS/400 development, DB2/400, VBScript
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
Answer Question
| May 26, 2009 10:13 PM
AS/400 connectivity, AS/400 development, DB2/400, iSeries connectivity, iSeries development, PHP, Remote access
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 [...]
Answer Question
| November 4, 2010 3:36 PM
AS/400 development, DB2, DB2/400, iSeries development, XML, XML Toolkit for iSeries
Program calls on AS/400
How i can check that my previous call to a program from other program was successful. Only after successful call and run only i can call another program. How to do check this in RPG and CL?
Answer Question
| April 28, 2009 7:53 AM
AS/400 development, CL, RPG, RPG/400
How i can check that my previous call to a program from other program was successful. Only after successful call and run only i can call another program. How to do check this in RPG and CL?
Answer Question
| April 28, 2009 7:53 AM
AS/400 development, CL, RPG, RPG/400
