Re: Long field names in DDS

[Jeff Crosby <jlcrosby@xxxxxxxxxxxxxxxx>]

Print file doesn't compile.  I used:

A            CUSNR     R             15REFFLD(CUSNR *LIBL/ITMMNTCB)
A                                      ALIAS(ITMMNTCBDS.CUSNR)

in the DDS and got this in the compile printout:

A            CUSNR     R             15REFFLD(CUSNR *LIBL/ITMMNTCB)
A                                      ALIAS(ITMMNTCBDS.CUSNR)    
                              CPD7616-*     .                    
                                    CPD7544-*                    
The errors are:

   ID      Severity  
Number                                                                           

* CPD7544      20        1      Message . . . . :   Character after 
first character of name not valid.
* CPD7616      30        1      Message . . . . :   Keyword ignored 
because of error in list of values.

I assume it doesn't like the "." (period) in there.  Tried it without 
the REFFLD and explicitly defined the length.  Same result.


rob@xxxxxxxxx wrote:
> Oops.  I forget that you are defining your database files with SQL's DDL 
> now.
>
> Printer file, eh?
> What the hey, seems like ALIAS is supported there also.
> http://publib.boulder.ibm.com/infocenter/systems/scope/i5os/topic/rzakd/rzakdmstptalias.htm
>
> Rob Berendt
>