ol test connection
[module folder]> ol test connection --url jdbc:jtds:sybase://52.206.218.139:5000 --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:jtds:sybase://52.206.218.139:5000 --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
ol add for prepared statement (query)
[module folder]> ol add --query "SELECT * FROM ACCOUNTS WHERE ID = ?" --operation-name account-by-id[module folder]$ ol add --query "SELECT * FROM ACCOUNTS WHERE ID = ?" --operation-name account-by-idol add for stored procedure
[module folder]> ol add --executable demo_db.dbo.proc_get_employee_by_id --temp-table-query "SELECT * FROM ACCOUNTS WHERE ID = 'A100000001'"[module folder]$ ol add --executable demo_db.dbo.proc_get_employee_by_id --temp-table-query "SELECT * FROM ACCOUNTS WHERE ID = 'A100000001'"ol add for stored procedure in advanced mode
[module folder]> ol add --executable demo_db.dbo.proc_get_employee_by_id --advanced-result-set-query "EXEC proc_get_employee_by_id @val = 1;"[module folder]$ ol add --executable demo_db.dbo.proc_get_employee_by_id --advanced-result-set-query "EXEC proc_get_employee_by_id @val = 1;"