|
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-2025 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 copyright@midrange.com.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.