IBM Db2 for i is an integrated relational database management system optimized for IBM i.
Installation
Required packages: ibm_db_sasqlalchemy-ibmi
Drivers
ibm_db_sa (with LIMIT)Recommended
ibm_db_sa (without LIMIT syntax)
db2+ibm_db://{username}:{password}@{hostname}:{port}/{database}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
Resources