Best Regards, Guy Przytula
Database Software Consultant
Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
Information Server Datastage Certified http://www.infocura.be
I felt that responding to dharmendra87(op of this and some other thread) might be useless.
(1) I couldn't see any effort of him(her) to make codes to conform with DB2 syntax.
(2) I couldn't see no effort to look for built-in functions and/or expressions in DB2.
Because, I thought that the fuctionality of TestPmcDate might be realized by TIMESTAMP_FORMAT built-in function.
(3) (S)he might not have programming skills(regardless of programming languages including SQL)
Because, there were some incompleted/cofused codes in the function body of TestPmcDate which might be not seen in codes of skilled programmers.