hi... it worked out. thanks so much for all the patience & help. am really very SORRY for having wasted ur time witht that generic info. it was a SQL server in windows. this is good learning for mechulett wrote:Hmm... UNIX server, DS 7.5.1A - question marks. And it specifically complained about the colons. Still, the actual errors were not posted - they were paraphrased instead - so who knows.
I'll step away and let you guys 'work it out'.
- technical information that i learnt
- i learnt to give enough info wen posting a specific subject
wen u said abt the '?' i verified in the director and there i saw the '?'. it had even removed the to_date fn (thats not avail with sql server). could u plz let me know more on this. (all i could understand was that DS has a generic sql generated in the job design & translates it at run-time)
again thanks all for the lightning-speed responses