How to export meta-data

5 pts.
Tags:
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.
ASKED: June 5, 2009  1:29 AM
UPDATED: June 7, 2009  12:24 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

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

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following