Creating table on AS400 with TEXT field

[Moe1]

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.

[Moe1]

Bump, hope someone could help.. Thank you.

[Anonymous · Accepted solution]

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

[Moe1]

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

[Moe1]

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

[Anonymous]

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).