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


This thread ...

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2026 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.