List some fields from sqlca?
No Answer is Posted For this Question
Be the First to Post Answer
When will you chose to run RUNSTATS?
What is buffer pool?
Can we install 2 different versions of Db2 on same mainframe?
What is a page?
I want to fetch the 10th row of a table which has been changed.How can I do it without going thru all the rows.
What is the physical storage length of each of the following DB2 data types: DATE, TIME, TIMESTAMP?
What is meant by union and union all?
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 DCLGEN?
in a table consist of 1000 records among that i was updated 145 record how could i know that ..list of recently updated record's and where could i see those updated record's....pls help me out....
What is bind package and plan in db2?
If a non-DB2 program calls a DB2 program, the calling program's name will be there in SYSIN of IKJEFT01 and the plan name will be that of the called program. But is a bind needed or a plan has to be created for the non-DB2 program also?