FOR BIT DATA and GENERATE UNIQUE

Hirschel Wasserman

FOR BIT DATA and GENERATE UNIQUE
How essential is it to specify FOR BIT DATA for columns to be populated
with GENERATE UNIQUE?
(We are new to Version 8 and unicode.)

Without the FOR BIT DATA, it defaults to SBCS.
Is there a performance implication?

Thanks in advance..


Hirschel Wasserman

----
The GENERATE_UNIQUE function returns a bit data character string 13
bytes long (CHAR(13) FOR BIT DATA)
----
FOR subtype DATA
Specifies a subtype for a character string column, which is a column
with a data type of CHAR, VARCHAR, or CLOB.

SBCS Column holds single-byte data.
BIT Column holds BIT data.


---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Suresh Sane

Re: FOR BIT DATA and GENERATE UNIQUE
(in response to Hirschel Wasserman)
Hirschel,

This is not a performance issue but one of data consistency.

If you plan to access this data from the mainframe only (for ever and
ever...), leaving out the FOR BIT DATA is OK.

If not, you will get undesirable translation. This is just like any
encrypted data such as passwords which you do NOT want translated.

So... play it safe and add the BIT DATA.

My $0.02

Thx
Suresh


>From: "Wasserman, Hirschel" <[login to unmask email]>
>Reply-To: DB2 Database Discussion list at IDUG <[login to unmask email]>
>To: [login to unmask email]
>Subject: [DB2-L] FOR BIT DATA and GENERATE UNIQUE
>Date: Fri, 19 Jan 2007 13:57:21 -0800
>
>How essential is it to specify FOR BIT DATA for columns to be populated
>with GENERATE UNIQUE?
>(We are new to Version 8 and unicode.)
>
>Without the FOR BIT DATA, it defaults to SBCS.
>Is there a performance implication?
>
>Thanks in advance..
>
>
>Hirschel Wasserman
>
>----
>The GENERATE_UNIQUE function returns a bit data character string 13
>bytes long (CHAR(13) FOR BIT DATA)
>----
>FOR subtype DATA
>Specifies a subtype for a character string column, which is a column
>with a data type of CHAR, VARCHAR, or CLOB.
>
> SBCS Column holds single-byte data.
> BIT Column holds BIT data.
>
>
>---------------------------------------------------------------------------------
>Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home
>page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select
>"Join or Leave the list". The IDUG DB2-L FAQ is at
>http://www.idugdb2-l.org. The IDUG List Admins can be reached at
>[login to unmask email] Find out the latest on IDUG conferences at
>http://conferences.idug.org/index.cfm

_________________________________________________________________
The MSN Entertainment Guide to Golden Globes is here. Get all the scoop.
http://tv.msn.com/tv/globes2007/?icid=nctagline2

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm