We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


Vertica Input Query does not support SSRS Input Parameters — Vertica Forum

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