Char to Varchar convert

[snassimr]

Hi !

If any way to convert char to varchar inside DS ?

[DeepakCorning]

You can use CAST from char to varchar.Its not a DS function but a DB (oracle ) function.

[ray.wurlod]

Every Char is VarChar (if needed) within DataStage server edition.

[snassimr]

I need to read char ( in column metadata) as varchar from database
and get warning So its not the same for DS

[ray.wurlod]

It IS the same in DataStage. However the metadata in your DataStage job design are used to communicate with the database server, which is the origin of your metadata mismatch warnings. But you can take that Char column and direct it across a Transformer stage into a VarChar with no derivation expression other than the input column.

[kumar_s]

Hi,
If your soruce is sequential file and target is RDBMS, you can try reading the source it self as varchar.
It shouldnt prompt you a warning.

regards
kumar

[DeepakCorning]

Hey Ray,

One doubt on this one. So if my target is varchar then in DS i just need to map it from char to varchar and the conversion will happen automatically??
I mean to say I have to map a char to varchar then i need not put any function but just map it from char to varchar . right??

[kumar_s]

Hi,
I guess Ray made it clear, it can be converted without any warning but in transformer.

regards
kumar

[ray.wurlod]

As I said, "you can take that Char column and direct it across a Transformer stage into a VarChar with no derivation expression other than the input column". There is no error. There is no CAST required.