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

Explain packages.

0 Answers  


What is the reason behind not using select * in embedded sql programs?

0 Answers  


What is IMAGECOPY ?

6 Answers  


What is clone table?

0 Answers  


What are types of indexes?

0 Answers  


What are the disadvantages of using VARCHAR?

3 Answers  


what is plan? is plan executable or package?

4 Answers  


Is db2 a mainframe database?

0 Answers  


query to just fetch first matching row and stop execution. once one matching row is found ..no more records should be checked.. if the first record is matching.. the query must stop

2 Answers   IBM,


What is db2 instance?

0 Answers  


How does DB2 use multiple table indexes?

1 Answers  


Say CUST Table contains records like: CUSTNO CUSTNAME CUSTLOC 100 ABC SSS 200 XYZ 300 PQR 400 MNO WWW 500 CVV ------------- ------------- Now write a query to retrieve all records with CUSTLOC no data.

3 Answers   IBM,


Categories