MSSQL

[module folder]> ol test connection --url jdbc:sqlserver://52.206.218.139:1450;databaseName=demo_db --username sa --password Open1egacy! --properties [some_value] --query-timeout 3000 --timezone [some_value] --auto-commit-mode false --connection-test-query "SELECT * FROM ACCOUNTS WHERE ID = 'A100000001'" --pool-max-size 5 --use-time-zone-as-region false

[module folder]$ ol test connection --url jdbc:sqlserver://52.206.218.139:1450;databaseName=demo_db --username sa --password Open1egacy! --properties [some_value] --query-timeout 3000 --timezone [some_value] --auto-commit-mode false --connection-test-query "SELECT * FROM ACCOUNTS WHERE ID = 'A100000001'" --pool-max-size 5 --use-time-zone-as-region false

[module folder]> ol add --executable demo_db.dbo.proc_get_employee_by_id

[module folder]$ ol add --executable demo_db.dbo.proc_get_employee_by_id

[module folder]> ol add --executable demo_db.dbo.proc_get_employee_by_id --result-set-fetch-mode advanced --advanced-result-set-query "EXEC proc_get_employee_by_id @val = 1;" --combine-result-sets true

[module folder]$ ol add --executable demo_db.dbo.proc_get_employee_by_id --result-set-fetch-mode advanced --advanced-result-set-query "EXEC proc_get_employee_by_id @val = 1;" --combine-result-sets true