Re: How do I track the field number from a SQL script?

[Glenn Gundermann <glenn.gundermann@xxxxxxxxx>]

It would help to see your SQL statement.


Yours truly,

Glenn Gundermann
Email: glenn.gundermann@xxxxxxxxx
Cell: (416) 317-3144


On 6 September 2016 at 21:57, Darryl Freinkel <dhfreinkel@xxxxxxxxx> wrote:

> I am reading 1 table and writing to another.
> I have a bunch of date fields in the record and 1 of them is in error.
> The error message points to field 25.
> Field 25 is not the 25th field starting on the left to the right. The 25th
> field is a char field.
>
> How is the system determining the field number?
>
> -------
>  Message ID . . . . . . :   SQL0180       Severity . . . . . . . :   30
>
>  Message type . . . . . :   Diagnostic
>
>  Date sent  . . . . . . :   09/06/16      Time sent  . . . . . . :
> 21:51:47
>
>
>  Message . . . . :   Syntax of date, time, or timestamp value not valid.
>
>  Cause . . . . . :   The string representation of a date, time, or
> timestamp
>    value does not conform to the syntax for the specified or implied data
> type
>    and format. *N is either the character string constant that is not valid
> or
>    the column or host variable that contained the string. If the name is
> *N,
>    then the value is an expression specified in the statement. If the
> string
>    was found in a host variable, the host variable number is 25.
>
>  Recovery  . . . :   Ensure that the date, time, or timestamp value
> conforms to
>    the syntax for the data type it represents. Try the request again.
>
>
>
> --------
>
> TIA
>
> --
> Darryl Freinkel
> --
> 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.