Additional session parameters in datastore with Teradata

[#1]

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!!

[former_member598107]

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