topic Re: DDL script in Talend Studio

DDL script

Anonymous — Wed, 21 Jun 2017 10:36:55 GMT

I have a DDL script that contains creation of tables & sequences. I want to create a job for it. Plz let me know what components can I use for the same

Re: DDL script

TRF — Wed, 21 Jun 2017 10:44:12 GMT

Hi,

tXxxxxRow (where Xxxxx is the db name, like Oracle, Mysql, and so on) is what you expect.

Re: DDL script

Anonymous — Wed, 21 Jun 2017 10:58:36 GMT

I already tried using tOracleRow however it takes only 1 SQL query. My requirement is to execute multiple SQL queries like running a script file containing DDL statements

Re: DDL script

TRF — Wed, 21 Jun 2017 11:01:45 GMT

did you try to enclose commands between ""?

"create table blablabla;
create sequence blablabla;"

Re: DDL script

Anonymous — Wed, 21 Jun 2017 11:10:59 GMT

Yes; I already tried that enclosing between "" & separated by ; However the error which I get is 'SQL command not properly ended'.

Re: DDL script

Anonymous — Wed, 21 Jun 2017 11:23:04 GMT

Try this.....

"begin
execute immediate 'CREATE TABLE customers
( customer_id number(10) NOT NULL,
  customer_name varchar2(50) NOT NULL,
  city varchar2(50)
)';
execute immediate 'CREATE TABLE address
( address_id number(10) NOT NULL,
  address_line_1 varchar2(50) NOT NULL,
  city varchar2(50)
)';
commit;
end;"

Re: DDL script

TRF — Wed, 21 Jun 2017 11:23:51 GMT

Is it a plain text script or a generated one using variables and concatenation?
Can you share it?

Re: DDL script

Anonymous — Wed, 21 Jun 2017 12:05:36 GMT

It is a normal script generated by SQL developer. It does not have variables or concatenation.

Re: DDL script

Anonymous — Wed, 21 Jun 2017 12:06:59 GMT

In which component should I give this?

Re: DDL script

Anonymous — Wed, 21 Jun 2017 12:14:37 GMT

The code I gave was an example of how you should code your tOracleRow component. The "Begin" and "End" keywords are standard Oracle functionality to allow multiple statements to fired together. Here is a description of the "Execute immediate" statemement (https://docs.oracle.com/cd/B19306_01/appdev.102/b14261/executeimmediate_statement.htm).