How to export meta-data
AS/400, AS/400 backup, AS/400 database, AS400 Data Definitions, AS400 Data Model Export, AttachMate and AS400, 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.
Software/Hardware used:
Software/Hardware used:
ASKED:
June 5, 2009 1:29 AM
UPDATED:
June 7, 2009 12:24 PM
Answer Wiki:
As I understand this question - you are able to run the DSPFFD command to a file. If you use *ALL for the object you will capture all files in a library. This will have to be repeated for each library with *ADD for the member rules.
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
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
