Re: SQLCLI data types and internal (System i) formats

Dennis,

Have you looked at the appendices B and C of the SQL CLI Programming Guide
(manual)? I am not quite sure which, could be appendix D : ), do this by
heart.

In one of those appendices is a chart of all data tpes and the SQL number
to use. There are two values for each data type, one with null support and
one without, IIRC.

To calculate decimal and zoned (numeric) length to pass it is (actual
length * 256) + decimal positions.

With regards,
Carel Teijgeler

*********** REPLY SEPARATOR ***********

On 2-3-2011 at 12:20 Dennis Lovelady wrote:

I have been scanning the web looking for a made-for-humans chart that will

describe the various SQL CLI values and how they relate to our

beloved i. There are a few references that make a feeble attempt at

correlating [some of] these values against C object types, but these

fall way short, especially when it comes to Packed vs. Zoned, et cetera.
(This is made more confusing that the terms PACKED and ZONED don't even

apparently make it to the SQL CLI vocabulary, and are apparently

replaced by the ambiguous SQL_NUMERIC and SQL_DECIMAL (?) terms. But I

digress.)

Some of the ambiguities are: SQL_BIGINT, SQL_BINARY, SQL_INT,

SQL_NUMERIC, SQL_SMALLINT. Then there's SQL_FLOAT, SQL_REAL and

SQL_DECFLOAT. That's just for starters. Obviously, some of these are

synonyms for others, but that knowledge by itself isn't much help.

Where may I find a chart or other reference that will help me decipher the

SQL data types, in hopes that a clever routine may make use of this

information for conversion purposes?