Q:
How to export meta-data
AS400 Data Definitions, AS400 Data Model Export, AS/400, AS/400 database, AttachMate and AS400, AS/400 backup, Metadata, XML I am charged with archiving data from a legacy AS400 packaged system. I can export the data using attachmate and a few tricks to get it into XML on my LAN. However, the FDF info is not good as metadata, so I need to retrieve the field level that is available thru 'file commands''display file field description'. That facility has the option to stream into a file which I could also get at through AttachMate. (1) Is there a way to do this for selective information rather than capturing all the extraneous stuff, and (2) is there was to do it preserving the display names for this metadata, such as in a 'label'-'value' pairing. Of course, I would like to do this one request per database, since each database has hundreds of tables.
ASKED:
Jun 5 2009 1:29 AM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
A:
RATE THIS ANSWER
0
Click to Vote:
0
Click to Vote:
- 0
0
Using SQL or Query/400 you can create a new file from the DSPFFD output containing only the columns that you want.
I'm not sure what you mean by value-label -- the labels will, I believe appear in the output the values are not part of the meta-data.
Phil
