Hi,
I have used the following command in db2.
EXPORT TO C:\FILENAME.TXT OF DEL LOBS TO C:\ MODIFIED BY LOBSINFILE
SELECT * FROM TABLENAME
What db2 does is, it gives us two files, one named DB2EXP.001
containing the entire CLOB data from the table TABLENAME merged into
one file without any delimiter and one called FILENAME.TXT containing
the byte position for each record in DB2EXP.001. The content of
FILENAME.TXT is something like this:
"DB2EXP.001.0.1313/"
"DB2EXP.001.1313.1313/"
In this file, 0.1313 and 1313.1313 specifies the byte position for two
CLOB records in DB2EXP.001 file.
What I want to do is that after the EXPORT command, I want to use this
FILENAME.TXT file and put the records one by one from DB2EXP.001 into
separate files. I know that I can get the byte position from the LLS
file but I am unable to implement it properly.
Does anyone know the solution or any workaround for this? Is it
possible through some DB2 command that the CLOB data doesnt merge
itself?
Any kind of help would be greatly appreciated.
Thanks in advance
