Skip to content

Latest commit

 

History

History
35 lines (32 loc) · 1009 Bytes

README.md

File metadata and controls

35 lines (32 loc) · 1009 Bytes
Raw

Commands / SQL

> zodbc sql -h
USAGE:
  zodbc sql [OPTIONS]

OPTIONS:
  -c, --command <VALUE>           SQL statement that will be executed
  -d, --dsn <VALUE>               Data source name connection string
  -o, --output <VALUE>            Output file path
      --include-headers           Include column headers in the output file
  -w, --workers <VALUE>           Number of connections to use within separate kernel threads
  -t, --timing                    Log execution time metrics
  -v, --verbose <VALUE>           Log memory and call trace information
  -h, --help                      Prints help information
> zodbc sql \
    --command='SELECT * FROM SYSIBM.SYSTABLES' \
    --dsn="Driver=${DB2_DRIVER};Hostname=localhost;Database=testdb;Port=50000;Uid=db2inst1;Pwd=password;" \
    --workers=4 \
    --timing \
    --verbose=1
...
output
 - size=951 bytes
timing:
 - wall=0.530517s
 - connect=0.522567s
 - prepare=0.000421s
 - execute=0.007365s
 - fetch=0.000005s