What is correlated subquery?
Answer / s
Correlated subquery refers to atleast one column of the
outer query. The correlated subquery is evaluated for each
qualifying row from the outer query.
| Is This Answer Correct ? | 1 Yes | 0 No |
What is dynamic SQL?
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 declare cursor?
How connect db2 database to datastage?
Do we have any optinon to search part of integer in DB2 as we have for character Like,SUBSTR optins?
max number of columns in a db2 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..
How will you return the number of records in table?
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
can you use symbolic parameters in JOB?
How do I start db2 in windows?
Why db2 is called db2?