Which component is responsible for processing sql statements and selecting access paths?
No Answer is Posted For this Question
Be the First to Post Answer
What is Skeleton cursor table (SKCT)?
How will you delete duplicate records from a table?
Could you please let me no the query for below I have table name xyx under this there is column name called employee name which starts from 100th column ends 120th column,now i want to replace only column from 101 to 104 which contains ABCS to replace with PQRS for all records which comes beetween 101 to 104 ..how to write query for this..
Can we use select query in a loop to fetch multiple rows in a COBOL PROGRAM? If so, what is the advantage of cursor?
If we have 100 records in the PF, we deleted all the records then what is the Size of the PF?
When the like statement is used?
What is DCLGEN ?
What is cobol db2?
Which components manage deadlocks in db2?
What is the syntax required for the creation of a cursor?
How do you simulate the EXPLAIN of an embedded SQL statement in SPUFI/QMF? Give an example with a host variable in WHERE clause)
What is a storage group (stogroup)?