Reading a file twice in CL
I declared a file in CL. I read all the records, i.e End Of File has reached. Now again i want to read he file from beginning within the same program.I tried with OVRDBF and POSDBF.But could not succeed.Can any body help me?
Answer Question
| November 18, 2009 6:53 AM
AS/400, Database, DB2 Universal Database, RPG
I declared a file in CL. I read all the records, i.e End Of File has reached. Now again i want to read he file from beginning within the same program.I tried with OVRDBF and POSDBF.But could not succeed.Can any body help me?
Answer Question
| November 18, 2009 6:53 AM
AS/400, Database, DB2 Universal Database, RPG
STRQMQRY not sum up the right total
I try to use STRQMQRY to pass in a variable to run a query. It works great except the query suppose to have a grand total, for some reason, it doesn’t add up right. When i run the query manually without using STRQMQRY, it works fine. Anyone know what do I have to do here? [...]
Answer Question
| November 17, 2009 9:39 AM
AS/400, Database, DB2 Universal Database, RPG
I try to use STRQMQRY to pass in a variable to run a query. It works great except the query suppose to have a grand total, for some reason, it doesn’t add up right. When i run the query manually without using STRQMQRY, it works fine. Anyone know what do I have to do here? [...]
Answer Question
| November 17, 2009 9:39 AM
AS/400, Database, DB2 Universal Database, RPG
Maximum program per trigger event
Hi, Can we have only one program per trigger event on a physical file? For example: On ABC file can we have one one trigger program for Update-After trigger event.
Answer Question
| October 31, 2005 4:49 PM
AS/400, DB2 Universal Database, RPG
Hi, Can we have only one program per trigger event on a physical file? For example: On ABC file can we have one one trigger program for Update-After trigger event.
Answer Question
| October 31, 2005 4:49 PM
AS/400, DB2 Universal Database, RPG
DCLF in CL
Hi! Can I open two database files in a CL program using DCLF? I’ve been trying to do it, but I receive an error related to OPNID. If you could send me an example, it would be greatly appreciated. Thanxs. Melissa
Answer Question
| November 17, 2009 10:49 AM
AS/400, RPG, RPG ILE
Hi! Can I open two database files in a CL program using DCLF? I’ve been trying to do it, but I receive an error related to OPNID. If you could send me an example, it would be greatly appreciated. Thanxs. Melissa
Answer Question
| November 17, 2009 10:49 AM
AS/400, RPG, RPG ILE
ODBC Connections to AS400 from HP-UX or Solaris systems.
I think I have the answer to this question, but I am trying to get confirmation on this. Is there IBM AS400 Client Access ODBC drivers to install on an HP-UX (Unix systems) or Solaris systems that would allow me to create ODBC connections to the AS400 from these systems? I have looked on IBM’s [...]
Answer Question
| October 27, 2005 5:06 PM
AS/400, Database, DB2 Universal Database, RPG
I think I have the answer to this question, but I am trying to get confirmation on this. Is there IBM AS400 Client Access ODBC drivers to install on an HP-UX (Unix systems) or Solaris systems that would allow me to create ODBC connections to the AS400 from these systems? I have looked on IBM’s [...]
Answer Question
| October 27, 2005 5:06 PM
AS/400, Database, DB2 Universal Database, RPG
ISeries web browser 4GL applications.
We have much investment in RPG coded systems that are all ‘home grown’ green screen presentation. We now want to make use of browser technology to present screens in web browser clients (eg. IE) along with nice graphic presentation (Jpegs, gif etc). We’re considering using a 4GL tool like LANSA or mrc-productivity as we don’t [...]
Answer Question
| October 28, 2005 11:18 AM
AS/400, Development, E-business, RPG
We have much investment in RPG coded systems that are all ‘home grown’ green screen presentation. We now want to make use of browser technology to present screens in web browser clients (eg. IE) along with nice graphic presentation (Jpegs, gif etc). We’re considering using a 4GL tool like LANSA or mrc-productivity as we don’t [...]
Answer Question
| October 28, 2005 11:18 AM
AS/400, Development, E-business, RPG
Impact Analysis – None Answered till now
Hi all, I have a question and submitted long back. But till now i didn’t get any reponse. Task: If there is any change in the length of a field or a new field added into the existing file, we need to do some Impact Analysis which is time consuming.So i thought of developing a [...]
Answer Question
| November 30, 2010 2:58 AM
AS/400, Database, DB2 Universal Database, RPG
Hi all, I have a question and submitted long back. But till now i didn’t get any reponse. Task: If there is any change in the length of a field or a new field added into the existing file, we need to do some Impact Analysis which is time consuming.So i thought of developing a [...]
Answer Question
| November 30, 2010 2:58 AM
AS/400, Database, DB2 Universal Database, RPG
Save while active question
In trying to get a save while active cl program to work correctly I am having the following dificulty when trying to do a monsmg on the message CPI3712 which is when I want to restart the subsystems so our 911 dispatch center can resume their work I tried the monmsg statement right after the [...]
Answer Question
| November 14, 2005 1:33 PM
AS/400, RPG
In trying to get a save while active cl program to work correctly I am having the following dificulty when trying to do a monsmg on the message CPI3712 which is when I want to restart the subsystems so our 911 dispatch center can resume their work I tried the monmsg statement right after the [...]
Answer Question
| November 14, 2005 1:33 PM
AS/400, RPG
Error executing stored procedure calling a CL that run an STRQMQRY
I have created a stored procedure that call a CLP in which there is a STRQMQRY for creating a file in output. this is the command of creation: CREATE PROCEDURE TESMC/WP3007P (IN SALD CHAR ( 1), IN ORDIN CHAR (1)) LANGUAGE CL NOT DETERMINISTIC MODIFIES SQL DATA EXTERNAL NAME ‘TESMC/WP3007′ PARAMETER STYLE GENERAL when I [...]
Answer Question
| October 27, 2005 12:15 PM
AS/400, Database, DB2 Universal Database, RPG
I have created a stored procedure that call a CLP in which there is a STRQMQRY for creating a file in output. this is the command of creation: CREATE PROCEDURE TESMC/WP3007P (IN SALD CHAR ( 1), IN ORDIN CHAR (1)) LANGUAGE CL NOT DETERMINISTIC MODIFIES SQL DATA EXTERNAL NAME ‘TESMC/WP3007′ PARAMETER STYLE GENERAL when I [...]
Answer Question
| October 27, 2005 12:15 PM
AS/400, Database, DB2 Universal Database, RPG
having trouble restoring a tape written by a Sys38
the tape file is not created by a SAV*. We’ve been trying various combinations of CPYFRMTAP without any luck….. all three data file label say rec length =0 and block length = 16384. the dumped data looks like it might be a library…. with sources files. any ideas??
Answer Question
| November 17, 2009 12:52 PM
AS/400, RPG
the tape file is not created by a SAV*. We’ve been trying various combinations of CPYFRMTAP without any luck….. all three data file label say rec length =0 and block length = 16384. the dumped data looks like it might be a library…. with sources files. any ideas??
Answer Question
| November 17, 2009 12:52 PM
AS/400, RPG
Cannot Print Barcodes to a Non-IPDS SCS Printer (HP Laser Jet 2400 and Lexmark T632)
I am trying to print barcodes (3 of 9) on 2 types of printers. Both are non-ipds printers connected to the AS400. These are both just plain printers using the SCS datastream. I have found the PCL commands to print out the bar code from this site (www.pbhall.us/barcode.html) using the TRNSPY and CVTDTA keywords in [...]
Answer Question
| October 27, 2005 11:50 AM
AS/400, Printers, RPG
I am trying to print barcodes (3 of 9) on 2 types of printers. Both are non-ipds printers connected to the AS400. These are both just plain printers using the SCS datastream. I have found the PCL commands to print out the bar code from this site (www.pbhall.us/barcode.html) using the TRNSPY and CVTDTA keywords in [...]
Answer Question
| October 27, 2005 11:50 AM
AS/400, Printers, RPG
MMAIL
Hello everyone, I recently downloaded the MMAIL Utility for Windows from http://www-922.ibm.com/mmailh/wmimemenu.htm I believe it installed successfully, but I get the following error for several functions like edit, display or open mime files. Error: “The value specified for one of the parameters is not valid for QZRUCLSP API.” Any help will be greatly appreciated. Joe [...]
Answer Question
| November 16, 2009 9:58 AM
AS/400, Database, DB2 Universal Database, RPG
Hello everyone, I recently downloaded the MMAIL Utility for Windows from http://www-922.ibm.com/mmailh/wmimemenu.htm I believe it installed successfully, but I get the following error for several functions like edit, display or open mime files. Error: “The value specified for one of the parameters is not valid for QZRUCLSP API.” Any help will be greatly appreciated. Joe [...]
Answer Question
| November 16, 2009 9:58 AM
AS/400, Database, DB2 Universal Database, RPG
OPNDBF
This may sound stupid but I have not used OPNDBF command till now. I tried to use it thinking it will perform the same function as opening a database file in a COBOL program. I issued OPNDBF in a CL program and then tried to read records within a COBOL program without opening it in [...]
Answer Question
| November 16, 2009 4:49 AM
AS/400, Database, DB2 Universal Database, RPG
This may sound stupid but I have not used OPNDBF command till now. I tried to use it thinking it will perform the same function as opening a database file in a COBOL program. I issued OPNDBF in a CL program and then tried to read records within a COBOL program without opening it in [...]
Answer Question
| November 16, 2009 4:49 AM
AS/400, Database, DB2 Universal Database, RPG
RPGLE Build in function (BIF)
It is imposable for me to set the length of Variable-Length Field D ServUser S 30A VARYING D IDLenth S 3i 0 C Eval %Len(ServUser) = IDLenth After this statement length of field ServUser still is 30 pos long. In Debug mode I get the message CPF7E2B: Type compatibility error occurred. Thank you for helping. [...]
Answer Question
| November 15, 2009 10:52 AM
RPG
It is imposable for me to set the length of Variable-Length Field D ServUser S 30A VARYING D IDLenth S 3i 0 C Eval %Len(ServUser) = IDLenth After this statement length of field ServUser still is 30 pos long. In Debug mode I get the message CPF7E2B: Type compatibility error occurred. Thank you for helping. [...]
Answer Question
| November 15, 2009 10:52 AM
RPG
Processing time used by a job
Herman would like to know: How can one programmatically retrieve the total processing unit time (CPU time) used by a job? – Michelle Davidson, editor, Search400.com
Answer Question
| November 15, 2009 9:13 PM
AS/400, RPG
Herman would like to know: How can one programmatically retrieve the total processing unit time (CPU time) used by a job? – Michelle Davidson, editor, Search400.com
Answer Question
| November 15, 2009 9:13 PM
AS/400, RPG
CPYTOPCD command.
Are any of you familiar with this command? Can this be used to copy something from the AS400 to a shared folder on a Windows system, or do any of you know how to accomplish this?
Answer Question
| November 16, 2009 4:12 PM
AS/400, Database, DB2 Universal Database, RPG
Are any of you familiar with this command? Can this be used to copy something from the AS400 to a shared folder on a Windows system, or do any of you know how to accomplish this?
Answer Question
| November 16, 2009 4:12 PM
AS/400, Database, DB2 Universal Database, RPG
Access LDA for job waiting on a JOBQ
Is there a way to access the LDA for a job that is waiting in the JOBQ? I want to write a program to monitor jobs in a JOBQ and move them to other JOBQs based on information that is in the LDA.
Answer Question
| November 15, 2009 2:11 PM
AS/400, RPG
Is there a way to access the LDA for a job that is waiting in the JOBQ? I want to write a program to monitor jobs in a JOBQ and move them to other JOBQs based on information that is in the LDA.
Answer Question
| November 15, 2009 2:11 PM
AS/400, RPG
Need help using RUNRMTCMD
Greg is experimenting with the RUNRMTCMD on the AS/400 from a command line. He writes, “Can I run a VRPG exe on my local PC from the AS/400? If so, how? I keep getting a message CPE3447 ‘A remote host did not respond within the timeout period’. First, where can I get my local PC [...]
Answer Question
| November 15, 2009 10:09 AM
AS/400, RPG
Greg is experimenting with the RUNRMTCMD on the AS/400 from a command line. He writes, “Can I run a VRPG exe on my local PC from the AS/400? If so, how? I keep getting a message CPE3447 ‘A remote host did not respond within the timeout period’. First, where can I get my local PC [...]
Answer Question
| November 15, 2009 10:09 AM
AS/400, RPG
Unable to place file on the IFS drive
I have a vendor who is providing an update via download from their website. The instructions are to save the zip-file to a PC, then un-zip the contents to the IFS drive. When I specify the IFS drive (in the un-zip process) and hit enter, the message; Error, access is denied followed by, Cannot create [...]
Answer Question
| October 11, 2005 11:41 AM
AS/400, RPG
I have a vendor who is providing an update via download from their website. The instructions are to save the zip-file to a PC, then un-zip the contents to the IFS drive. When I specify the IFS drive (in the un-zip process) and hit enter, the message; Error, access is denied followed by, Cannot create [...]
Answer Question
| October 11, 2005 11:41 AM
AS/400, RPG
SYSTEM OPENESS INCLUDES
Hello everyone, I wanted to install the OS/400 System Openness Includes (5722-SS1, opt13). I found 12 CD’s labeled 5722-SS1. I listed them below. I was wondering if someone knew which one to use to install the System Openness Includes. Any help is greatly appreciated. I_BASE-01 L2924_01 L2924_02 B2924_01 B2924_02 B2924_03 B2924_04 B2924_05 B2924_06 B2924_07 B2924_08 [...]
Answer Question
| October 7, 2005 9:30 AM
AS/400, Database, DB2 Universal Database, RPG
Hello everyone, I wanted to install the OS/400 System Openness Includes (5722-SS1, opt13). I found 12 CD’s labeled 5722-SS1. I listed them below. I was wondering if someone knew which one to use to install the System Openness Includes. Any help is greatly appreciated. I_BASE-01 L2924_01 L2924_02 B2924_01 B2924_02 B2924_03 B2924_04 B2924_05 B2924_06 B2924_07 B2924_08 [...]
Answer Question
| October 7, 2005 9:30 AM
AS/400, Database, DB2 Universal Database, RPG
