What are the three DB2 date and time data types and their
associated functions?
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 |
When you are working with the project after coding what will u do? Like what type of documents u will prepare? How will u do testing?
What will the DB2 optimizer do?
What is catalog database in db2?
What is the syntax required for the creation of a cursor?
What is a dbrm in db2?
Can we insert update delete in view?
in GDG: is it poosible to copy records from a file which utilizes some 100 cylinders to a gdg whose model is defined as trk(1,0) and also it possible to copy 100 bytes file to 80 bytes file?
In cursor program-1 can we create another cursor program-2 inside the cursor program-1.If yes how/no why ?
What do you mean by NOT NULL WITH DEFAULT? When will you use it?
How do you declare a host variable (in COBOL) for an attribute named emp-name of type VARCHAR(25) ?
What is the picture clause of the null indicator variable?
what is SPUFI ?