*PSSR is not executed
The exception error handler routine (*pssr) is not executed, instead the program abends when it encounters say for example record locked by other user.
The exception error handler routine (*pssr) is not executed, instead the program abends when it encounters say for example record locked by other user.
0 pts.
Cross reference tool
Hello, I'm currently working in an AS400 native RPG-environment, not ILE, and I want to create a cross reference for a part of the system(about 10 libraries). I'd like to create this by myself with the common commands on our system, I can do this thru DSPPGMREF and DSPBDR, DSPFD, DSPFFD, etc......
Hello, I'm currently working in an AS400 native RPG-environment, not ILE, and I want to create a cross reference for a part of the system(about 10 libraries). I'd like to create this by myself with the common commands on our system, I can do this thru DSPPGMREF and DSPBDR, DSPFD, DSPFFD, etc......
Multiple result sets returned from embedded SQL in RPG
I am trying to follow various examples (examples from Iseries Network and IBM manuals) for declaring a cursor and fetching records. I have no problem with simple statements. I am having trouble converting a statement containing a subquery. The more I look at different examples, the more trouble...
I am trying to follow various examples (examples from Iseries Network and IBM manuals) for declaring a cursor and fetching records. I have no problem with simple statements. I am having trouble converting a statement containing a subquery. The more I look at different examples, the more trouble...
F4 to open Selection List Window
When the user presses F4 in a field for a list of values to select from, I open a Selection List Window. When I return from the window with the selected value for my prompted field all of the data entered into the other fields is gone. Because the display format is not read before the prompt is...
When the user presses F4 in a field for a list of values to select from, I open a Selection List Window. When I return from the window with the selected value for my prompted field all of the data entered into the other fields is gone. Because the display format is not read before the prompt is...
PRINTING OVERLAYS FOR MUTIPLE PAGE LETTER
Is it possible in a printer file to have the duplex feature on using a front overlay and a back overlay, but use the FORCE keyword to have it print on two pages - not front and back? I know that the back overlay only works when duplexing is on. Anyone up for a challenge. Thanks.
Is it possible in a printer file to have the duplex feature on using a front overlay and a back overlay, but use the FORCE keyword to have it print on two pages - not front and back? I know that the back overlay only works when duplexing is on. Anyone up for a challenge. Thanks.
CPYFRMIMPF Command Submitting multiple jobs.
Submitting multiple jobs to do a copy to an AS400 standardized file. This is a great command. I have two systems that I use it on. It works well on one system, however, on the other one it likes to submit multiple jobs to copy blocks of 60,700 records,(reminds me of the old FTP process on the...
Submitting multiple jobs to do a copy to an AS400 standardized file. This is a great command. I have two systems that I use it on. It works well on one system, however, on the other one it likes to submit multiple jobs to copy blocks of 60,700 records,(reminds me of the old FTP process on the...
SAVOBJ with different OS release on target
I am trying to FTP a file between two as400 boxes, for which I have to use SAVOBJ on the source and RSTOBJ on the target. Now the source has a higher OS release than the target, so I can use the release version of target system in the "target release" option of the SAVOBJ. But SAVOBJ does not...
I am trying to FTP a file between two as400 boxes, for which I have to use SAVOBJ on the source and RSTOBJ on the target. Now the source has a higher OS release than the target, so I can use the release version of target system in the "target release" option of the SAVOBJ. But SAVOBJ does not...
Upload and format CSV file to AS400.
I have a program that simply reads an uploaded CSV Excel file (CUPOBL), formats the fields and writes to a physical file on the AS400. The program currently writes the desired 20 records (disregards record 1), but does not populate with data. I can email a copy of the csv and a text file of the...
I have a program that simply reads an uploaded CSV Excel file (CUPOBL), formats the fields and writes to a physical file on the AS400. The program currently writes the desired 20 records (disregards record 1), but does not populate with data. I can email a copy of the csv and a text file of the...
Printing UCC EAN 128 from RPG on AS/400
Hello I am trying to Print Bar Code 128 with FNC1 (Which identifies symbology as "UCC/EAN - 128"). I am able to print simple bar code 128 but not able to add this symbology. I am using the BARCODE keyword. Is it possible to print a UCC/EAN 128 using this keyword? If yes, How will I use it? I am...
Hello I am trying to Print Bar Code 128 with FNC1 (Which identifies symbology as "UCC/EAN - 128"). I am able to print simple bar code 128 but not able to add this symbology. I am using the BARCODE keyword. Is it possible to print a UCC/EAN 128 using this keyword? If yes, How will I use it? I am...
Finding a program statement number in the Program Status Data Structure.
According to the ILE RPG Reference manual, positions 21 - 28 of the SDS should contain the statement or listing number at the time of the dump. Whenever I deliberately invoke the dump (via *PSSR) this value is zero. I have checked it in debug mode before and after the actual DUMP and the value is...
According to the ILE RPG Reference manual, positions 21 - 28 of the SDS should contain the statement or listing number at the time of the dump. Whenever I deliberately invoke the dump (via *PSSR) this value is zero. I have checked it in debug mode before and after the actual DUMP and the value is...
controlling display files built with dds when windowed selection list is overlaid file format
When I display a windowed selection list over the current display file format, data from FIRST INSTANCE of this file format is returned to the background(behind the selection list). When I exit the selection list, current format is redisplayed with current data. Window is diplayed from a called...
When I display a windowed selection list over the current display file format, data from FIRST INSTANCE of this file format is returned to the background(behind the selection list). When I exit the selection list, current format is redisplayed with current data. Window is diplayed from a called...
Using keyword IN in Dynamic SQL WHERE clause
In an RPGLE program I am using embedded SQL. I would like a Where clause that says: WHERE BankCode in (:BankList) and I want BankList to be a dynamic list of banks selected by the user. BankCode is defined as 4,0 decimal and BankList is defined as Character since it may have several banks...
In an RPGLE program I am using embedded SQL. I would like a Where clause that says: WHERE BankCode in (:BankList) and I want BankList to be a dynamic list of banks selected by the user. BankCode is defined as 4,0 decimal and BankList is defined as Character since it may have several banks...
Calling an API from a RPGIII/IV program, the system is a IBM I5 Iseries.
How do you set-up a data structure for the error code fields used to call and API-QSYGETPH.
How do you set-up a data structure for the error code fields used to call and API-QSYGETPH.
AS/400 Trigger programming
Sir, I have a trigger program on a file (File1) with INSERT / UPDATE / DELETE. The requirement is to execute the business logic on the same file (File1). So I'm opening File1 in trigger program in update/add mode. I know that it is not recommended to use the same file in trigger program. The...
Sir, I have a trigger program on a file (File1) with INSERT / UPDATE / DELETE. The requirement is to execute the business logic on the same file (File1). So I'm opening File1 in trigger program in update/add mode. I know that it is not recommended to use the same file in trigger program. The...
Certification in RPG
I am planning to get certified in RPG from IBM. Is it a good idea? Could you suggest some self study material please. Thanks
I am planning to get certified in RPG from IBM. Is it a good idea? Could you suggest some self study material please. Thanks
RRN Chain to subfile in RPG-Free
How does one find whether a record is found or not while chaining with RRN to a subfile? Indicators are no good, %Found and %Eof are not valid for subfiles?
How does one find whether a record is found or not while chaining with RRN to a subfile? Indicators are no good, %Found and %Eof are not valid for subfiles?
Importing iSeries SpoolFiles in Windows
I'm importing succesfully iSeries Spoolfiles in Windows Systems with an ActiveX/VisualBasic application and the CA400's cwbobj.dll. In order to optimize my VB app I would like to have specific informations about cwbobj's function ReadSplf and about filtering the Spoolfiles list by Outq. (Sorry...
I'm importing succesfully iSeries Spoolfiles in Windows Systems with an ActiveX/VisualBasic application and the CA400's cwbobj.dll. In order to optimize my VB app I would like to have specific informations about cwbobj's function ReadSplf and about filtering the Spoolfiles list by Outq. (Sorry...
Run PC command from CL program
Is it possible to run a PC batch file from a CL program, and, if so, how? Thanks.
Is it possible to run a PC batch file from a CL program, and, if so, how? Thanks.
Convert an iso date to julian date
I'm writing an rpgle pgm and I need to convert an iso date to a julian date. They don't have taatool here. Was wondering if anyone has an example on how to do this? Thanks in advance for any help
I'm writing an rpgle pgm and I need to convert an iso date to a julian date. They don't have taatool here. Was wondering if anyone has an example on how to do this? Thanks in advance for any help
Restoring Source Files on the iSeries
We are moving to a new i5/iSeries machine. We will be doing a full backup, then a restore, then a SAVCHGOBJ. However, in the past, when we've done a restore of a source file, the existing members get renamed (SRCMBR00001) and the members from the restore get put in correctly. Does anybody know...
We are moving to a new i5/iSeries machine. We will be doing a full backup, then a restore, then a SAVCHGOBJ. However, in the past, when we've done a restore of a source file, the existing members get renamed (SRCMBR00001) and the members from the restore get put in correctly. Does anybody know...
