Adding multiple rows to a projected SQL table

Question

Peter Monteiro · Aug 2, 2022

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')

Thanks

Peter

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]

Discussion (1)1

Robert Cemper · Aug 2, 2022

INSERT INTO Sample_Table.Accounts (Account, AccountName, Bank) Select '123456', 'AccountNameOne', 'BANK1' union all Select '654321', 'AccountNameTwo', 'BANK2'

Details: https://docs.intersystems.com/iris20221/csp/docbook/Doc.View.cls?KEY=RSQL_insert

1 0

Adding multiple rows to a projected SQL table - Persistent Object