I have a SQL transformation with 2 ports. I want to insert the value of these ports to a table, however I am getting an error from sqlError port.
Below is the query I am writing in the source qualifier:
INSERT INTO A values (~QC_CODE~,(~QUERY_STRING~));
The QUERY_STRING port contains a sql statement which is executed on Teradata and results have to be inserted in the table A.
If I replace the first port in the above query with a constant value, I get correct results. Below is the query that gives correct result:
INSERT INTO A values ('1',(~QUERY_STRING~));