0

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.

woot
  • 7,406
  • 2
  • 36
  • 55
San
  • 11
  • 2
  • See if you can find how the query was actually received by Vertica. Maybe run it and then look at the query_requests view? – woot Nov 26 '14 at 04:16
  • Thanks for your reply wood, Could let me know how can i view the query_requests? – San Nov 26 '14 at 07:02
  • `SELECT * FROM query_requests WHERE request ilike 'select%Employee%'` or something similar – woot Nov 27 '14 at 05:00

0 Answers0