DB2-ZOA-SP

Prerequisites

Go to {user.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

ol test connection

[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 false

Return to tutorial

ol add

[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