Re: Microfocus & Oracle data types

From: Michael Russell (michael.russell_at_spamex.dsl.pipex.com)
Date: 08/12/04 

Date: Thu, 12 Aug 2004 16:56:09 +0100

Nicely presented information -- thank you, Simon.

Regards

Michael

"Simon Tobias" <Simon.Tobias@nospam.microfocus.com> wrote in message
news:cfcnr7$nko$1@hyperion.microfocus.com...
> Hi Michael,
>
> that's great that you figured this out.
>
> Without indicator variables, I would expect that you may get a SQLCODE of
> +1, with SQLWARN set appropriately, if NULLs were returned but no
indicator
> set. Under the Net Express refererence manual, under Database Access ->
> OpenESQL -> Data Structures -> SQLCA, we state the following. Note that
> SQLWARN2 will only be set if you return a NULL value from the FETCH :
>
> SQLWARN
> Eight warning flags, each containing a blank or "W" (those not listed
below
> are reserved): A warning flag will be set if SQLCODE contains a value of
+1:
>
> SQLWARN0 A summary of all warning fields. Blank means there are no
warnings.
>
> SQLWARN1 "W" indicates that data was truncated on output to a character
host
> variable.
>
> SQLWARN2 "W" indicates that a null value exists, but no indicator variable
> was provided.
>
> SQLWARN3 "W" indicates that the number of columns is less than the number
of
> host
> variables or that the number of host variables provided does not match the
> number of parameter markers in the statement. The lower of the two numbers
> has been used.
>
> SQLWARN4 "W" indicates a singleton select that returns more than one row
> (only the first row is returned).
>
>
> Regards,
> SimonT.
>
>

Relevant Pages