3 members in a databasefile .how to read records from all
the members?????????
Answers were Sorted based on User's Feedback
Answer / samul
OVRDBF FILE(TEST)
TOFILE(*LIBL/TEST)
MBR(*ALL)
before calling pgm,execute above cmd.
cheers...
| Is This Answer Correct ? | 9 Yes | 3 No |
Answer / reena
there are 2 ways.
1. using OVRDBF
2. By creating and LF.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / ravi kumar
1. Through RPG, using EXTMBR(*All)
2. Through CL, OVRDBF FILE(TEST) TOFILE(*LIBL/TEST)MBR(*ALL)
| Is This Answer Correct ? | 2 Yes | 0 No |
Thanks gagan for your answer,i'm new to as400,i don't know embedded sql in rpg.can you send me the coding for the below mentioned question in embedded sql rpg. how to retrieve particular field records from a physical file,say i have a physical file called 'employee' in it i have to retrieve the records of a field 'admin' present in pf 'employee' using rpg,but i should not use logical file or openquery file.
Can we journel logical file and access path? Can we use commitment control for non-join L.F?
what is flat file?
How do you call procedures in ILE?
Whether a module can consists of many procedures or it can consist of subprocedures having a main procedure?If it is possible that it can contain many individual procedures than can we have different name for complete module and how do we call this module in main modul?
What will happen if we r using seton lr after return or vice versa.
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.
in a cl pgm records are copied to a file in qtemp a pgm is called to delete records from the file in qtemp no of records in file in library qtemp is checked wat shud be the count of records let say it was 10 initially endpgm
1. If my rpg program has a date field, What extra care I have to take while compiling that RPG program? 2. If the file is keyed and I have declared the file as well as Key list properly in my program. Still am getting an error message like "Chain/reade operation is not allowed" What may be the case?
how do u track msg in cl pgm???
1.Can any body share me about thease opcodes with example please.Im new for AS/400.Could u please tell me in real senario? 1.TESTN, 2.EVAL 3.EVALR, TIME, 4.MONITOR 5. ENDMON 6.ON-ERROR 7.COMMIT ROLLBACK?
1.Coding in cl to send an message? 2..What is turnover and use? What are the different levels?