topic Re: Retrieving Schema from AS400 with DDS tables in Talend Studio

Retrieving Schema from AS400 with DDS tables

ricerocket17 — Thu, 14 Jun 2018 16:58:48 GMT

Hi,

I am currently running Talend Version: 7.0.1, on a Mac. Connecting to an AS400 V6R1 schema. I am able to retrieve the tables that were created via SQL. However, am having issues retrieving tables that were created via DDS (data description specifications). Is there a way to retrieve these in a similar fashion or is there some workaround?

Re: Retrieving Schema from AS400 with DDS tables

Anonymous — Fri, 15 Jun 2018 07:54:44 GMT

Hello,

Could you please let us know if this jira issue:https://jira.talendforge.org/browse/TDI-19342 is what you are looking for?

Best regards

Sabrina

Re: Retrieving Schema from AS400 with DDS tables

ricerocket17 — Fri, 15 Jun 2018 15:48:53 GMT

Hi Sabrina,

Thanks for the quick reply.

Yes, that sounds like something we're looking for. Unfortunately not too familiar with DDS but we'd like to pull in the tables that were created in DDS somehow since there are a lot of them. Was going to try adding one manually (tDBInput) to see if that works since i noticed that i can actually query the table through TOS.

Thanks

tomo

Re: Retrieving Schema from AS400 with DDS tables

Anonymous — Wed, 27 Jun 2018 08:13:09 GMT

Hello tomo,

Is it working when you add one manually (tDBInput)? And feel free to vote for this new feature jira issue on talend bug tracker.

Best regards

Sabrina

Re: Retrieving Schema from AS400 with DDS tables

ricerocket17 — Thu, 28 Jun 2018 15:36:04 GMT

Hi Sabrina,

appreciate the follow up. Yes! that worked adding them manually,a bit of a pain with the number of tables we're dealing with but I was able to connect to the AS400 via squirrel SQL and view the entire schema that way so should be fine for now.

The feature will definitely be appreciated so that i don't have to go back and forth to another tool to view the schema.

Didn't realize there was a voting option, just voted for it.

thanks!

tomo

Re: Retrieving Schema from AS400 with DDS tables

Anonymous — Fri, 29 Jun 2018 04:07:34 GMT

Hello Tomo,

We will keep you posted on this issue.

Best regards

Sabrina

Re: Retrieving Schema from AS400 with DDS tables

Anonymous — Wed, 11 Jul 2018 18:00:54 GMT

what is the latest version of talend that will work properly with as400 tables created via dds?

i have tried 7.x - does not work

i have tried 6.5 - does not work

i have tried 5.6 - WORKS!!!

i want to use the latest version of talend but feel that is not possible since it no longer will properly access table on my as400 mainframe.

thoughts?

am i missing something?

Re: Retrieving Schema from AS400 with DDS tables

Anonymous — Sat, 14 Jul 2018 14:48:21 GMT

Hello.

Having same problem here.

With TOS 6.4.1 I was able to retrieve schema of my AS400 database (OS/400 V6R1).

With TOS 7.0.1it doesn't work anymore. Only few files are shown in the selection list.

Despite this, components ar working fine.

But it's very irritating having to use the old TOS for retrieveing schema, saving it to file and import it in TOS 7.

Any help would be appreciated to deal with this problem.