topic Creating table on AS400 with TEXT field in Talend Studio

Creating table on AS400 with TEXT field

Moe1 — Wed, 04 Oct 2017 16:58:29 GMT

Hi,

I am able to create tables on AS400 using tas400output (create table) however I need to fill the field TEXT (field description, i.e.: BBETREP field has description as Client Number) that is on AS400, is it possible from Talend?

Thank you.

Re: Creating table on AS400 with TEXT field

Moe1 — Thu, 05 Oct 2017 16:13:00 GMT

Bump, hope someone could help.. Thank you.

Re: Creating table on AS400 with TEXT field

Anonymous — Thu, 05 Oct 2017 17:00:35 GMT

I have the same need but unluckily Talend doesn't provide that, despite being technically very simple and despite other competitors provides this.

Talend has already everything in place in the schema model (that already include the "comment" column), they just need to map the comment in the database during schema creation and schema reading.

They syntax for a column comment/description in DB2 is quite simple (COMMENT ON COLUMN statement), they should just include it during the CREATE TABLE statement.

I've already opened a JIRA for a similar case, but listen... in 2012!!! to say how much Talend team cares about proper schema documentation and comment autofilling DDD

I use others ETL tools just for this reason (lack of comment fetching during "guess schema" phase, because without this feature the ETL tool is nothing more than a toy for industrial purposes).

https://jira.talendforge.org/browse/TUP-186832

Re: Creating table on AS400 with TEXT field

Moe1 — Thu, 05 Oct 2017 17:11:55 GMT

Thank you mate, I did reply to your JIRA topic and lets hope they could add this simple feature....

Re: Creating table on AS400 with TEXT field

Moe1 — Thu, 31 May 2018 07:25:56 GMT

Still no updates here or in Jira topic, I wonder why they ignore it!!

Re: Creating table on AS400 with TEXT field

Anonymous — Sat, 02 Jun 2018 17:24:51 GMT

I personally suggest when consulted, to many IBM system i and mainframe DB2 shops, typically with extremely high spending power in the millions range for integration projects, other ETL competitors for IBM landscapes.

Talend is good but not curing details towards this kind of things (ie. auto documentation from db) for system i and mainframe db2 is not going to help.
With a little implementation effort they can win many resistance toward Talend.

System i is an exceptional system architecturally, it includes also native data queues, exceptional for robust integration patterns, but also those are not integrated natively in Talend (see other Jira I've opened years ago).