DSXchange

Try Oconv and have the target field as varchar or timestamp. SQL Server stores date as timestamps. You get this error either because you selected Date as the column type in your stage or the date is in DS internal format.

Following mdan's suggestion you could replace '' with ' ' or some default value using CASE expression in the column derivation. Apparently your DB is not oracle (blank is ' ' and not '' in oracle) and you can't use NVL. I have a job where the first value in hash file is ' ' and I had tried using @NU...

[quote="chulett"]However, when all is said and done the job gets the plain vanilla un-fancy-format sql.[/quote]
Will follow your advice.

Thanks everybody

I had typed in a quite big where clause in the stage and I had it formated so it was easy for me to read it. Just as I was trying things out I removed all the extra white spaces I had in there. The stage works fine now. I don't think this would help to understand what went wrong. My idea was that wh...

I could switch back to column generated and replicate the same error again in the stage. When I tried reindexing, exclusive locks were acquired for each object and they seem to be reindexed. But when I go back to stage the error persists.

Thanks again

When I tried to view data in a Oracle9i stage got the following error - 'Error calling subroutine: DSD.Browse (Action=3); check DataStage is set up correctly in project STPHCMSIM'. I tried reindexing the project from the Administrator. But that didn't help. The stage uses a column generated SQL and ...