DSXchange

Hi,

I am using DS 7.5.1a version.

I have a teradata table defined with all fields as VARBYTE(32) as the info to be contained needs to be encrypted.

How can I convert varchar and date datatypes from my XML file to Varbyte(32).

I dont see conversion function for this in datastage. Please help.

Thanks

Is there a 'conversion function' for that in Teradata?

I am using custom script in MLoad stage to load the table and also I have to define the fileds in MLoad as Varbinary.

But the moment I define the fields in MLoad stage as varbinary, it changes the datatype in the previous stage also, and that is remove duplicate stage.

And the job fails as its not able to convert String/date to raw. Thus I was looking to change the datatype before I laod the table

Thanks

Interpose a Transformer stage with appropriate data type conversion function.

I was wondering if the encryption is done in the mload utility, then the source column should still be of char nature, should it not
If it is a custom script can't you invoke it outside DS to load the DS made file

not sure about 7.5 but, because I am looking to do just the opposite in 8.0.1, I just saw a stringtoraw function you could use