Hi,

I have Db2 ver 9.5 for LUW , running on two different system, one is
linux and other on windows and have the table with same defination on
both the system.

i exported blob column of the in one of the table in both the system
in delimited format,

but the exported file from both the system are not identical, i wonder
is it a problem with Db2 or the way the OS process the file.

Command : DB2 EXPORT TO D:\Load OF DEL MODIFIED BY NOCHARDEL MESSAGES
D:\Load\output.log SELECT .BLOB_COLUMN FROM LOAD_TABLE


thanks you much,
Situ

situ wrote:

Hi,
>
I have Db2 ver 9.5 for LUW , running on two different system, one is
linux and other on windows and have the table with same defination on
both the system.
>
i exported blob column of the in one of the table in both the system
in delimited format,
>
but the exported file from both the system are not identical, i wonder
is it a problem with Db2 or the way the OS process the file.

How are they not identical?

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

On Aug 13, 4:52*pm, Serge Rielau <srie...@ca.ibm.comwrote:

situ wrote:

>

>

>

>
How are they not identical?
>
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

Hi Serger thks for th reply..


i checked there bit representations and its entairly diffrent..

regards,
Situ

On Aug 13, 4:52*pm, Serge Rielau <srie...@ca.ibm.comwrote:

situ wrote:

>

>

>

>
How are they not identical?
>
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

Thks for the replay..

i compared there bit represenation and i'm getting some diffrences.


Regards,
Situ

situ wrote:

Hi,
>
I have Db2 ver 9.5 for LUW , running on two different system, one is
linux and other on windows and have the table with same defination on
both the system.
>
i exported blob column of the in one of the table in both the system
in delimited format,
>
but the exported file from both the system are not identical, i wonder
is it a problem with Db2 or the way the OS process the file.
>
Command : DB2 EXPORT TO D:\Load OF DEL MODIFIED BY NOCHARDEL MESSAGES
D:\Load\output.log SELECT .BLOB_COLUMN FROM LOAD_TABLE
>

When you export LOBs, if you don't specify the "lobsinfile" modifier,
you only get the first 32kb of data -- not necessarily the entire LOB.
Each record will be separated by a normal end-of-line character --
on UNIX this is LF; on Windows it CRLF. This is why the files are
different.

So, if you're going to export LOBs, make sure you use the "lobsinfile"
modifier, as in:

export to d:\load of del
modified by lobsinfile
select blob_column from load_table

You'll get 2 files -- d:\load (a text file with lob locators), and
d:\load.001.lob (a binary file containing the LOBs). The file
containing the LOBs should be identical.

You do have control over where the lob files are written, using the
LOBS TO and LOBFILE directives in export.


Good luck,

On Aug 14, 5:50 am, Ian <ianb...@mobileaudio.comwrote:

situ wrote:

>

>

>

>

>
When you export LOBs, if you don't specify the "lobsinfile" modifier,
you only get the first 32kb of data -- not necessarily the entire LOB.
Each record will be separated by a normal end-of-line character --
on UNIX this is LF; on Windows it CRLF. This is why the files are
different.
>
So, if you're going to export LOBs, make sure you use the "lobsinfile"
modifier, as in:
>
export to d:\load of del
modified by lobsinfile
select blob_column from load_table
>
You'll get 2 files -- d:\load (a text file with lob locators), and
d:\load.001.lob (a binary file containing the LOBs). The file
containing the LOBs should be identical.
>
You do have control over where the lob files are written, using the
LOBS TO and LOBFILE directives in export.
>
Good luck,

Thks Ian,

Regards,
Situ