top button
Flag Notify
    Connect to us
      Facebook Login
      Site Registration

Facebook Login
Site Registration

Informatica passing values of a port to query in SQL transformation

0 votes
206 views

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~));
posted Aug 25, 2014 by Sachin

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

Try to pre-place the quotes around the QC_CODE, as by the looks of the error it is just placing X instead of 'X' and erroring itself ou

answer Aug 26, 2014 by Shweta Singh
Similar Questions
0 votes

am trying to integrate a MySQL database with Salesforce but am having trouble with part of the query logic.

I enter this query:

SELECT occupation_name FROM skillsmatch_skillsprofile GROUP BY time_updated ORDER BY time_updated DESC LIMIT 0,5

But get this error:

<> missing operator... SELECT>>>> <<<

Any idea where I might be going wrong?

Thanks for your help!

Contact Us
+91 9880187415
sales@queryhome.net
support@queryhome.net
#280, 3rd floor, 5th Main
6th Sector, HSR Layout
Bangalore-560102
Karnataka INDIA.
QUERY HOME
...