topic Re: tMSSqlRow with table name to define in Talend Studio

tMSSqlRow with table name to define

Anonymous — Fri, 22 Mar 2019 18:19:47 GMT

Hi,

I would like to create a table under MS Sqlserver with a fixed name like : customer+context.value

My context value is the category of context : int, dev, rec, prd

I've try

"select * into customer \""+context.value+"\" from customer"

This will create customerint like customer.

Thank you for your help i'm a little bit lost with simple and/or double quotes.

Re: tMSSqlRow with table name to define

Anonymous — Fri, 22 Mar 2019 18:50:51 GMT

Can you please describe more about what you want?

Re: tMSSqlRow with table name to define

Anonymous — Mon, 25 Mar 2019 09:37:21 GMT

As i said in the post, i would like to do : For exemple a table name like "customer" and information from my active environment context : exeample : Context Env = dev (for development

select * from customer+context Env dynamically => select * form customerDev

Re: tMSSqlRow with table name to define

akumar2301 — Mon, 25 Mar 2019 09:43:50 GMT

Hello

"select * form customer" + contextStr

Re: tMSSqlRow with table name to define

Anonymous — Mon, 25 Mar 2019 10:03:27 GMT

Hi

The environment context should be selected before the job execution, however, the value of context variable could be changed at run time.

Regards

Shong

Re: tMSSqlRow with table name to define

Anonymous — Mon, 25 Mar 2019 10:23:56 GMT

Hi,

Don't work.

I'm trying to copy the table customer to a cutomerDev table

like this : select * into customer"+context.Dev+" from customer" ;

but there is something wrong in my request with the context Var

I've tried : select * into customer \""+context.Dev+"\" from customer" ; but it don't work

Re: tMSSqlRow with table name to define

Anonymous — Mon, 25 Mar 2019 11:42:37 GMT

It works fine now, sometimes to mutch quote kills the request. Then I just modify with

"select * into customer\"+context.Dev+\""