suppose i i am changing / updating record of subfile and i
want to change the record in reverse order . means i want to
change the bottom record first and so on through readc . how i
do it please any one explain .
Answers were Sorted based on User's Feedback
Answer / maheshg
better to have multi occurance of DS load all the record
which is read through READC and read DS in reverse oreder
for changing / updating.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / baggy
That is possible by using embedded sql to fetch the data
using CURSORS to subfile and group by ASCEND or DESCEND
| Is This Answer Correct ? | 1 Yes | 1 No |
What is I90(Insure 90)?
Assume 2 users are using the same file and first user updates some record in the file. Will the 2nd user will be able to see the updated record or not?
which program rpg or cl is efficent to update a transaction onto a database file and why ?
what do you mean by an input subfile, what are the keywords required?
Q1.How we can copy the data of file one session to another session? Q2.how we can execute a loop infinitely in AS/400 coding? Q3.In ALDON tool,multitask is posible on a perticular object by the user?
1.If *HIVAL SETGT is used what opcode is used to read a record? A:READ B:READPE C:CHAIN D:READP 2.How to pass numeric parameter to the rpg pgm from the command line? 3.What keyword is used on the rpg 4 definition specification to rename a subfile in an externally definition data structure? A:RENAME B;LIKE C:EXTNAME D:EXTFLD
Im traying to get out put of this below mention simple logic code.But im geting out of different.(im trying with my laptop trhough my company server. DCL &FIELD1 *CHAR 10 VALUE('TCS AS/400') DCL &FIELD2 *CHAR 10 CHGVAR(%SST(&FIELD2 1 10))(%SST(&FIELD1 10 1) Can you tell me the value of field2 after excuted of CHGVAR command.
1.find most occurrences of a character. for exm: input:aaabbbbdddddyyy output: d 5 times how can i get that?
What is the significance of UDATE?
Suppose my file has 10 fields and I want to make the 2nd field zeros in all records. And assume I have millions of records and I dont want to read each record and update the desired field with 0. Any other way to do this in one step operation?
RPG/400 faqs?
what are the types of identifers