Re: Couple more newbie questions.

Rob - serious thought here for once - does John really NEED to learn DDS? At least for tables and all? Might he not actually be able to go the SQL route? He may already know Query Management, which is part of mainframes, I believe. Those would give him formatted printed output without printer files. And there is the CICS product - that'd give him screens.

Or they might go completely to web-based interfaces.

Modernize? Eh? What say?

OK - back to my corner

Vern

rob@xxxxxxxxx wrote:

I believe that if you define your files with SQL then the default is to Reuse deleted records . . . . . . . . . . . : REUSEDLT *YES
If you type in CRTPF then the default is to:
Reuse deleted records . . . . . . . . . . . : REUSEDLT *NO
And most vendor supplied applications will use CRTPF and DDS (or Data Description Specifications). You WILL have to learn DDS.

Reuse is normally not a problem unless your application relies on arrival sequence. Which I've seen in some multiformat EDI applications and a rare history log or two that didn't set up an otherwise unique key.

There's also a command called RGZPFM which will compress out deleted records and will sort the file too if you use the optional KEYFILE parameter.


Rob Berendt