Inserting a field of possible lenght 60K into DB2 CLOB
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 26
- Joined: Wed Mar 17, 2010 11:05 am
Inserting a field of possible lenght 60K into DB2 CLOB
Hi, I have a requirement to load a huge text field (60K) in a text file into a DB2 CLOB field. I specified the fields in ODBC stage as LongVarChar. The job fails if i specify the LongVarChar lenght to be 60000. It accepts only 30000 as length. How can i handle 60K CLOB load.
ReachSam
-
- Participant
- Posts: 21
- Joined: Mon Mar 01, 2010 4:55 pm
-
- Participant
- Posts: 26
- Joined: Wed Mar 17, 2010 11:05 am
The job failed when i randomly specified as 60000 for lenght in LongVarChar.
Error 'APT_CombinedOperatorController,0: Fatal Error: Not bounded length.'
node_node1: ?? (13; SOL_SOCKET, SO_ERROR; 57; Socket operation on non-socket)
?? (15; SOL_SOCKET, SO_ERROR; 57; Socket operation on non-socket)
Error 'APT_CombinedOperatorController,0: Fatal Error: Not bounded length.'
node_node1: ?? (13; SOL_SOCKET, SO_ERROR; 57; Socket operation on non-socket)
?? (15; SOL_SOCKET, SO_ERROR; 57; Socket operation on non-socket)
roydanlobo wrote:You can specify the Longvarchar length '7463847'
ReachSam
-
- Premium Member
- Posts: 457
- Joined: Tue Sep 25, 2007 4:05 pm
-
- Participant
- Posts: 26
- Joined: Wed Mar 17, 2010 11:05 am
How do i define LongVarChar field as unbounded. If i do not specify any length in ODBC stage to load into DB2 CLOB, the fatal error is "APT_CombinedOperatorController,0: Fatal Error: Not bounded length."
If i specify the length as 60000 or so, the job finished successfully, but only about 8K of data is loaded into CLOB field.
If i specify the length as 60000 or so, the job finished successfully, but only about 8K of data is loaded into CLOB field.
ReachSam
-
- Participant
- Posts: 26
- Joined: Wed Mar 17, 2010 11:05 am