Re: SQL fetch

[rbbaird@xxxxxxxxxxx (Rick Baird)]

Tim_Lennon/Thomas_Miller_at_MUTUAL@mutual.co.uk wrote:

> >The date is correct in the file, but the dump says that the sql_000xx
>
> >field that sql is trying to move into the field is in mm/dd/yy
> format.
>
> You may need to check the H spec. in your RPG - look at the definition
>
> of the field that you are fetching **into**, and the definition which
> it is given in the dump. I could be wrong, but that would be my, ahem,
>
> knee-jerk reaction.
>

The field is an "L" type field (defined in the phys file).

no H spec specified, and a quick glance at the manuals on datfmt on the
h spec seems to indicate that it only defines the edit format and
separator charactor for rpg output (I could be wrong on this - I quit
reading because I didn't think I was on the right track.

I did find an sql statement SET DATFMT in the sql manual.  I think this
might help me.  I'll let you know, I'm working on something else now.

thanks for the response.

rick

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* This is the Midrange System Mailing List!  To submit a new message,   *
* send your mail to "MIDRANGE-L@midrange.com".  To unsubscribe from     *
* this list send email to MAJORDOMO@midrange.com and specify            *
* 'unsubscribe MIDRANGE-L' in the body of your message.  Questions      *
* should be directed to the list owner / operator: david@midrange.com   *
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *