Good News Everybody!
The new search engine is LIVE!
Please report any problems to david (at) midrange.com.
|
midrange.com
Jeff,
You can change the data type of the date field in the LF, like
A INVDT A
Hope that helps.
Regards.
Carel Teijgeler
======= At 2002-05-06, 14:54:00 you wrote: =======
>I'm trying to create a logical file and use the year and month portions
>of an *ISO date field ("INVDT") as a key, like this:
>
> A R SHRECORD PFILE(*LIBL/SLSHST)
> A*
> A SLSNR
> A CUSNR
> A INVDT
> . . .
> . . . <snip>
> . . .
> A ONRCUP
> A*
> A INVYR I SST(INVDT 1 4)
> A INVMO I SST(INVDT 6 2)
> A*
> A K CUSNR
> A K ITNBR
> A K INVYR DESCEND
> A K INVMO DESCEND
>
>The DDS compiler is hiccupping on the SST statements, saying the field
>to be "substringed" must be character or zoned decimal. Is there a way
>to do this?
>
= = = = = = = = = = = = = = = = = = = =
As an Amazon Associate we earn from qualifying purchases.
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.
