I'm trying to create metadata from our DB2 adapter in 7.6.5 to reflect our metadata from 7.1.1.

On our old set up we are able to generate metadata and specify the fieldname='short|long|both' and we need it to be set to both. What this does is it will take the fieldname and make it descriptive such as:

FIELD=SERIAL_NUMBER,
ALIAS='SRL1', USAGE=A30, ACTUAL=A30,
DESCRIPTION='Serial Number',
TITLE='Serial,Number',$
FIELD=ITEM_NUMBER,
ALIAS='LITM', USAGE=A25, ACTUAL=A25,
DESCRIPTION='Item Number',
TITLE='Item,Number',$
FIELD=INSTALLATION_NUMBER,
ALIAS='INSTALL', USAGE=P3 , ACTUAL=P2,
DESCRIPTION='Installation Number',
TITLE='Installation,Number',$
FIELD=COMMENTS,
ALIAS='DCS1', USAGE=A30, ACTUAL=A30,
DESCRIPTION='Comments',$


However, in 7.6.5 whenever I create metadata on the same table I get:

FIELDNAME=SRL1, ALIAS=SRL1, USAGE=A30, ACTUAL=A30,
TITLE='Serial,Number', DESCRIPTION='Serial Number', $
FIELDNAME=LITM, ALIAS=LITM, USAGE=A25, ACTUAL=A25,
TITLE='Item,Number', DESCRIPTION='Item Number', $
FIELDNAME=INSTALL, ALIAS=INSTALL, USAGE=P3, ACTUAL=P2,
TITLE='Installation,Number', DESCRIPTION='Installation Number', $
FIELDNAME=DCS1, ALIAS=DCS1, USAGE=A30, ACTUAL=A30,
TITLE='Comments', DESCRIPTION='Comments', $


Due to the long time it has taken for us to upgrade we now have lots of reports that use the descriptive names from 7.1.1 but I would prefer being able to generate metadata to match up with all of our reports versus having to change some of these items manually which could cause some grief when we add more fields to a table.

I opened a case with IBI and they suggested that there isn't a way to get the results that I want. I will update the case again asking them specifically about the old 7.1.1's option to change the fieldname type, but if anyone knows how I can change this in 7.6.5 I would appreciate it.