Open Studio - Defining Schema at Run Time.

Anonymous — Fri, 12 Jun 2015 19:26:57 GMT

I have a requirement to provide the schema at runtime and I realized that it's possible for a few scenarios and NOT for others. Let me explain:
When I attempt to TRUNCATE a table using the tPostgresqlRow component, I'm able to (as shown below).

However, when I use an existing connection to INSERT data into a table I get the following error:

ERROR: relation "customer" does not exist
Position: 13ERROR: relation "customer" does not exist
Position: 13ERROR: relation "customer" does not exist
Position: 13

I noticed an article on Talend -> "Can I define a schema at run time?" Is this why my INSERT doesn't work, while TRUNCATE works as I can specify the Schema Name?
What's the workaroud? The feature of being able to provide schema name at runtime will be a great way for me to get my work done.

Re: Open Studio - Defining Schema at Run Time.

Anonymous — Mon, 15 Jun 2015 05:10:31 GMT

Hi,
What does your schema look like? Unknown column structure that you have to define it at run time?

Best regards
Sabrina

topic Re: Open Studio - Defining Schema at Run Time. in Talend Studio

Open Studio - Defining Schema at Run Time.

Re: Open Studio - Defining Schema at Run Time.