How can you display the current date & current time ?
SELECT CURRENT DATE, CURRENT TIME FROM SYSIBM.SYSDUMMY1;
Is This Answer Correct ? | 5 Yes | 0 No |
How to create db2 table in mainframe?
Which DB2 catalog tables are used to produce a list of table column by table for all tables in a database?
Suppose I have a program which uses a dynamic SQL and it has been performing well till now. Off late, I find that the performance has deteriorated. What happened?
In a DB2-CICS program which is acts as co-ordinator and which is participant?
How do I import a csv file into db2?
What is the difference between base table and view?
How can you classify the locks in db2?
Is there any advantage to denormalizing DB2 tables?
What is the SQL query to select, delete and get count of duplicate rows in DB2?
When is the skeleton cursor table created?
the dd name for ksds is dest1 and what is the dd name for alternate index of ksds ? a.dest b.dest1 c.dest1a d.dd1
Can a Db2 table data be retrived through JCL?