For AI agents: visit https://docs.ol-hub.com/llms.txt for an index of all pages formatted in Markdown and endpoints in OpenAPI. Append .md to any documentation page URL to get its markdown version.
Go to HOME .ol\cli\
Create the extra-classpath-resources folder in the cli folder.
Save the following files in extra-classpath-resources .
db2jcc_license_cu.jar
db2jcc4-10.5.jar
db2jcc_license_cisuz.jar
Return to tutorial
Windows macOS
[module folder]> ol test connection --url jdbc:db2://192.86.32.238:5035/DALLASB --driver-class-name --driver-class-name oracle.jdbc.driver.OracleDriver --username demo --password 12345 --result-set-type RESULT_SET_TYPE --result-set-concurrency RESULT_SET_CONCURRENCY --properties [some_value] --query-timeout 3000 --timezone [some_value] --auto-commit-mode false --connection-test-query [some_value] --pool-max-size 5 --use-time-zone-as-region false[module folder]$ ol test connection --url jdbc:db2://192.86.32.238:5035/DALLASB --driver-class-name --driver-class-name oracle.jdbc.driver.OracleDriver --username demo --password 12345 --result-set-type RESULT_SET_TYPE --result-set-concurrency RESULT_SET_CONCURRENCY --properties [some_value] --query-timeout 3000 --timezone [some_value] --auto-commit-mode false --connection-test-query [some_value] --pool-max-size 5 --use-time-zone-as-region falseReturn to tutorial
Windows macOS
[module folder]> ol add --procedure GET_ACCOUNT_ORDERS --schema DEMO001 --advanced-result-set-query CALL DEMO001.GET_ACCOUNT_ORDERS('A100054321')[module folder]$ ol add --procedure GET_ACCOUNT_ORDERS --schema DEMO001 --advanced-result-set-query CALL DEMO001.GET_ACCOUNT_ORDERS('A100054321')Return to tutorial
