|
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 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.