Physical files w/o DDS

[Guest.Visitor]

doesn't the *attribute field show this??????? bob hamilton DEEP BLUE won only 2 of 6 games which won't evenget you on the CUBS or JETS.

[frankgw@adelphia.net]

Mike - Another way to take a quick look at a file would be to use the WRKQRY command and view the file that way. If it is an externally described file, the individual fields can be seen. Just an old mainframer--- Send E-mail if you remember 9-PAC or the GE-225!

[T.Holt]

Use the UNIQUEKEY keyword, like this: OPNQRYF FILE((MYFILE)) KEYFLD((FIELDA) (FIELDB) (DATE *DESC)) + UNIQUEKEY(2) (This is off the top of my head, but it should be close at least.) The UNIQUEKEY keyword needs to have the number of key fields before the date. If you have my book, Open Query File Magic!, you can find this at the beginning of Chapter 6. Hope this helps. On Wednesday, July 23, 1997, 07:47 AM, Brad Pietrzak wrote: I have multiple records with the same ID (as the key) and different dates. I need to select the only one of the records with the most current date. How would I use the select or group select in opnqryf to do this?

[Guest.Visitor]

On Tuesday, July 29, 1997, 06:15 AM, Michael McClain wrote: Does anyone know?---Under v3R1, is there an easy way (using a command like DSPOBJD or something) to tell which physical files DO NOT have corresponding DDS specs. I know that I have some that were created under the S36 environment and would like to be able to id them so that a conversion tool can create the DDS for me. Any help or suggestions appreciated. TIA, Mike ================================================== ============================== ================== If you use the DSPFFD command, you will see that all PFs without DDS will have a MAXIMUM of three fields. The names of those fields will be: K00001, and F00001, and perhaps F00002. David Abramowitz