how can you copy records present in a flat physical file to
a database file(physical file).please explain in rpg400 with
a simple example



how can you copy records present in a flat physical file to a database file(physical file).please e..

Answer / guest

Declare a DS with same data types in PGM and move the
record into DS and write the structured file using the DS

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More DB2 Interview Questions

why we go for SPUFI for creating tables or for sql queries?

4 Answers  


What is the maximum length of a column name in DB2? 18 or 30 or anything other than these?

4 Answers  


What's The Percentage Free Space ?

1 Answers   IBM,


Can we use group-by clause in sub-query? If 'yes' means,Will it be executed successfully or else If 'no' means why should we not using that method? Give me your suggestion please....

1 Answers  


What is a bind in db2?

1 Answers  


i want to delete 20th million record how ?

4 Answers   IBM,


What is lock escalation?

2 Answers  


I want to fetch the 10th row of a table which has been changed.How can I do it without going thru all the rows.

5 Answers  


What is the purpose of the DSNC transaction ?

1 Answers  


What is a collection?

3 Answers  


How do u achieve record level locking in DB2 versions when record level locking is not allowed?

2 Answers   IBM,


Is ibm db2 free?

1 Answers  


Categories