There's no such thing as a DATE field to Image.  You need eight decimal
digits to really do dates right, storing via ccyymmdd format.  If you have
the space, Z8 (pic 9(8)) works nicely - you can then select a particular
month or year quite nicely without any data conversion.   If space is at a
premium, I2 (pic s9(9) comp) will work, but your software will pay a data
conversion price.

Tracy Pierce
> -----Original Message-----
> From: Kevin J. Mullins [mailto:[log in to unmask]]
> Sent: Thursday, February 24, 2000 8:12 AM
> To: [log in to unmask]
> Subject: Moving Dates - Image/SQL
>
>
> We could use a bit of help here...
>
> What should the Cobol storage format of a date field be in
> Image/SQL so that
> we can TYPE the field as a date field in Image/SQL? What
> should be the Image
> definition of the field in the schema as well?
>
> TIA for your assistance.
>
> **************************************************************
> **********
> Kevin J. Mullins          Phone:  281-376-8953
> MIS Manager             Fax:      281-469-3226
> Interconex, Inc.          E-mail:  [log in to unmask]
> Houston, TX, USA      URL:     http://www.interconex.com
> **************************************************************
> **********
>
>