Any tool or command to export meta-data from iBM DB2 Webquery to file eg. XML?

Question

Would like to export ALL META-DATA from existing iBM-i DB2 Webquery to file eg. .xml type of file for a client as they want to have their webquery reports meta-data migrated to other solutions. They are on iBM-i AS400 series

Any tool or commands I can use to do this?

Any help is GREATLY Appreciated!! I had been searching but unable to find any answer.

You can use PS to query the DB2 database (see stackoverflow.com/questions/11862005/…). Then there are lot of methods in PS to export to XML. — jdweng
– jdweng, Commented Oct 18, 2024 at 9:45

Charles · Accepted Answer · 2024-10-18 15:28:08Z

1

According the the Web Query Backup guide

• Synonyms
Also referred to as metadata. All synonyms are stored under the Integrated File System (IFS) directory /QIBM/UserData/qwebqry/apps.
• Reports
Also known as fexs or focexecs, these are the reports, documents and dashboards created via Web Query. These items reside in database tables in library QWQREPOS.

You can take a peek in those locations and see if it's a format you can read.

Also note that IBM i Web Query is a rebranded Informational Builders product. Info you find for IBI may be applicable.

answered Oct 18, 2024 at 15:28

Charles

24.2k3 gold badges23 silver badges50 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Any tool or command to export meta-data from iBM DB2 Webquery to file eg. XML?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related