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