AW: Indicator

Character Fields with CCSID 65535 (= FOR BIT DATA) may cause problems when converting between different data types (Character --> Unicode) or CCSID.
Since there are only 2 different values, I'd always use a Character Field Definition with a CCSID. I'd also prefer using 0 / 1 over N / Y (Which works for English, but may cause some confusion when working in multi-lingual environments.
In German for example YES = JA, in French YES = Oui, in Italian YES = Si ...

Mit freundlichen Grüßen / Best regards

Birgitta Hauser

"Shoot for the moon, even if you miss, you'll land among the stars." (Les Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them and keeping them!"

-----Ursprüngliche Nachricht-----
Von: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] Im Auftrag von Charles Wilt
Gesendet: Wednesday, 03.2 2016 22:19
An: Midrange Systems Technical Discussion
Betreff: Re: Indicator

True enough...

But that's what IBM recommended in the MS SQL Server porting guide.

Honestly, it might be a bit more trouble than it's worth as it has the effect of returning x'F1' in Run SQL Scripts and some other interfaces.

Charles

On Wed, Feb 3, 2016 at 3:42 PM, Mark Murphy/STAR BASE Consulting Inc. < mmurphy@xxxxxxxxxxxxxxx> wrote:

I don't use the FOR BIT DATA clause when I define indicators. It seems
that is really for binary data stored in a character field that you
don't ever want to be converted. Bit flags maybe, or encrypted data. I
guess the argument could be made for using FOR BIT DATA, but since '0'
and '1' are invariant characters, there isn't really any reason to
treat it differently from a normal CHAR(1).

Mark Murphy
STAR BASE Consulting, Inc.
mmurphy@xxxxxxxxxxxxxxx


-----Charles Wilt <charles.wilt@xxxxxxxxx> wrote: -----
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
From: Charles Wilt <charles.wilt@xxxxxxxxx>
Date: 02/03/2016 02:56PM
Subject: Re: Indicator


The closest fit

CREATE TABLE TEST1(
MYIND CHAR (1 ) FOR BIT DATA NOT NULL WITH
DEFAULT '0' CONSTRAINT MYIND_CHK CHECK (myind in ('0','1'))
)

Charles

On Wed, Feb 3, 2016 at 2:41 PM, Raul A Jager W <raul@xxxxxxxxxx> wrote:

Can I define a field of type N (Indicator in RPG) using DDL?

I did not find it in the SQL reference, is not possible, or I did
not look well?

TIA
Raúl

-- Este e-mail fue enviado desde el Mail Server del diario ABC Color --
-- Verificado por Anti-Virus Corporativo Symantec --
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L)
mailing

list

To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please
take a moment to review the archives at
http://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take
a moment to review the archives at
http://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take
a moment to review the archives at
http://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related questions.