Adding multiple rows to a projected SQL table - Persistent Object
I'm trying to add multiple rows at a time to a SQL table for a persistent object, but I can't seem to get the syntax correct. When I try the below it doesn't work.
INSERT INTO Sample_Table.Accounts (Account, AccountName, Bank) VALUES ('123456', 'AccountNameOne', 'BANK1'), ('654321', 'AccountNameTwo', 'BANK2')
Product version: IRIS 2021.2
$ZV: IRIS for Windows (x86-64) 2021.1.2 (Build 338U) Tue Apr 12 2022 12:04:03 EDT [Health:3.3.0]