Re: Use of DDS field names in RPG

On 28/09/2009, at 6:18 PM, David FOXWELL wrote:

Although, I realise the limitations of this. I can't use EVAL-CORR while I have this kind of prefix.

You can use PREFIX creatively on both the file definition and the data structure definition to remove the first character from the field name. Used in conjunction with QUALIFIED data structures you should be able to use EVAL-CORR quite happily.

What kind of field naming standards are you using in DDS?

I generally use a 2-character file prefix with up to 8 characters for the field identifier itself. I also specify a meaningful ALIAS for SQL access. Six character field names (as in your convention) are no longer needed with RPG IV.

The only reason for the prefix is RPG's insistence that each field name refers to a single storage location. Languages that support qualification (e.g., COBOL and C) don't need this sort of work around.

If I only used SQL for data access I would drop the prefix. If I only had to code for VRM540 and above I would probably drop the prefix and use PREFIX to map file field names to qualified data structures.

Regards,
Simon Coulter.
--------------------------------------------------------------------
FlyByNight Software OS/400, i5/OS Technical Specialists

http://www.flybynight.com.au/
Phone: +61 2 6657 8251 Mobile: +61 0411 091 400 /"\
Fax: +61 2 6657 8251 \ /
X
ASCII Ribbon campaign against HTML E-Mail / \
--------------------------------------------------------------------