Hi,
Can some one tell me the maximum length of characters that oracle connector stage can read and process in datastage.
I have 5 column maximum 12000 char each long(Clob datatype in oracle). i want to concatenate these columns and then split the note into 4000 characters each and create new records for each 4000 chars.
Is it possible ? what datatype do i need to select ,is there any propety setting in the oracle connector to read this long data?
Thanks!!
DD
CLOB-> LONGNVARCHAR
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 31
- Joined: Mon Jun 28, 2010 5:15 am
- Location: pune
What happened when you tried? What datatype did you get for those fields when you imported the metadata? For your first question, I would ask that of your official support provider. I'd also be curious what exact 8.x version you have.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 31
- Joined: Mon Jun 28, 2010 5:15 am
- Location: pune
I am not sure of the official service provider.
When i imported the metadata it gave longnvarchar (2147483647).
We are using version8.1.
I am able to 'view data' in the oracle connector. But when i try to insert data by doing 1;1 mapping in transformer for each field it is throwing the below error
'Oracle_Connector_6,1: Operator terminated abnormally: received signal SIGSEGV'
When i imported the metadata it gave longnvarchar (2147483647).
We are using version8.1.
I am able to 'view data' in the oracle connector. But when i try to insert data by doing 1;1 mapping in transformer for each field it is throwing the below error
'Oracle_Connector_6,1: Operator terminated abnormally: received signal SIGSEGV'
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: