Unable to extract XML column from database
Posted: Thu Sep 14, 2006 9:47 pm
Hi all
I need to do a job which extract a col(which is and XML column of length > 72000) from a table and place it in a sequential file.
There are more than 35000 records in that table.
The job structure is:
ODBC stage -> Transformer stage -> Seq File stage
The issue is the job gets aborted after getting 4000 records.
giving a single warning:
Abnormal termination of stage Sample_Job..Transformer_Sample detected
i.e. the transformer stage.
So i tried using rowcount as 4000 in the query at input ODBC stage, yes...then all the 4000 are extracted.
i have checked the 4001st record its all fine.
I guess the issue with the size.
Plz suggest any possible solution..
Thanks
Divya
I need to do a job which extract a col(which is and XML column of length > 72000) from a table and place it in a sequential file.
There are more than 35000 records in that table.
The job structure is:
ODBC stage -> Transformer stage -> Seq File stage
The issue is the job gets aborted after getting 4000 records.
giving a single warning:
Abnormal termination of stage Sample_Job..Transformer_Sample detected
i.e. the transformer stage.
So i tried using rowcount as 4000 in the query at input ODBC stage, yes...then all the 4000 are extracted.
i have checked the 4001st record its all fine.
I guess the issue with the size.
Plz suggest any possible solution..
Thanks
Divya