Loading a Varbyte field in teradata

rroy2 · Post by **rroy2** » Mon Oct 12, 2009 3:55 pm

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

chulett · Post by **chulett** » Mon Oct 12, 2009 4:21 pm

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

rroy2 · Post by **rroy2** » Mon Oct 12, 2009 4:36 pm

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

ray.wurlod · Post by **ray.wurlod** » Mon Oct 12, 2009 10:17 pm

Interpose a Transformer stage with appropriate data type conversion function.

roy · Post by **roy** » Tue Oct 13, 2009 6:46 am

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

bobyon · Post by **bobyon** » Thu Oct 15, 2009 10:17 am

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