Interested to Buy Any Domain ? << Click Here >> for more details...
how do u update the faltfile into db2 table ?
- 4 Answers
- 10933 Views
- RBS, TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / ankitha
flat file is loaded to table by LOAD utility. BUT
UPDATE with RRN value ,please any body elaborate
| Is This Answer Correct ? | 3 Yes | 2 No |
Also there is a option in FADB2 to load to table from flat
file using control card.
go to option 3.7
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / sachin borase
Mass insert is possible using the load utility.
but need to write the program for update operation
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / selva ganesh s
Flat file can be updated by using RRN value.
| Is This Answer Correct ? | 1 Yes | 6 No |
Mention the different locking levels that are available in db2.
What do you mean by storage group (stogroup)?
What is CHECK PENDING ?
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.
What is runstats and reorg in db2?
What is query_cache_limit?
How do I import data from excel to db2?
What is buffer pool in the db2 database?
what is the role of the cursor in db2?
What is a clustering index ?
I have some 3 particular fields ..i want to know which all tables have those 3 fields. Is there any way to identify.. can we know by quering system tables..
Cursors can be declared in both working-storage & procedure division, Agreed. But is there any difference? If could you please suggest what is the difference. TIA
COBOL 
