Insert Long datatype from ORacle db to oracle db

parsi_cnu · Post by **parsi_cnu** » Wed Mar 07, 2007 3:26 pm

How should i insert Long datatype into oracle long datatype field .

I am getting error. there is no Long datatype in Datastage env

thanks

ray.wurlod · Post by **ray.wurlod** » Wed Mar 07, 2007 3:49 pm

Why involve DataStage if it's Oracle to Oracle? It would be faster to do it within Oracle.

parsi_cnu · Post by **parsi_cnu** » Wed Mar 07, 2007 7:24 pm

[quote="ray.wurlod"]Why involve DataStage if it's Oracle to Oracle? It would be faster to do it within Oracle.[/quote]

I am developing a datastage job where i had source table
1 column is defined as Long and i had to populate that column in another oracle database env. This job should run everyday. I wanted to know what is the max can i get the string from oracle database using datastage.

Source is transactional db and populating in Datamart.

Thanks
sri

chulett · Post by **chulett** » Wed Mar 07, 2007 8:07 pm

What datatype did you choose? What error did you get? You're going to have problems handling it but *may* be able to get it to work.