topic Re: [Metadata] description of table from AS400 in Talend Studio

[Metadata] description of table from AS400

Anonymous — Sat, 16 Nov 2024 14:22:50 GMT

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

Re: [Metadata] description of table from AS400

Anonymous — Thu, 08 May 2008 02:52:22 GMT

Hello

bug or not possible ?

The common filed here is a free filed, you can add some commen manually.
Best regards
shong

Re: [Metadata] description of table from AS400

Anonymous — Mon, 26 Sep 2011 01:34:07 GMT

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

Re: [Metadata] description of table from AS400

Anonymous — Mon, 26 Sep 2011 22:33:23 GMT

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.

Re: [Metadata] description of table from AS400

Anonymous — Tue, 27 Sep 2011 04:03:52 GMT

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

Re: [Metadata] description of table from AS400

Anonymous — Tue, 27 Sep 2011 04:28:20 GMT

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

Re: [Metadata] description of table from AS400

Anonymous — Wed, 28 Sep 2011 13:08:35 GMT

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

Re: [Metadata] description of table from AS400

Anonymous — Mon, 07 Nov 2011 09:14:31 GMT

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