Interested to Buy Any Domain ? << Click Here >> for more details...
db2 restart logic ?
- 1 Answers
- 12156 Views
- DELL, HTC, UHG, I also Faced
- E-Mail Answers
Answer / ankitha
declare temp table with fields pkey and commit frequency.
then set commit frequency ie after 100 records it should
tabulate the temp table and in procerdure division read the
last pk value and should start updating after that pk value
and should delete this temp tble after the final commit or
stop run.
| Is This Answer Correct ? | 13 Yes | 1 No |
Why use RUNSTAT Utility?
How is a typical db2 batch pgm executed?
What is the self-referencing constraint?
how to get duplicate records from tables?write qurey for this?
If a table has a column "dept" (declared to have nulls) and there are 10 rows in the table of which 3 have a null value in the dept column, what will select count(*) and select count(distinct dept) return?
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
If I have 5 Queries in a DB2 Cobol program , while precompiling how many DBRMs will get created and How many Plans and Packages will get created while Bind Process?
What is db2 plan table?
What is DCLGEN ?
i hav created a program and moved to production but failed to create the table which is been used in the program. the program shows error as soon as it is moved or installed in production or shows error during its runtime. what is the sqlcode for this error
When the like statement is used?
What types of tables are there in the db2 database?
COBOL 
