Additional session parameters in datastore with Teradata

rgonzalr — Mon, 17 Jun 2019 17:43:35 GMT

Hello,

I'm working with Data Services 4.2.SP11 (14.2.11) and I'd like to create a datastore with the setting "Additional session parameters" = SET QUERY_BAND='SOURCE=TEST;' FOR SESSION;

However, the documentation says that possible values for this field are "A valid SQL statement or multiple SQL statements delimited by semicolons." and as so, my sentence gets truncated to SET QUERY_BAND='SOURCE=TEST

Is there any way to escape the semicolon in this field?

I've tried to escape it with \; but it didn't work.

Thanks in advance!!

Re: Additional session parameters in datastore with Teradata

former_member598107 — Fri, 21 Jun 2019 07:59:32 GMT

The answer lies in the Target table option

preload-command-option-in-target-table.jpg

You can set the below in the Target table options

SET QUERY_BAND = 'name=value; name2=value;' FOR SESSION|TRANSACTION;

Regards

Arun Sasi

Question Re: Additional session parameters in datastore with Teradata in Technology Q&A

Additional session parameters in datastore with Teradata

Re: Additional session parameters in datastore with Teradata