RE: Boolean data type

Nope.

Best you can do on a CREATE TABLE is CHAR(1) FOR BIT DATA. Sometimes a
SHORT INT is used also.

How are you building the result set?  RPG or SQL?

I've never had to deal with this in C#/.NET but I've dealt with it using
JDBC.

You might have to dig into the documentation and play around with it
some to figure out what is acceptable.


HTH,

Charles Wilt
--
iSeries Systems Administrator / Developer
Mitsubishi Electric Automotive America
ph: 513-573-4343
fax: 513-398-1121
  

> -----Original Message-----
> From: midrange-l-bounces+cwilt=meaa.mea.com@xxxxxxxxxxxx 
> [mailto:midrange-l-bounces+cwilt=meaa.mea.com@xxxxxxxxxxxx] 
> On Behalf Of Smith, Dave
> Sent: Friday, May 19, 2006 9:41 AM
> To: midrange-l@xxxxxxxxxxxx
> Subject: Boolean data type
> 
> Is there a Boolean data type on our iSeries?  V5R3
> 
> If not, how do I handle a C# program that needs a Boolean return parm?
> Help please.
> 
> David Smith
> IT Consultant
> 
> 
> -- 
> 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.
> 
>