what is the equivalent keyword for CHAIN opcode ??
Answers were Sorted based on User's Feedback
do you use message subfiles? What are the necessary keywords required coding a message subfile?
How do you do indexing in a physical file?
1.How to read a subfile in out put mode? 2.what are the keywords used to share same file? 3.using composite key which rpg code used?
i want to perform uniqness on db file bt my db file nt hving key by useing rpgle.
How to declare the more than one file in cl/400.
How to sort an array in descending in RPG
1.How to load Records of a Physical file(PF) in the reverse order, in CL program?
Q1.How to read the Array? Q2.How to copy the content of one Array to another Array?
can anybody help me to solve this problem. the program that i m checking display error message saying "Record format for file AJDSPFFD does not match model file and decimal error. how to solve this problem. The AJDSPFFD is snapshot the AJTLOG that is the audit trail list.
Need a sql query: retrive all duplicate records in table
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.
Hi,Please give me complete code with this logic. The question is how to read the records from a file with load an array of size with error condition? (The logic is Z-Add 0 IDX *LOVAL SETLL FILE READ FILE 99 *IN9 DOWEQ *OFF IDX ANDLT 99 ADD 1 IDX MOVE FIELD ARR,IDX READ FILE 99 ENDDO)please give me complete code with explanation?