You can translate the question and the replies:

INSERT Operation fails with multiple records and the now() function

I'm performing a simple Insert Operation with multiple records using the now() function. insert into "ViewName" ("Id", "Name", "EmailAddress", "EmailDtm") values ('1', 'joe', '', now()), ('2', 'joe', '', now()) It throws an error: Error executing view: {0} When inserting just a single row, like below, the insert is successful. insert into "ViewName" ("Id", "Name", "EmailAddress", "EmailDtm") values ('1', 'joe', '', now()) Is there an issue with using the now() function inside of an Insert Operation with multiple records? Any help would be appreciated.
13-04-2021 17:39:24 -0400

1 Answer

Hi, In case I get an error when inserting rows to the underlying database I would perform the following checks: * I would check the vdp.log file in the **<DENODO_HOME>/logs/vdp** folder to see if there are any errors recorded related to the insert operation. * Also, I would check if it is possible to perform insert operation with multiple records directly in the database. Suppose if you still need help and if you are a valid support user then you can raise a support case on [Denodo Support Site]( so that our support team can help you Hope this helps!
Denodo Team
15-04-2021 07:26:17 -0400
You must sign in to add an answer. If you do not have an account, you can register here