ODBC/Methods/Connect
< ODBC
Jump to navigation
Jump to search
ODBC: Data Sources | Handles | Data Driver | Error Messages | API: Connect Read Update Create Bulk Insert Config
The ddcon command connects to a data source returning a connection handle, using the form:
[ch=. ddcon 'dsn=jdata' 30545248
We have now connected to a data source, but not yet to a data file. The file we will use is tdata, and the next statement uses ddcol to retrieve the column names and attributes for this file:
$cols=: 'tdata' ddcol ch
7 19
3 4 7{"1 cols
+-----------+---------+-------------+
|COLUMN_NAME|DATA_TYPE|BUFFER_LENGTH|
+-----------+---------+-------------+
|NAME |12 |30 |
+-----------+---------+-------------+
|SEX |12 |2 |
+-----------+---------+-------------+
|DEPT |12 |8 |
+-----------+---------+-------------+
|DOB |4 |4 |
+-----------+---------+-------------+
|DOH |4 |4 |
+-----------+---------+-------------+
|SALARY |4 |4 |
+-----------+---------+-------------+