https://community.qlik.com/t5/Talend-Studio/Iterating-over-Table-Schemas-metadata-in-Java/m-p/2292669#M65721 <P>I would like to access the Metadata in code, more specifically, I would like to access the comments of the columns in the Table Schemas (so I can push those comments into oracle like</P><P></P><P></P><P>COMENT ON COLUMN employees.job_id</P><P>IS 'abbreviated job title'</P><P></P><P></P><P>Would anyone have a code-sample of that?</P><P></P><P></P><P></P><P></P> Sat, 16 Nov 2024 01:27:17 GMT reinier1 2024-11-16T01:27:17Z https://community.qlik.com/t5/Talend-Studio/Iterating-over-Table-Schemas-metadata-in-Java/m-p/2292669#M65721 <P>I would like to access the Metadata in code, more specifically, I would like to access the comments of the columns in the Table Schemas (so I can push those comments into oracle like</P><P></P><P></P><P>COMENT ON COLUMN employees.job_id</P><P>IS 'abbreviated job title'</P><P></P><P></P><P>Would anyone have a code-sample of that?</P><P></P><P></P><P></P><P></P> Sat, 16 Nov 2024 01:27:17 GMT https://community.qlik.com/t5/Talend-Studio/Iterating-over-Table-Schemas-metadata-in-Java/m-p/2292669#M65721 reinier1 2024-11-16T01:27:17Z https://community.qlik.com/t5/Talend-Studio/Iterating-over-Table-Schemas-metadata-in-Java/m-p/2292670#M65722 <P>Hi </P><P>Take a look at rhall's <A href="https://www.talend.com/blog/2019/11/11/migrate-data-between-databases-one-job-using-dynamic-schema/" alt="https://www.talend.com/blog/2019/11/11/migrate-data-between-databases-one-job-using-dynamic-schema/" target="_blank">article</A>, you are able to get the metadata properties in the job with Dynamic schema functionality, refer to the example code on tJavaFlex component mentioned in the article. </P><P>&nbsp;</P><P>Regards</P><P>Shong</P><P>&nbsp;</P> Fri, 18 Sep 2020 07:34:37 GMT https://community.qlik.com/t5/Talend-Studio/Iterating-over-Table-Schemas-metadata-in-Java/m-p/2292670#M65722 Anonymous 2020-09-18T07:34:37Z