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 |
On the create tablespace, what does the CLOSE parameter do?
Differentiate between cs and rr isolation levels? Where do you specify them?
What is drop table?
What is db2 stogroup?
how can u understand the end of the table ?
How can you quickly find out the number of rows updated after an update statement?
i have an employment table whch has salary,dept,name? i want salary b/w 1000 to 5000 can anyone pls say the query for ths ?
8 Answers Cap Gemini, CGI, EDS, IBM, Satyam, Wipro,
SI Stud name Subject Marks Pass/Fail 1 Sham Maths 40 P 1 Sham Physics 50 P 1 Sham Bio 20 F 2 Ram Maths 40 P 2 Ram Physics 50 P 2 Ram Bio 60 P For the above data , write the SQL query for the student who passed in all the subjects . For eg : I want the data of only Ram coz he passed all subjects .
How to design maps
What is meant by union and union all?
Define db2 and its databases?
How to update more then one record using update?