Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

Vertica Input Query does not support SSRS Input Parameters

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, why insert query does not work?

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.