Vertica Input Query does not support SSRS Input Parameters

444 views Asked by At

I am Creating SSRS reports using Vertica Data Source. I need to insert values to vertica physical table using SSRS input parameters. Build query like this:

INSERT INTO Employee VALUES (@GUID, @EmpNo, @EmpName); 

While executing it thorows error:

ERROR: Syntax error at or near ","
----------------------------
[42601] ERROR: Syntax error at or near ","

Meanwhile, select query works fine with SSRS input parameters, query like this:

select * from Employee
where GUID = @GUID`.

Any help on this would be greatly appreciated.

0

There are 0 answers