How to FTP a file from PC to my personal library?
How to FTP a file from PC to my personal library?
Answer Question
| April 1, 2008 11:14 AM
AS/400, AS/400 FTP, RPG ILE, RPG IV, RPGLE
How to FTP a file from PC to my personal library?
Answer Question
| April 1, 2008 11:14 AM
AS/400, AS/400 FTP, RPG ILE, RPG IV, RPGLE
How to read records in all of the members of a single pf?
I have a file name file1. it has 30 members. i have a input value from a display file and i need to check it in all the members. If it match i write the record in file2. How to read records in all members of a single pf?
Answer Question
| March 27, 2008 7:13 AM
AS/400, RPG IV, RPGILE, RPGLE
I have a file name file1. it has 30 members. i have a input value from a display file and i need to check it in all the members. If it match i write the record in file2. How to read records in all members of a single pf?
Answer Question
| March 27, 2008 7:13 AM
AS/400, RPG IV, RPGILE, RPGLE
How do I find out how many lines of source code are on the system?
Hello. I’m trying to write a program that will tell me how many lines of source code reside on our system. I figured out the first couple of steps, but it just gets more and more confusing along the way, and I really think there’s gotta be a better way to get the information i [...]
Answer Question
| April 26, 2011 1:52 PM
CL, iSeries development, ODCRTS, ODSRCF, ODSRCL, ODSRCM, QRPGLESRC, QSYS.LIB, RPGLE, RTVNETA
Hello. I’m trying to write a program that will tell me how many lines of source code reside on our system. I figured out the first couple of steps, but it just gets more and more confusing along the way, and I really think there’s gotta be a better way to get the information i [...]
Answer Question
| April 26, 2011 1:52 PM
CL, iSeries development, ODCRTS, ODSRCF, ODSRCL, ODSRCM, QRPGLESRC, QSYS.LIB, RPGLE, RTVNETA
How many types of Data Area are there in RPGLE
How many types of Data Area are there in RPGLE..
Answer Question
| March 21, 2012 6:00 AM
AS/400, RPGLE
How many types of Data Area are there in RPGLE..
Answer Question
| March 21, 2012 6:00 AM
AS/400, RPGLE
*DTAARA DEFINE LDA in RPGLE
what is the meaning of this statement “*DTAARA DEFINE LDA” in RPGLE
Answer Question
| March 11, 2008 5:46 AM
AS/400, RPGLE
what is the meaning of this statement “*DTAARA DEFINE LDA” in RPGLE
Answer Question
| March 11, 2008 5:46 AM
AS/400, RPGLE
EVAL Math Problem
Bruce, can you figure out this piece of code? I don’t understand the result I get. Before code is executed: XXAVAL = 0, LTSTHQ = 30, LTCUSQ = 30, LTPICQ = 0, XPQTY = 30, OLOLQT = 30 EVAL XXAVAL= LTSTHQ-(LTCUSQ+LTPICQ+XPQTY)+OLOLQT After code is executed: XXAVAL = 0. I figured XXAVAL should be 60?
Answer Question
| May 8, 2008 5:09 PM
iSeries development, RPGLE
Bruce, can you figure out this piece of code? I don’t understand the result I get. Before code is executed: XXAVAL = 0, LTSTHQ = 30, LTCUSQ = 30, LTPICQ = 0, XPQTY = 30, OLOLQT = 30 EVAL XXAVAL= LTSTHQ-(LTCUSQ+LTPICQ+XPQTY)+OLOLQT After code is executed: XXAVAL = 0. I figured XXAVAL should be 60?
Answer Question
| May 8, 2008 5:09 PM
iSeries development, RPGLE
Having trouble with DB2/400 UDF returning a table.
I’ve written a test RPGLE program (not a service program) to return a table that for testing puposes I’m returning 1 row and 1 hard coded return column that is defined as varchar. I’m building the return value by concatonating the input parameters. Anyhow I tried running it using interactive SQL. I waited about 30seconds [...]
Answer Question
| October 30, 2009 12:25 AM
DB2/400, RPGLE, SQL, Table Functions, UDF
I’ve written a test RPGLE program (not a service program) to return a table that for testing puposes I’m returning 1 row and 1 hard coded return column that is defined as varchar. I’m building the return value by concatonating the input parameters. Anyhow I tried running it using interactive SQL. I waited about 30seconds [...]
Answer Question
| October 30, 2009 12:25 AM
DB2/400, RPGLE, SQL, Table Functions, UDF
formatting date of 1070112 as 12-01-2007
I am having the date format of 1070112(yyddmm), which i’ve to convert into the form of 12-01-2007(ddmmyyyy)using RPGLE.
Answer Question
| February 20, 2008 11:26 AM
AS/400, RPGLE
I am having the date format of 1070112(yyddmm), which i’ve to convert into the form of 12-01-2007(ddmmyyyy)using RPGLE.
Answer Question
| February 20, 2008 11:26 AM
AS/400, RPGLE
Multiple Sorts Without Using Multiple Function Keys
When doing WRKACTJOB, you can put the cursor over the column you wish to sort and then press F16. I have a subfile program with multiple sorts and presently the user has to press different function keys to sort. Can anyone give me an example of the code to use so my program will act [...]
Answer Question
| February 12, 2008 2:10 AM
RPG, RPGLE, Subfile
When doing WRKACTJOB, you can put the cursor over the column you wish to sort and then press F16. I have a subfile program with multiple sorts and presently the user has to press different function keys to sort. Can anyone give me an example of the code to use so my program will act [...]
Answer Question
| February 12, 2008 2:10 AM
RPG, RPGLE, Subfile
service progarm
how serivce programs are created .pls tell me steps of creataing a service program.
Answer Question
| February 7, 2008 9:46 AM
RPGLE
how serivce programs are created .pls tell me steps of creataing a service program.
Answer Question
| February 7, 2008 9:46 AM
RPGLE
User Exit Programs-FTP
Hello I am strggling with first user exit program. I only want to allow specific users (those keyed into a file), to be able to log into FTP. In addition, I only want to allow the function of the SENDING of files, once logged in. I am struggling with how to capture the user id [...]
Answer Question
| February 5, 2008 2:20 PM
CL, RPGLE, User Exit Program FTP
Hello I am strggling with first user exit program. I only want to allow specific users (those keyed into a file), to be able to log into FTP. In addition, I only want to allow the function of the SENDING of files, once logged in. I am struggling with how to capture the user id [...]
Answer Question
| February 5, 2008 2:20 PM
CL, RPGLE, User Exit Program FTP
%replace BIF
Anyone have an example how to use this bif?
Answer Question
| January 18, 2008 10:57 PM
RPG, RPG ILE, RPGILE, RPGLE
Anyone have an example how to use this bif?
Answer Question
| January 18, 2008 10:57 PM
RPG, RPG ILE, RPGILE, RPGLE
calling a C function in COBOL ILE
In RPGLE I can call a C function like this: D sin PR extproc(‘sin’) D parm F value C Eval mySine = sin( deg ) How do I do this in COBOL? Any examples? Thank you.
Answer Question
| January 3, 2008 6:15 PM
AS/400, COBOL, ILE for iSeries, RPGLE
In RPGLE I can call a C function like this: D sin PR extproc(‘sin’) D parm F value C Eval mySine = sin( deg ) How do I do this in COBOL? Any examples? Thank you.
Answer Question
| January 3, 2008 6:15 PM
AS/400, COBOL, ILE for iSeries, RPGLE
How to check for a junk value in Numeric Field in RPGLE
How to check for a junk value in Numeric Field in RPGLE?
Answer Question
| December 26, 2007 11:01 AM
AS/400, RPGLE
How to check for a junk value in Numeric Field in RPGLE?
Answer Question
| December 26, 2007 11:01 AM
AS/400, RPGLE
Cursor using update and order
I’d like to declare a cursor to traverse a file in keyed order, updating some records It looks like I can do one or the other, but not both, that is I can set up the cursor with the order phrase or the update phrase buy not both. Is there a reason for this limitation? [...]
Answer Question
| December 24, 2007 10:17 PM
RPG, RPGLE, SQL
I’d like to declare a cursor to traverse a file in keyed order, updating some records It looks like I can do one or the other, but not both, that is I can set up the cursor with the order phrase or the update phrase buy not both. Is there a reason for this limitation? [...]
Answer Question
| December 24, 2007 10:17 PM
RPG, RPGLE, SQL
How to update in SQL using DS
My problem is that I’m basically doing an interactive update/create file (similar to DFU). The user is able to maintain a file in the screen, so how do I go about updating the ENTIRE File without having to manually update every record? I have a datastructure (cpRec) to put in the info from the file [...]
Answer Question
| January 3, 2008 8:23 PM
RPGLE, SQL
My problem is that I’m basically doing an interactive update/create file (similar to DFU). The user is able to maintain a file in the screen, so how do I go about updating the ENTIRE File without having to manually update every record? I have a datastructure (cpRec) to put in the info from the file [...]
Answer Question
| January 3, 2008 8:23 PM
RPGLE, SQL
SQL update question
I’m new to SQl and cannot figure out how to do an update without listing every field in the record, sorry, row. The file I’m updating has about 50 fields, any of which might be changed. They are in an external ds that maps the record format, so it would be nice to say update [...]
Answer Question
| December 20, 2007 11:36 PM
AS/400, RPG, RPGILE, RPGLE, SQL
I’m new to SQl and cannot figure out how to do an update without listing every field in the record, sorry, row. The file I’m updating has about 50 fields, any of which might be changed. They are in an external ds that maps the record format, so it would be nice to say update [...]
Answer Question
| December 20, 2007 11:36 PM
AS/400, RPG, RPGILE, RPGLE, SQL
SQL and CL
I would like to learn more about putting SQL in CL and RPGLE. What is a good way to learn about this?
Answer Question
| December 25, 2007 5:33 PM
CL, RPGLE, SQL
I would like to learn more about putting SQL in CL and RPGLE. What is a good way to learn about this?
Answer Question
| December 25, 2007 5:33 PM
CL, RPGLE, SQL
Advanced Trigger question for *insert *before to allow update of field value
I need to update a field in a record being written prior to it being written. I want to do it with a trigger because many programs write and update this file. I have tried several things and the closest I have gotten is to do a *before *insert where I can see the values [...]
Answer Question
| August 4, 2010 7:02 PM
RPG, RPG ILE, RPG IV, RPGILE, RPGLE
I need to update a field in a record being written prior to it being written. I want to do it with a trigger because many programs write and update this file. I have tried several things and the closest I have gotten is to do a *before *insert where I can see the values [...]
Answer Question
| August 4, 2010 7:02 PM
RPG, RPG ILE, RPG IV, RPGILE, RPGLE
How can I tell what fields from what files are being used in a rpgle program?
I need to know which fields from which files are being used in the program. The compilation listing helps but doesn’t tell me which file.
Answer Question
| December 25, 2007 4:18 PM
RPGLE
I need to know which fields from which files are being used in the program. The compilation listing helps but doesn’t tell me which file.
Answer Question
| December 25, 2007 4:18 PM
RPGLE
