SEO

#1 (**permalink**) 02-26-2008, 06:20 PM

I am running a statically bound COBOL program on DB2 7.1 OS/390 trying to insert
EBCDIC strings into a varchar column in a table on DB2 UDB 7.2 FP10a Workgroup
edition. The varchar column is defined as FOR BIT DATA which according to the
SQL Reference - "Specifies that the contents of the column are to be treated as bit
(binary) data. During data exchange with other systems, code page conversions
are not performed."
The problem I am having is that the strings are being converted to ASCII
somewhere onlong the way (DB2 Connect maybe?) before being inserted.
Is this correct? How can I stop the conversion happening?
I don't want to define the database as only storing EBCDIC data.

TIA
Ivan

#2 (**permalink**) 02-26-2008, 06:21 PM

I have never done it from OS/390 to the PC, but perhaps you can insert
the data as hex strings?

Ivan wrote:

> I am running a statically bound COBOL program on DB2 7.1 OS/390 trying to insert
> EBCDIC strings into a varchar column in a table on DB2 UDB 7.2 FP10a Workgroup
> edition. The varchar column is defined as FOR BIT DATA which according to the
> SQL Reference - "Specifies that the contents of the column are to be treated as bit
> (binary) data. During data exchange with other systems, code page conversions
> are not performed."
> The problem I am having is that the strings are being converted to ASCII
> somewhere onlong the way (DB2 Connect maybe?) before being inserted.
> Is this correct? How can I stop the conversion happening?
> I don't want to define the database as only storing EBCDIC data.
>
> TIA
> Ivan

--
Anton Versteeg
IBM Certified DB2 Specialist
IBM Netherlands

#3 (**permalink**) 02-26-2008, 06:22 PM

We didn't have this problem, but were using different releases of the
mainframe and Windows DB2 (also, we used Enterprise Edition).

I strongly suggest you open a PMR.

"Ivan" <ivanovich181@hotmail.com> wrote in message
news:6878eab4.0406101910.499f83f3@posting.google.c om...
> I am running a statically bound COBOL program on DB2 7.1 OS/390 trying to
insert
> EBCDIC strings into a varchar column in a table on DB2 UDB 7.2 FP10a
Workgroup
> edition. The varchar column is defined as FOR BIT DATA which according to
the
> SQL Reference - "Specifies that the contents of the column are to be
treated as bit
> (binary) data. During data exchange with other systems, code page
conversions
> are not performed."
> The problem I am having is that the strings are being converted to ASCII
> somewhere onlong the way (DB2 Connect maybe?) before being inserted.
> Is this correct? How can I stop the conversion happening?
> I don't want to define the database as only storing EBCDIC data.
>
> TIA
> Ivan

#4 (**permalink**) 02-26-2008, 06:22 PM

Unfortunately what you are experiencing is a limitation of the DB2 UDB
for Linux, Unix and Windows v7.2 DRDA server support. To avoid the
conversion of the character data on input the data must be tagged as FOR
BIT DATA at the source.

Alternatively you can upgrade to DB2 UDB for Linux, Unix and Windows
version 8.1 were the limitation has been removed.

Ivan wrote:
> I am running a statically bound COBOL program on DB2 7.1 OS/390 trying to insert
> EBCDIC strings into a varchar column in a table on DB2 UDB 7.2 FP10a Workgroup
> edition. The varchar column is defined as FOR BIT DATA which according to the
> SQL Reference - "Specifies that the contents of the column are to be treated as bit
> (binary) data. During data exchange with other systems, code page conversions
> are not performed."
> The problem I am having is that the strings are being converted to ASCII
> somewhere onlong the way (DB2 Connect maybe?) before being inserted.
> Is this correct? How can I stop the conversion happening?
> I don't want to define the database as only storing EBCDIC data.
>
> TIA
> Ivan

#5 (**permalink**) 02-26-2008, 06:27 PM

Mike Springgay <springga@ca.ibm.com> wrote in message news:<40CC8FC5.6090600@ca.ibm.com>...
> Unfortunately what you are experiencing is a limitation of the DB2 UDB
> for Linux, Unix and Windows v7.2 DRDA server support. To avoid the
> conversion of the character data on input the data must be tagged as FOR
> BIT DATA at the source.
>
> Alternatively you can upgrade to DB2 UDB for Linux, Unix and Windows
> version 8.1 were the limitation has been removed.
>
> Ivan wrote:
> > I am running a statically bound COBOL program on DB2 7.1 OS/390 trying to insert
> > EBCDIC strings into a varchar column in a table on DB2 UDB 7.2 FP10a Workgroup
> > edition. The varchar column is defined as FOR BIT DATA which according to the
> > SQL Reference - "Specifies that the contents of the column are to be treated as bit
> > (binary) data. During data exchange with other systems, code page conversions
> > are not performed."
> > The problem I am having is that the strings are being converted to ASCII
> > somewhere onlong the way (DB2 Connect maybe?) before being inserted.
> > Is this correct? How can I stop the conversion happening?
> > I don't want to define the database as only storing EBCDIC data.
> >
> > TIA
> > Ivan

The problem doesn't occur for SELECTs going across platforms in either direction.
I would have thought that if DRDA server can determine that the column is
FOR BIT DATA on a SELECT statement and not do the conversion then it should
also be able to do this for INSERT statements as well.
Am I missing something?

Thanks
Ivan

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Codepage conversion and FOR BIT DATA