Can we run an sql file via node-ibm_db?

[Jonathan Tan]

Cause this would be a great feature that supports things like IaaC and migrating tables/indices/constraints/etc.

[bimaljha]

No you can not run. ibm_db APIs accepts SQL statements only not the file name containing set of SQL statements. That happens in Db2 CLP for executing queries in batches.

Such features would not limit only on DDL but should work for DML also. If an sql file has 10 select statements returning thousands of rows by each select statement, how such scenarios will get handled? Please provide more info about IaaC. How you want to received the selected data and what should be input/output of API if we think to provide any for such feature? Thanks.

[bimaljha]

Yes, using ibm...@2.6.3, you can execute sqlfile. It is documented here: https://github.com/ibmdb/node-ibm_db/blob/master/APIDocumentation.md#executeFileApi