IBM Db2 for i is an integrated relational database management system optimized for IBM i.
Installation
Required packages: sqlalchemy-ibmi
Connection String
ibmi://{username}:{password}@{host}/{database}| Parameter | Description |
|---|---|
| username | IBM i user profile |
| password | User password |
| host | Hostname or IP address |
| database | Library/schema name |
Supported Features
JOINsSubqueriesDynamic SchemaCatalog SupportDynamic CatalogSSH TunnelingQuery CancellationFile UploadUser ImpersonationCost EstimationSQL Validation
Feature Score: 38/201
Time Grains
Common Time Grains:
SECONDMINUTEHOURDAYWEEKMONTHQUARTERYEAR
Extended Time Grains:
FIVE_SECONDSTHIRTY_SECONDSFIVE_MINUTESTEN_MINUTESFIFTEEN_MINUTESTHIRTY_MINUTESHALF_HOURSIX_HOURSWEEK_STARTING_SUNDAYWEEK_STARTING_MONDAYWEEK_ENDING_SATURDAYWEEK_ENDING_SUNDAYQUARTER_YEAR