---
updatedAt: 2025-06-03T20:39:45.000Z
agentTools:
  projectIndex: https://docs.ol-hub.com/llms.txt
---

# Sybase-DB

### ol test connection

```Text Windows
[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
```
```Text macOS
[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
```

![](https://files.readme.io/ccde421-return.png)  [Return to tutorial](https://ol-hub.readme.io/reference/onboarding-cli#step-5-test-the-data-source-connection-details)

### ol add for prepared statement (query)

```Text Windows
[module folder]> ol add --query "SELECT * FROM ACCOUNTS WHERE ID = ?" --operation-name account-by-id
```
```Text macOS
[module folder]$ ol add --query "SELECT * FROM ACCOUNTS WHERE ID = ?" --operation-name account-by-id
```

![](https://files.readme.io/ccde421-return.png)  [Return to tutorial](https://ol-hub.readme.io/reference/onboarding-cli#step-6-add-an-asset-to-your-module)

### ol add for stored procedure

```Text Windows
[module folder]> ol add --executable demo_db.dbo.proc_get_employee_by_id --temp-table-query "SELECT * FROM ACCOUNTS WHERE ID = 'A100000001'"
```
```Text macOS
[module folder]$ ol add --executable demo_db.dbo.proc_get_employee_by_id --temp-table-query "SELECT * FROM ACCOUNTS WHERE ID = 'A100000001'"
```

![](https://files.readme.io/ccde421-return.png)  [Return to tutorial](https://ol-hub.readme.io/reference/onboarding-cli#step-6-add-an-asset-to-your-module)

### ol add for stored procedure in advanced mode

```Text Windows
[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;"
```
```Text macOS
[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;"
```

![](https://files.readme.io/ccde421-return.png)  [Return to tutorial](https://ol-hub.readme.io/reference/onboarding-cli#step-6-add-an-asset-to-your-module)