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
Loading a Varbyte field in teradata
Moderators: chulett, rschirm, roy
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
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
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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
If it is a custom script can't you invoke it outside DS to load the DS made file
Roy R.
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org