can i code union in cobol-db2 pgm ?
Answers were Sorted based on User's Feedback
Answer / lu
Sure you can...union is like to check the existence row in
many differents tables...
| Is This Answer Correct ? | 9 Yes | 0 No |
Answer / krishna
Deafnetly you can use,
if union is coded in cobol-db2 program cursor declaration
is mandatory
| Is This Answer Correct ? | 10 Yes | 2 No |
how to delete perticular row from table for ex. how you will delete 3rd row from table please answer THANKS IN ADVANCE
When one binds a PACKAGE ( of a plan ) what package information is stored and where it is stored?
DB2 is a A) data base/data communication system B) data base C) RDBMS D) Programming language
I have a DB2 table which has 1000 rows.after udatingg first 110 rows, my job abends. Now what I have to do if I want to restart the job next time so that it should start updating from 111th row (without updating first 110 rows again).
What is DCLGEN ?
Is it mandatory to use DCLGEN? If not, why would you use it at all?
What is a clustering index ?
Which command is used to connect to a database in DB2 ? Give the Syntax.
EXPLAIN has output with MATCHCOLS = 0. What does it mean?
How can you count the number of rows from a table tab?
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?