Talend Connect
Virtual Summit
JOIN US!
And visit the Customer
& Community Lounge.
May 27-28, wherever you are.

[Metadata] description of table from AS400

Highlighted
One Star

[Metadata] description of table from AS400

Hi,

when we retrieve schema from a AS400 database (librairies) in the metadata to a AS400 connection, the description of the table is not retrieve from the dspffd to the comment fields of the schema.

bug or not possible ?

Jeremie
Highlighted
Community Manager

Re: [Metadata] description of table from AS400

Hello
bug or not possible ?

The common filed here is a free filed, you can add some commen manually.
Best regards
shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
Highlighted
One Star

Re: [Metadata] description of table from AS400

Hello,
I was searching about this. Have we now a way to get filled the comments column in the schema? I mean, I'd like when we use the button "Guess schema" , we have the comment filled from the TEXT attribute of AS/400 PF file. Any clue?
Cheers,
- Walter
Highlighted
Six Stars

Re: [Metadata] description of table from AS400

Yeah you should file a feature req....
I agree that it would be very useful to let Talend auto-compile schema comments, especially on large schemas... a feature that an ETL tool should have and very important when interfacing with the AS400 where comments are used heavily ( due to usually cryptic and legacy field names ).
The pity is that Talend has already all in place to do that... a single call to java jdbc DatabaseMetaData.getcolumns getting the REMARKS column would do the trick.
Highlighted
One Star

Re: [Metadata] description of table from AS400

Thanks emaxt6, I will have in mind your suggest about getting the REMARKS info. Where can I see the currents feature requests?
Highlighted
Community Manager

Re: [Metadata] description of table from AS400

Thanks emaxt6, I will have in mind your suggest about getting the REMARKS info. Where can I see the currents feature requests?

You can report a new feature on our bugtracker if it does not exist.
http://jira.talendforge.org/secure/Dashboard.jspa
Best regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
Highlighted
One Star

Re: [Metadata] description of table from AS400

thanks shong. I can't found the project for Talend Open Studio. What's the name in Jira?
Highlighted
One Star

Re: [Metadata] description of table from AS400

Hello together,
when I connect to our AS400 and Import a database table I can see the comments for example
Column name = BVDRCD and in the Comment field I see "Item Number".
In the export file I want the comment from the as 400 as column name, so I want "Item Number" instead of "BVDRCD".
Can this be done automatic?
Greetings

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog