Unable to trim the data -loading into db2 bulk load stage
Moderators: chulett, rschirm, roy
Unable to trim the data -loading into db2 bulk load stage
Unable to trim the data while loading into target using db2 bulk load stage. The target column is CHAR datatype. But data gets trimmed when i use DB2 API stage. Can some one help me on fixing this issue.
Hi,
please find the sample value when i loaded the data using API stage and Bulk stage.
API Stage:
Column1 (CHAR 15)
--------------------
0717866
Bulk Stage:
Column1 (CHAR 15)
--------------------
0717866--------
Note: i hve given --- to indicate the spaces
The sample given in Bulk stage is loaded with 7 digits where as remaining place values are padded with spaces. But this s not happening for same Char (15) column using API stage. I completly understand that a CHAR column be trimmed. but am not sure how the data loaded using API got trimmed.
Thanks
please find the sample value when i loaded the data using API stage and Bulk stage.
API Stage:
Column1 (CHAR 15)
--------------------
0717866
Bulk Stage:
Column1 (CHAR 15)
--------------------
0717866--------
Note: i hve given --- to indicate the spaces
The sample given in Bulk stage is loaded with 7 digits where as remaining place values are padded with spaces. But this s not happening for same Char (15) column using API stage. I completly understand that a CHAR column be trimmed. but am not sure how the data loaded using API got trimmed.
Thanks
Yes,
when i load the data thr API, and select the value cursor points upto 7 digits for CHAR 15 column and in BULK stage upto 7 digits values are loaded and remaining 8 place values are padded with spaces.
API Stage:
Column1 (CHAR 15)
--------------------
0717866
Bulk Stage:
Column1 (CHAR 15)
--------------------
0717866--------
Note: i hve given --- to indicate the spaces
when i load the data thr API, and select the value cursor points upto 7 digits for CHAR 15 column and in BULK stage upto 7 digits values are loaded and remaining 8 place values are padded with spaces.
API Stage:
Column1 (CHAR 15)
--------------------
0717866
Bulk Stage:
Column1 (CHAR 15)
--------------------
0717866--------
Note: i hve given --- to indicate the spaces