Interested to Buy Any Domain ? << Click Here >> for more details...
What are the three DB2 date and time data types and their
associated functions?
- 1 Answers
- 5403 Views
- I also Faced
- E-Mail Answers
Answer / s
Data types are DATE,TIME,TIMESTAMP
A few of the functions are
DATE
HOUR
MONTH
SECOND
TIME
TIMESTAMP
| Is This Answer Correct ? | 1 Yes | 0 No |
How do I delete a table in db2?
What is a collection?
How many clustering indexes can be defined for a table?
Is it possible to update a primary key value? If not, what is the error code given? If yes, can more than 1 primary key column be updated at a time?
What is buffrpool? Where we use it ?
Is db2 free?
Generally if I want to select the names starting with c I need to use c% But how could I code to select the data which contains % as a part of data.
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
what needs to be done if a table is in copy pending / check pending status?
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
pls explain the precompilation process of cobol-db2 pgm
What are the rules for db2 programming?
COBOL 
