How to see all record formats used in a file?



How to see all record formats used in a file?..

Answer / sunit ranjan

You can use DSPDBR - Display database relation

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More IBM AS400 AllOther Interview Questions

how can I automatically refresh a web page?

0 Answers   IBM,


define the purpose of the iter operation?

1 Answers   IBM,


Can we use OVRDBF command without using of OPNQRYF ? Or can we use OPNQRYF command without using of OVRDBF command ?

4 Answers   HCL, iGate,


Is it possible to add an keyfield or field to an Physical file without changing its file identifier. Example : - Say I have an existing physical file which is being used in 5 programs. Now I want to add an additional Keyfield or an field to it and I don't want to recompile the programs.

2 Answers  


what is a spool file?

0 Answers   IBM,


Is qgpl a user library or system library?

1 Answers  


What is the purpose of "A CSRLOC (F1ROW F1COL)"?

1 Answers  


How do you use DEBUG utility?

1 Answers  


Q.Hi All friends, I have one Question, I have three fields in display file SUP LOT, ISSUED to Prod and Line Grp. Field SUP LOT is mentioned in one field reference file WRSLT and key field as a key field LP.Fields ISSUED to PROD,Line GRP are mentioned in the another Field reference file WMDTF. So I want to read SUP LOT on the basis of key field LP from the first file WFSLTand then i want ot read another two fields ISSUED to DATE and LINE GRP from second file on the basis of SUP LOT, which i got from first file.Now i want to display these fields in the display file DSPWMMS. but Condition is that 'Supplier Lot,ISSUED to Prod and Line Grp will not be shown if their respective fields are blanks/Zero. Please Let me Know coding part of this senerio and what would be coding for display file to now shown fields if fields are blanks/zero. My mob. no. is 9836300345. Please reply me asap.

1 Answers   IBM,


what is a query can be run in which mode?

0 Answers   IBM,


when would you prefer logical file than opnqryf?

1 Answers   IBM,


load all subfile logic in sqlrpgle and when updating particular record it must be lock form other jobs (not a file)?

1 Answers   Wipro,


Categories