RE: Select/Omit logical on timestamp field

Looks like you're missing the continuation character, either a '-' or '+',
after the "COMP(EQ "

- Dan Bale

-----Original Message-----
From: midrange-l-admin@midrange.com
[mailto:midrange-l-admin@midrange.com]On Behalf Of Scott Mildenberger
Sent: Tuesday, February 19, 2002 1:06 PM
To: 'MIDRANGE-L@midrange.com'
Subject: Select/Omit logical on timestamp field


Has anyone ever created a select/omit logical and selecting (or omitting) on
a field defined as a timestamp?  Field DOPROCDATE is defined as a timestamp
(type Z) in the physical.  According to the DDS reference it should be like

R ROUTPUT                   PFILE(DGOUTPUT)
S DOPROCDATE                COMP(EQ
                            '0001-01-01-00.00.00.000000')

but it won't compile, I get CPD7956 saying the select or omit field
specified incorrectly.  I did have to split between two lines to make it
fit.  I also tried VALUES which fit on one line and got the same error when
compiling.

Thanks,

Scott Mildenberger