Creation of logical file
Can I create a logical file in some other library that is different from the physical file's library on which the Logical is based.. OR both PF and LF need to exist in the same library??
Can I create a logical file in some other library that is different from the physical file's library on which the Logical is based.. OR both PF and LF need to exist in the same library??
0 pts.
Read operation on a subfile
Hi, Can we use the READ opcode on a subfile as we do on a database file? thanks
Hi, Can we use the READ opcode on a subfile as we do on a database file? thanks
Connect to AS/400 from a PC and run User Profiles Initial Program
I'd like to be able to have a user connect via FTP, ect. from a PC to our AS/400, login, and have the user profiles inital program run immediately. We've tried several options, but the initial program doesn't run unless a user signs on to a Session. This is not an option. Can you help? Thanks
I'd like to be able to have a user connect via FTP, ect. from a PC to our AS/400, login, and have the user profiles inital program run immediately. We've tried several options, but the initial program doesn't run unless a user signs on to a Session. This is not an option. Can you help? Thanks
Download report from iSeries to PC with proper page break
I currently use Client Access Ooperations Navigator to download a report to my PC by dragging the output file onto my PC desktop. This correctly produces a report that I can print from my PC but it does not put in the page breaks that existed on the iSeries. Is there a way to keep the same page...
I currently use Client Access Ooperations Navigator to download a report to my PC by dragging the output file onto my PC desktop. This correctly produces a report that I can print from my PC but it does not put in the page breaks that existed on the iSeries. Is there a way to keep the same page...
error message RNX9001
I have a RPGILE which input X and Y and return Z as (X to the power of Y) eg X = 2 and Y = 2 then Z = 4 I define X, Y and Z as 30P9 However when I can this function with parmeter X= 10 and Y = 10 Error occur like this : Can anyone tell me how to fix it or why error come out ? Many thanks ILE...
I have a RPGILE which input X and Y and return Z as (X to the power of Y) eg X = 2 and Y = 2 then Z = 4 I define X, Y and Z as 30P9 However when I can this function with parmeter X= 10 and Y = 10 Error occur like this : Can anyone tell me how to fix it or why error come out ? Many thanks ILE...
Sub-pgm is to calculate X to the power of Y and then return Z. (using RPGIV / RPGILE)
Hello Because I am new to RPGIV (existing using RPGIII) . Recently I need to write a sub-program using RPGIV (or RPGILE ? ). This sub-program will receive two parmerter (X , Y) and output one parmeter (Z) (which are in numeric format - BTW what is the max precision for numeric format in RPGIV /...
Hello Because I am new to RPGIV (existing using RPGIII) . Recently I need to write a sub-program using RPGIV (or RPGILE ? ). This sub-program will receive two parmerter (X , Y) and output one parmeter (Z) (which are in numeric format - BTW what is the max precision for numeric format in RPGIV /...
Load All - Using Position To
Can I use a Position To field in a Load all subfile. I don't want to clear the subfile every time as we do in a single Page subfile. How will the Page up and Page down features be affected if I use a Position to in a Load All subfile? Any help would be appreciated.
Can I use a Position To field in a Load all subfile. I don't want to clear the subfile every time as we do in a single Page subfile. How will the Page up and Page down features be affected if I use a Position to in a Load All subfile? Any help would be appreciated.
Anyone know how RPG handle the calculation of n X where X & n are fraction (decimal number) ? if no, can RPG IV do ?-2
Anyone know how RPG handle the calculation of n X where X & n are fraction (decimal number) ? if no, can RPG IV do ?
Anyone know how RPG handle the calculation of n X where X & n are fraction (decimal number) ? if no, can RPG IV do ?
Anyone know how RPG handle the calculation of n X where X & n are fraction (decimal number) ? if no, can RPG IV do ?
Anyone know how RPG handle the calculation of n X where X & n are fraction (decimal number) ? if no, can RPG IV do ?
Anyone know how RPG handle the calculation of n X where X & n are fraction (decimal number) ? if no, can RPG IV do ?
Calculation of (num) 1/n (square root) using RPG
Do any one know how to handle below formula using RPG or else method which can be implement on AS400 RPG program : The formula is (number ) 1/n 1/n = mean 1 over n square root N= certain number and with decimal digit eg. 1.21 Please send me some suggestion about this . Many thanks Beside you...
Do any one know how to handle below formula using RPG or else method which can be implement on AS400 RPG program : The formula is (number ) 1/n 1/n = mean 1 over n square root N= certain number and with decimal digit eg. 1.21 Please send me some suggestion about this . Many thanks Beside you...
Question on SETGT
Suppose if my logical file has records arranged in descending order of key field..say the LF has the following records EMPNO 10020 10015 10012 10011 10008 10005 10004 Now if I do SETGT with search argument as 10013, will the file pointer position on 10015 and the read operation will read 10015,...
Suppose if my logical file has records arranged in descending order of key field..say the LF has the following records EMPNO 10020 10015 10012 10011 10008 10005 10004 Now if I do SETGT with search argument as 10013, will the file pointer position on 10015 and the read operation will read 10015,...
Return compared to Set on LR
What is the difference between RETURN and SET on LR indicators? What exactly each one of them does?
What is the difference between RETURN and SET on LR indicators? What exactly each one of them does?
Application/example using OPNQRYF
Can somebody give me an example where they felt that using OPNQRYF would be an optimized solution rather than creating a logical file?
Can somebody give me an example where they felt that using OPNQRYF would be an optimized solution rather than creating a logical file?
HELP
I'D LIKE TO ASK HELP IN PROGRAMMING ESPECIALLY IN VISUAL BASIC.PLS SEND ME UPDATES ON DATABASE PROGRAMMING, INTERNET AND OTHER RELATED AND IMPORTANT KNOWLEDGES. THANKS.
I'D LIKE TO ASK HELP IN PROGRAMMING ESPECIALLY IN VISUAL BASIC.PLS SEND ME UPDATES ON DATABASE PROGRAMMING, INTERNET AND OTHER RELATED AND IMPORTANT KNOWLEDGES. THANKS.
Printing on AS/400
Can we dynamically control the number of copies to be printed on AS/400 session. Any help on this would be appreciated. Thanks
Can we dynamically control the number of copies to be printed on AS/400 session. Any help on this would be appreciated. Thanks
CHGPRTF
If I change the attributes of a printer file, say LPI,CPI..etc using CHGPRTF command, do I need to compile the RPG program again that uses this printer file?? Thanks
If I change the attributes of a printer file, say LPI,CPI..etc using CHGPRTF command, do I need to compile the RPG program again that uses this printer file?? Thanks
Record Selection
I have a requirement : Say on a display file screen if you enter a particular department, then the next screen should show employee details of that department only. Can I use OPNQRYF for selection of records based on department and then call the RPG prog. which will show the next screen..Will...
I have a requirement : Say on a display file screen if you enter a particular department, then the next screen should show employee details of that department only. Can I use OPNQRYF for selection of records based on department and then call the RPG prog. which will show the next screen..Will...
Data queues in RPG
Has somebody used a data queue in a RPG program.If so, what is the advantage of using a data queue. Can I have an example.
Has somebody used a data queue in a RPG program.If so, what is the advantage of using a data queue. Can I have an example.
OVRDBF command
Suppose I use the following command in my CL program: OVRDBF file(Test) tofile(Qtemp/Test) Now I call my RPG program which has the file named Test. If I have to write records to the Test file, does that mean that the records will be written to the Qtemp/Test file ? If that is the case then my...
Suppose I use the following command in my CL program: OVRDBF file(Test) tofile(Qtemp/Test) Now I call my RPG program which has the file named Test. If I have to write records to the Test file, does that mean that the records will be written to the Qtemp/Test file ? If that is the case then my...
OPNQRYF vs. Logical
Hi, I am not very clear as to when should we use OPNQRYF and when should we use Logical file? Since logical file also offers DYNSLT facility, when is the use of OPNQRYF desirable?? Please advise.
Hi, I am not very clear as to when should we use OPNQRYF and when should we use Logical file? Since logical file also offers DYNSLT facility, when is the use of OPNQRYF desirable?? Please advise.
