DSXchange

Hi All,

I am using Sybase as my source database tables and datasets are my target files.

In one of my sybase table column like'DTTM' and the value for this column like:

'Dec 31 3999 12:00AM'
'Jan 23 2015 09:00 AM'
'Feb 28 2010 10:00 AM'
'Dec 31 3999 12:00AM'

But i need to extract records where DTTTM = 'Dec 31 3999 12:00AM'

How can i mention in user defined sql in sybase source stage?

is it exactly like:

where DTTTM = 'Dec 31 3999 12:00AM'

or do i need to conver to some thing?

could any one on help me?

How would you do it usng Sybase Open Client - that is if DataStage were not in the picture?

Thanks for the reply Ray,


I tried to run the qry like below using my SQLAdvantage tool in my sybase database:

where DTTTM = 'Dec 31 3999 12:00AM'

but i am wondering will this work on datastage?

any suggestions--

Did it work? There's nothing magic or different about DataStage, a query is still a query. If you can make it work there, it will work here.