Hi,
I have a situation- Loading data from file(Fixed width) -->Tfm--> Oracle.
There is a field with 600kb record size.
In oracle it is defined as CLOB. So, using LONGVARCHAR in datastage i'm able to load into Oracle successfully, changing some env variables to handle the size of the data.
Now, When doing the same using "RCP - enabled & Schema file" with Field datatype as "string" in Schema file, the job is finishing fine with now warnings, but the data that is being loaded in this case is a truncated one with length of the record as 10176 instead of the acutal length 600000.
Any suggestions please..
Thanks,
Naresh K
Clob field with Schema file
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 9
- Joined: Fri Feb 18, 2011 1:12 am
- Location: Hyderabad
Clob field with Schema file
Naresh
ETL Developer
ETL Developer
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 9
- Joined: Fri Feb 18, 2011 1:12 am
- Location: Hyderabad
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI