DSXchange

Hi all, I wrote a user-defined sql query in a oledb stage: select 'N' as fund_fl, max(dim_dt_id) as dim_dt_id from dim_dt where dt_1 is not null union select 'Y', max(dim_dt_id) from dim_dt where dt_2 is not null I got the error msg: OLE DB provider error: Column does not exist. How to handle the ge...

Hi all,

I want to delete two hashed files in the job's after-job routine. Can I just type in the TCL command in the input value text box or I have to create a server routine and call the routine from the job's after-job routine?

Thank you in advance.

Kathy

Hi,
We got this problem solved. We contacted the Ascential support group and upgraded the MDAC from version 2.53 to version 2.60.

KWang

Thanks Manoj, But I am not using the cast function anywhere. Actually the data type for the field in the source text file is also varchar(120). I'm just doing a direct load. The source text file contains exact data (and data type) from the target SQL DB (loaded from the SQL DB in another job). Also,...

I'm very new to datastage so I hope somebody could help me solve this wierd problem. I want to transform a string (length is 31characters) from a text file (sequential file stage) to a SQL database (OLEDB stage), the datatype of the target field in the target table is varchar(120). I got the followi...