How can you display the current date & current time ?
- 7 Answers
- 11073 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / raghu
select currentdate,currenttime from sysibm.sysdummy
the above date and time are scalar functions and it from the timestamp
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...
What are the 2 sqlcodes that are returned?
How to fetch the last row from the table in SQL (db2)?
What is the usage of open cursor command?
What is the physical storage length of timestamp data type?
What is the difference between cursor and select statement?
Is ibm db2 free?
How is a typical db2 batch pgm executed?
Explain packages.
What happens in bind step in a db2 program?
What is bind in db2?
What are the contents of dclgen?
How do you concatenate the firstname and lastname from emp table to give a complete name?
What is role in db2?
Is db2 a database?
