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
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 |
Explain packages.
What is the reason behind not using select * in embedded sql programs?
What is IMAGECOPY ?
What is clone table?
What are types of indexes?
What are the disadvantages of using VARCHAR?
what is plan? is plan executable or package?
Is db2 a mainframe database?
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
What is db2 instance?
How does DB2 use multiple table indexes?
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.