JDD/Methods/Connect
< JDD
Jump to navigation
Jump to search
JDD: Driver Locale | Handles | Data Sources | Data Driver | Error Messages | API: Connect Read Update Create Bulk Insert
The ddcon command connects to a data source returning a connection handle, using the form:
[ch=. ddcon__db 'database=jdata;uid=root;pwd=****' 30545248
Actual format and parameters for ddcon will depend on individual JDD driver, please refer to test scripts in addons packages.
We have now connected to a data source, but not yet to a table. The table we will use is tdata, and the next statement uses ddcol to retrieve the column names and attributes for this table:
$cols=: 'tdata' ddcol__db ch 8 18 3 4 7{"1 cols +-----------+---------+-------------+ |COLUMN_NAME|DATA_TYPE|BUFFER_LENGTH| +-----------+---------+-------------+ |NAME |12 |45 | +-----------+---------+-------------+ |SEX |12 |3 | +-----------+---------+-------------+ |DEPT |12 |12 | +-----------+---------+-------------+ |DOB |91 |10 | +-----------+---------+-------------+ |DOH |91 |10 | +-----------+---------+-------------+ |SALARY |3 |8 | +-----------+---------+-------------+ |PHOTO |_4 |_1 | +-----------+---------+-------------+