Interested to Buy Any Domain ? << Click Here >> for more details...
is there any restrictions for unions ?
- 4 Answers
- 9235 Views
- Patni, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / i go crazy
Union can be used in a cobol db2 pgm, only restriction is it has to be operated using a CURSOR.
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / mehdee
- There is no restriction for UNIONs in DB2 COBOL coding,
but you can think of logical restrictions, for example if
the DB2 tables are so big that your program will run fast
if just access them individually as needed.
| Is This Answer Correct ? | 0 Yes | 3 No |
What are the full forms of spufi and dclgen and why are they used?
What are the three DB2 date and time data types and their associated functions?
How do you simulate the EXPLAIN of an embedded SQL statement in SPUFI/QMF? Give an example with a host variable in WHERE clause)
how many bytes timestamp token occupies?
6 Answers Boss Global, Cap Gemini, TCS,
For Null indicator we have 3 values 0,-1,-2. 0->Not nulll -1->Null -2->Value truncated If ther is any possibility to have any positive value other than 0 in Null indicator.If it is so then when we will get and what is the value?
What is index cardinality?
How to select the duplicate rows from a table?
If the base table underlying a view is restructured, eg. attributes are added, does the application code accessing the view need to be redone?
What statistic will tell the DBA how must space can be reclaimed from dropped table spaces on the next reorg run?
how to check the table is empty or not?
Where are plans stored?
What is meant by index cardinality?
COBOL 
