Generate Type Trees from DB2 database tables on AS/400 platform

[mercdev]

Folks,
Could you please provide me with input on the process of generating the mercator type trees from DB2 tables on AS2/400 platform.

Thanks in advance.

 

[jmanj]

If you know how to use the Database Interfaces Designer that comes with your Mercator, then it should be no brainer. First
create an ODBC (DSN) connectivity to your DB2 database. Use this DSN name in the database interface designer. You will be prompted to logon to your AS400 host. After you login, you
can highlight which table you want to generate a tree.

 

[mercdev]

jmanj,

Thanks very for the quick turn around and that is what I did exactly using ODBC adapter. But, wondering how can I make use of DB2 adapter and came to know from Ascential that this feature would be supported in v7.5

Regards,
mercdev

 

[jmanj]

Good point. We just does'nt know what the future could be...
Anyway, I forgat to mentioned that YES there is a way of making type trees out of DB2 tables. I forgot I have this map that create a type tree out of an excel spreadsheet. I will publish this mercator map once I found it in our archive. Here's how it work.

1. Download the source file(DDS) of the table to your local
drive as a csv file (We use Reflection).
2. Open the csv file and you will only need the following
columns:
1. Field Name -
2. Type - alpha or numeric
3. Max Size - Maximum Size in bytes
4. decimal - Number of decimal places if num.
5. sign - Put 1 if signed
3. Run the map using the csv as input. This map will create
a copybook type tree. This will also create a file showing your source in cobol format.

 

[BocaBurger]

Connectivity to DB2 on AS/400 will be through Data Direct ODBC client, supplied with the 7.5 distrib. This will work on all supported platforms.

BocaBurger
<===========================||////////////////|0
The pen is mightier than the sword, but the sword hurts more!