OS/400 version vs ILE RPG objects
IBM provides a utility which will analyze your programs readiness to go to 6.1. If you have the source you should good to go. When we ran the analysis it reported programs which the system will not be able to convert to 6.1. In our case, these were purchased programs for which we have no [...]
View Answer
| July 27, 2010 11:35 PM
iSeries V6R1, OS/400 Objects, RPG ILE, V5R4, V5R4 to V6R1
IBM provides a utility which will analyze your programs readiness to go to 6.1. If you have the source you should good to go. When we ran the analysis it reported programs which the system will not be able to convert to 6.1. In our case, these were purchased programs for which we have no [...]
View Answer
| July 27, 2010 11:35 PM
iSeries V6R1, OS/400 Objects, RPG ILE, V5R4, V5R4 to V6R1
Upgrading from V5R3 to higher
Hello, You will need to run the ANZOBJCVN command to get your answers. Note the the actually converstion happens last. The steps are: Run the ANZOBJCVN command. Collect information about objects on your system. Review and understand the collected information. Contact your application provider, if necessary. Remove unsupported products. Upgrade your system. Convert objects.
View Answer
| July 27, 2010 8:01 PM
iSeries, Upgrade from V5R3 to V5R4, V5R3, V5R4
Hello, You will need to run the ANZOBJCVN command to get your answers. Note the the actually converstion happens last. The steps are: Run the ANZOBJCVN command. Collect information about objects on your system. Review and understand the collected information. Contact your application provider, if necessary. Remove unsupported products. Upgrade your system. Convert objects.
View Answer
| July 27, 2010 8:01 PM
iSeries, Upgrade from V5R3 to V5R4, V5R3, V5R4
How To get The Cursor position on particular field?
The display attribute DSPATR(PC) position cursor might be what you’re after It would be placed as a keyword for the input field, on the same line as the input field If you want to be able to turn it on/off put it on a line after the field with an indicator 45 DSPATR(PC) when 45 [...]
View Answer
| July 27, 2010 11:35 AM
AS/400, Cursor operation, DSPF, RPG, RPGLE
The display attribute DSPATR(PC) position cursor might be what you’re after It would be placed as a keyword for the input field, on the same line as the input field If you want to be able to turn it on/off put it on a line after the field with an indicator 45 DSPATR(PC) when 45 [...]
View Answer
| July 27, 2010 11:35 AM
AS/400, Cursor operation, DSPF, RPG, RPGLE
Position Cursor Issue in subfile
You can use SFLRCDNBR with *TOP option to bring your error record to TOP of page display. A REC# 4S 0H SFLRCDNBR(CURSOR *TOP)
View Answer
| July 27, 2010 10:39 AM
AS/400 Subfiles, RPG ILE, RPG IV, Subfile Display
You can use SFLRCDNBR with *TOP option to bring your error record to TOP of page display. A REC# 4S 0H SFLRCDNBR(CURSOR *TOP)
View Answer
| July 27, 2010 10:39 AM
AS/400 Subfiles, RPG ILE, RPG IV, Subfile Display
Monitor When QINTER is inactive
create a command that can run from another subsystem that tries to start the Qinter subsystem and monitor for the message when it errors out. for example: (not real code, but you get the idea) Alpha: Pgm StrSbs Qinter MonMsg MsgId(CPF1010) /* Error message if system is already active */ Omega: EndPgm In this method, [...]
View Answer
| July 26, 2010 9:49 PM
AS400 QINTER, iSeries Navigator, QINTER, V5R4
create a command that can run from another subsystem that tries to start the Qinter subsystem and monitor for the message when it errors out. for example: (not real code, but you get the idea) Alpha: Pgm StrSbs Qinter MonMsg MsgId(CPF1010) /* Error message if system is already active */ Omega: EndPgm In this method, [...]
View Answer
| July 26, 2010 9:49 PM
AS400 QINTER, iSeries Navigator, QINTER, V5R4
cobol/400 code samples
Thanks to Jojesse for finding this site, where you can find some <a href=”http://www.cobug.com/cobug/docs/codesamples0020.html”>COBOL Program Examples</a>.
View Answer
| July 26, 2010 2:05 PM
COBOL, COBOL/400, iSeries, OS/400, V5R4
Thanks to Jojesse for finding this site, where you can find some <a href=”http://www.cobug.com/cobug/docs/codesamples0020.html”>COBOL Program Examples</a>.
View Answer
| July 26, 2010 2:05 PM
COBOL, COBOL/400, iSeries, OS/400, V5R4
V6R1 to V5R4
Documentation from IBM on this topic is in the <a href=”http://www.redbooks.ibm.com/abstracts/redp4293.html”>IBM i Program Conversion: Getting Ready for 6.1 and Beyond</a> Redpaper. PTFs for V5R3 and V5R4 to handle reverse conversion are listed in tables in Chapter 3 under the Required PTFs subtopic. Tom
View Answer
| July 26, 2010 8:37 AM
iSeries, iSeries V6R1, V5R4, V6 To V5R4
Documentation from IBM on this topic is in the <a href=”http://www.redbooks.ibm.com/abstracts/redp4293.html”>IBM i Program Conversion: Getting Ready for 6.1 and Beyond</a> Redpaper. PTFs for V5R3 and V5R4 to handle reverse conversion are listed in tables in Chapter 3 under the Required PTFs subtopic. Tom
View Answer
| July 26, 2010 8:37 AM
iSeries, iSeries V6R1, V5R4, V6 To V5R4
Need Help to Write a Code in CL400 to Access All Members of Library in CL400 , and If to find one particular pgm how can i do it ???
First CL Use DSPFD command F4 to prompt Enter library File name or *ALL Type MBRLST Output Outfile Name Outfile/library Call second CL Second cl using DcLF to the outfile RCV records from outfile … whatever loop before compiling the second cL you will have to create the outfile
View Answer
| July 25, 2010 2:20 PM
AS/400, AS/400 Library, CL/400
First CL Use DSPFD command F4 to prompt Enter library File name or *ALL Type MBRLST Output Outfile Name Outfile/library Call second CL Second cl using DcLF to the outfile RCV records from outfile … whatever loop before compiling the second cL you will have to create the outfile
View Answer
| July 25, 2010 2:20 PM
AS/400, AS/400 Library, CL/400
Any As/400 Rpgle Program To automatically convert prtf file to pdf?
Converting a spooled file into PDF is not an RPG function. If you want to do it natively on your system, you need 5722IP1 IBM Infoprint Server. The principe is to define a writer that will convert you spool into a PDF file and store it in the IFS. See Chapter 4. Using the Infoprint [...]
View Answer
| July 23, 2010 6:26 PM
AS/400, AS/400 PDF, AS/400 PRTF, AS/400 Spool Files, RPGLE
Converting a spooled file into PDF is not an RPG function. If you want to do it natively on your system, you need 5722IP1 IBM Infoprint Server. The principe is to define a writer that will convert you spool into a PDF file and store it in the IFS. See Chapter 4. Using the Infoprint [...]
View Answer
| July 23, 2010 6:26 PM
AS/400, AS/400 PDF, AS/400 PRTF, AS/400 Spool Files, RPGLE
SNDDST to include User Name with the Error
In your CL, how do you detect that a job is in a “message wait” state ? Is your problem to retrieve to “job user” name do you already know this and do you want to send him an e-mail ?
View Answer
| July 23, 2010 9:39 AM
AS/400 DB2, AS/400 Primary Language CL RPG, SNDDST
In your CL, how do you detect that a job is in a “message wait” state ? Is your problem to retrieve to “job user” name do you already know this and do you want to send him an e-mail ?
View Answer
| July 23, 2010 9:39 AM
AS/400 DB2, AS/400 Primary Language CL RPG, SNDDST
MQ software upgrade
I’ve done a number of MQ installs and upgrades of the years and it’s a relatively simple process. Have had a few instances where the upgrade has not successful – usually do to shared memory conflicts (sheme files in the IFS) but as long as the environments are saved the backout works fine. The following [...]
View Answer
| July 22, 2010 1:36 PM
MQ for iSeries, OS upgrade, Software upgrades, V5R4M0
I’ve done a number of MQ installs and upgrades of the years and it’s a relatively simple process. Have had a few instances where the upgrade has not successful – usually do to shared memory conflicts (sheme files in the IFS) but as long as the environments are saved the backout works fine. The following [...]
View Answer
| July 22, 2010 1:36 PM
MQ for iSeries, OS upgrade, Software upgrades, V5R4M0
db2/400
Logical files can include selecti/omit rules Inspection of the DDS or SQL that created the logical would show the rules or use the command DSPFD to see the rules. The logical could also represent a join of two physicals and this could produce the results you describe. Phil
View Answer
| May 13, 2013 9:56 AM
AS400 physical file, DB2, DB2/400, Physical File
Logical files can include selecti/omit rules Inspection of the DDS or SQL that created the logical would show the rules or use the command DSPFD to see the rules. The logical could also represent a join of two physicals and this could produce the results you describe. Phil
View Answer
| May 13, 2013 9:56 AM
AS400 physical file, DB2, DB2/400, Physical File
Anyone know where to find manuals or redbooks of ‘Exit Points’ on the iSeries
Documentation for the host server exit points is collected in the Information Center under the <a href=”http://publib.boulder.ibm.com/infocenter/iseries/v5r4/index.jsp?topic=/rzaii/rzaiimst31.htm”>Use server exit programs</a> topic. Documentation for the TCP/IP servers is distributed across various topics, generally under each server area. For example, for FTP, the documentation is under the <a href=”http://publib.boulder.ibm.com/infocenter/iseries/v5r4/index.jsp?topic=/rzaiq/rzaiqreferenceexit.htm”>File Transfer Protocol exit programs</a> topic; and for the [...]
View Answer
| July 22, 2010 1:48 AM
AS/400, AS/400 Exit Points, Exit Program, iSeries
Documentation for the host server exit points is collected in the Information Center under the <a href=”http://publib.boulder.ibm.com/infocenter/iseries/v5r4/index.jsp?topic=/rzaii/rzaiimst31.htm”>Use server exit programs</a> topic. Documentation for the TCP/IP servers is distributed across various topics, generally under each server area. For example, for FTP, the documentation is under the <a href=”http://publib.boulder.ibm.com/infocenter/iseries/v5r4/index.jsp?topic=/rzaiq/rzaiqreferenceexit.htm”>File Transfer Protocol exit programs</a> topic; and for the [...]
View Answer
| July 22, 2010 1:48 AM
AS/400, AS/400 Exit Points, Exit Program, iSeries
Sponsor Post: Fear the Cloud? Migration Pros and Cons (on-demand chat from 6/29/2010)
I hope this was a good session. We are involved in providing online backup services to our clients. One of the things many businesses are looking for now is the ability to convert a backup disk image into a virtual machine image. This allows for quick deployment of the backup to a cloud based virtual [...]
View Answer
| July 22, 2010 1:44 AM
AS/400, Channel, CIO, CRM, Database, DataCenter, datamangement, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP
I hope this was a good session. We are involved in providing online backup services to our clients. One of the things many businesses are looking for now is the ability to convert a backup disk image into a virtual machine image. This allows for quick deployment of the backup to a cloud based virtual [...]
View Answer
| July 22, 2010 1:44 AM
AS/400, Channel, CIO, CRM, Database, DataCenter, datamangement, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP
No Activity Time Out Session
There is the cheap and easy way that isn’t as precise as many would like and a choice of either a very difficult way or a potentially costly way but both with significant precision. Cheap and easy is by setting the QINACTITV system value to 60 along with setting the QINACTMSGQ system value to be [...]
View Answer
| July 21, 2010 9:33 PM
5250 session, AS/400, iSeries, Timeout
There is the cheap and easy way that isn’t as precise as many would like and a choice of either a very difficult way or a potentially costly way but both with significant precision. Cheap and easy is by setting the QINACTITV system value to 60 along with setting the QINACTMSGQ system value to be [...]
View Answer
| July 21, 2010 9:33 PM
5250 session, AS/400, iSeries, Timeout
Print AS/400 AFP in Deskjet Printer
Laser printers print after a whole page of data is received. The image of the page is built internally then sent to the printer a page at a time. An inkjet printer operates more like a character printer – when it gets enough data to print a line it does so. Special software and/or hardware [...]
View Answer
| July 21, 2010 10:19 AM
AFP Printing, AS/400 Print Problems, AS/400 printing, Printing AS/400 performance
Laser printers print after a whole page of data is received. The image of the page is built internally then sent to the printer a page at a time. An inkjet printer operates more like a character printer – when it gets enough data to print a line it does so. Special software and/or hardware [...]
View Answer
| July 21, 2010 10:19 AM
AFP Printing, AS/400 Print Problems, AS/400 printing, Printing AS/400 performance
wrksyssts shows many active jobs while wrkactjob shows fewer
<i>…203382 active jobs in wrksyssts screen …</i> The WRKSYSSTS screen doesn’t show “active jobs”. It shows “jobs in system”. Usually, the vast majority of jobs in a system are not active. Commonly, jobs that have ended (and are no longer active) after creating spooled files make up most of the total jobs in the system. [...]
View Answer
| July 21, 2010 1:58 AM
AS/400, AS/400 job logs, AS/400 Job Queue, iSeries
<i>…203382 active jobs in wrksyssts screen …</i> The WRKSYSSTS screen doesn’t show “active jobs”. It shows “jobs in system”. Usually, the vast majority of jobs in a system are not active. Commonly, jobs that have ended (and are no longer active) after creating spooled files make up most of the total jobs in the system. [...]
View Answer
| July 21, 2010 1:58 AM
AS/400, AS/400 job logs, AS/400 Job Queue, iSeries
AS400 user profile query
Signed on as a profile that has *secofr capability- run the following: DSPUSRPRF USRPRF(*ALL) OUTPUT(*OUTFILE) OUTFILE(QTEMP/USERS) This will create a file in QTEMP called USERS that can be queried and sorted however you want… ======================================================== But note that only user profiles to which you have authority will be included in the file. This may require [...]
View Answer
| July 20, 2010 11:48 PM
AS/400 Query, AS/400 user profiles
Signed on as a profile that has *secofr capability- run the following: DSPUSRPRF USRPRF(*ALL) OUTPUT(*OUTFILE) OUTFILE(QTEMP/USERS) This will create a file in QTEMP called USERS that can be queried and sorted however you want… ======================================================== But note that only user profiles to which you have authority will be included in the file. This may require [...]
View Answer
| July 20, 2010 11:48 PM
AS/400 Query, AS/400 user profiles
How do I change my i515 control panel to manual mode?
The first thing that you want to keep is the link into the Hardware Information Center for your <a href=”http://publib.boulder.ibm.com/infocenter/powersys/v3r1m5/index.jsp?topic=/iphc5/9407_515_landing.htm”>9407-515 (i5 515)</a>. As long as you keep that, you can always search for {dst} or {manual mode} or anything else about the hardware. After some searching, you’ll eventually run across ‘Control panel concepts’ with the [...]
View Answer
| July 20, 2010 10:39 PM
DST, i515, iSeries, iSeries administration
The first thing that you want to keep is the link into the Hardware Information Center for your <a href=”http://publib.boulder.ibm.com/infocenter/powersys/v3r1m5/index.jsp?topic=/iphc5/9407_515_landing.htm”>9407-515 (i5 515)</a>. As long as you keep that, you can always search for {dst} or {manual mode} or anything else about the hardware. After some searching, you’ll eventually run across ‘Control panel concepts’ with the [...]
View Answer
| July 20, 2010 10:39 PM
DST, i515, iSeries, iSeries administration
Databases vs. Data Structures
You are recruiting for this company and you don’t want them to know that you don’t know what it is you are supposed to be looking for. Tough situation. Data structures are the way the data is stored. Even a DBMS or an RDBMS has a “structure” In one sense, data structures have algorithms built [...]
View Answer
| July 20, 2010 7:04 PM
Data Area Data Structure, Data management, Data structures, Database design, Database servers, Databases
You are recruiting for this company and you don’t want them to know that you don’t know what it is you are supposed to be looking for. Tough situation. Data structures are the way the data is stored. Even a DBMS or an RDBMS has a “structure” In one sense, data structures have algorithms built [...]
View Answer
| July 20, 2010 7:04 PM
Data Area Data Structure, Data management, Data structures, Database design, Database servers, Databases
