View previous topic :: View next topic
|
Author |
Message |
manjulaa
New User
Joined: 16 Aug 2005 Posts: 4
|
|
|
|
I want to write a query in JCL to get a dump of a table into a file with one condition as GIB47002_HIST_TS > '2009-02-01-01.01.01.000000'
How can I specify this condition in where clause? It should use with UR clause. |
|
Back to top |
|
|
Escapa
Senior Member
Joined: 16 Feb 2007 Posts: 1399 Location: IL, USA
|
|
|
|
So where are you stuck exactly?
Make sure that both side of comparision operation have same datatype..
check for TIMESTAMP scalar function |
|
Back to top |
|
|
GuyC
Senior Member
Joined: 11 Aug 2009 Posts: 1281 Location: Belgium
|
|
|
|
what kind of "dump", formatted for what purpose ? |
|
Back to top |
|
|
|