Powershell and intersystems sql shell
i want to update some values in tsysparameters table through powershell. how to write the script.
Discussion (0)0
Comments
first you need to install a valid DSN: Defining an ODBC Data Source on Windows
for PS you may take the same approach as described here
Thanks Robert. I have downloaded the x64 driver and to configure ODBC. On a side note, just want to understand where do we get all the tables in the IRIS/Healthshare application.
once you know what namespace you are looking at you may list available schemata by
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA
which returns 750 rows for namespace HSCUSTOM
Thanks a lot Robert. This helps a lot. Also, the ODBC Driver also worked for me.