How should i insert Long datatype into oracle long datatype field .
I am getting error. there is no Long datatype in Datastage env
thanks
Insert Long datatype from ORacle db to oracle db
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
[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
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