| FreeTDS User Guide: A Guide to Installing, Configuring, and Running FreeTDS | ||
|---|---|---|
| Prev | Chapter 11. Programming | Next |
Microsoft's version of db-lib is online. Sybase's is both online and can be downloaded as a PDF file. [1]
Table 11-1. db-lib API Implementation Summary
| Category | Microsoft name | Sybase name | Status | Comments |
|---|---|---|---|---|
| (none) | n/a | db12hour | ||
| (none) | n/a | dbaltbind_ps | ||
| (none) | n/a | dbbind_ps | ||
| (none) | n/a | dbbufsize | ||
| (none) | n/a | dbcharsetconv | ||
| (none) | n/a | dbcoltypeinfo | OK | |
| (none) | n/a | dbconvert_ps | OK | |
| (none) | n/a | dbfreesort | never | |
| (none) | n/a | dbfree_xlate | never | |
| (none) | n/a | dbgetcharset | ||
| (none) | n/a | dbgetloginfo | never | |
| (none) | n/a | dbgetlusername | ||
| (none) | n/a | dbgetnatlang | ||
| (none) | n/a | DBIORDESC | OK | |
| (none) | n/a | DBIOWDESC | OK | |
| (none) | n/a | dbloadsort | never | |
| (none) | n/a | dbload_xlate | never | |
| (none) | n/a | dbnpcreate | never | |
| (none) | n/a | dbnpdefine | never | |
| (none) | n/a | dbpoll | ||
| (none) | n/a | DBRBUF | never | |
| (none) | n/a | dbreadpage | never | |
| (none) | n/a | dbrecftos | OK | |
| (none) | n/a | dbrecvpassthru | never | |
| (none) | n/a | dbregdrop | never | |
| (none) | n/a | dbregexec | never | |
| (none) | n/a | dbreghandle | never | |
| (none) | n/a | dbreginit | never | |
| (none) | n/a | dbreglist | never | |
| (none) | n/a | dbregnowatch | never | |
| (none) | n/a | dbregparam | never | |
| (none) | n/a | dbregwatch | never | |
| (none) | n/a | dbregwatchlist | never | |
| (none) | n/a | dbrpwclr | never | |
| (none) | n/a | dbrpwset | never | |
| (none) | n/a | dbsafestr | OK | |
| (none) | n/a | dbsechandle | ||
| (none) | n/a | dbsendpassthru | never | |
| (none) | n/a | dbsetbusy | ||
| (none) | n/a | dbsetdefcharset | ||
| (none) | n/a | dbsetdeflang | ||
| (none) | n/a | dbsetidle | ||
| (none) | n/a | dbsetifile | OK | |
| (none) | n/a | dbsetinterrupt | OK | |
| (none) | n/a | DBSETLCHARSET | ||
| (none) | n/a | DBSETLENCRYPT | ||
| (none) | n/a | dbsetloginfo | never | |
| (none) | n/a | dbsetrow | OK | |
| (none) | n/a | dbsetversion | OK | |
| (none) | n/a | dbspr1row | OK | |
| (none) | n/a | dbspr1rowlen | OK | |
| (none) | n/a | dbsprhead | OK | |
| (none) | n/a | dbsprline | OK | |
| (none) | n/a | dbstrcmp | never | |
| (none) | n/a | dbstrsort | never | |
| (none) | n/a | dbtextsize | ||
| (none) | n/a | dbwritepage | never | |
| (none) | n/a | dbxlate | never | |
| bcp | bcp_batch | (same) | OK | |
| bcp | bcp_bind | (same) | OK | |
| bcp | bcp_colfmt | (same) | OK | |
| bcp | n/a | bcp_colfmt_ps | ||
| bcp | bcp_collen | (same) | OK | |
| bcp | bcp_colptr | (same) | OK | |
| bcp | bcp_columns | (same) | OK | |
| bcp | bcp_control | (same) | OK | |
| bcp | bcp_done | (same) | OK | |
| bcp | bcp_exec | (same) | OK | |
| bcp | n/a | bcp_getl | OK | |
| bcp | bcp_init | (same) | OK | |
| bcp | bcp_moretext | (same) | stub | |
| bcp | n/a | bcp_options | partial | |
| bcp | bcp_readfmt | (same) | OK | |
| bcp | bcp_sendrow | (same) | OK | |
| bcp | BCP_SETL | (same) | OK | |
| browse | dbcolbrowse | n/a | never | |
| browse | dbcolsource | n/a | never | |
| browse | dbfreequal | n/a | never | |
| browse | dbqual | n/a | never | |
| browse | dbtabbrowse | n/a | never | |
| browse | dbtabcount | n/a | never | |
| browse | dbtabname | n/a | never | |
| browse | dbtabsource | n/a | never | |
| browse | dbtsnewlen | n/a | never | |
| browse | dbtsnewval | n/a | never | |
| browse | dbtsput | n/a | never | |
| core | dbadata | (same) | OK | |
| core | dbadlen | (same) | OK | |
| core | dbaltbind | (same) | OK | |
| core | dbaltcolid | (same) | OK | |
| core | dbaltlen | (same) | OK | |
| core | dbaltop | (same) | OK | |
| core | dbalttype | (same) | OK | |
| core | dbaltutype | (same) | OK | |
| core | dbanullbind | (same) | OK | |
| core | dbbind | (same) | OK | |
| core | dbbylist | (same) | OK | |
| core | dbcancel | (same) | OK | |
| core | dbcanquery | (same) | OK | |
| core | dbchange | (same) | OK | |
| core | dbclose | (same) | OK | |
| core | dbclrbuf | (same) | OK | |
| core | dbclropt | (same) | partial | |
| core | dbcmd | (same) | OK | |
| core | dbcmdrow | DBCMDROW | OK | |
| core | dbcolinfo | n/a | OK | |
| core | dbcollen | (same) | OK | |
| core | dbcolname | (same) | OK | |
| core | dbcoltype | (same) | OK | |
| core | dbcolutype | (same) | OK | |
| core | dbconvert | (same) | OK | |
| core | dbcount | DBCOUNT | OK | |
| core | dbcurcmd | DBCURCMD | stub | |
| core | dbcurrow | DBCURROW | stub | |
| core | dbdata | (same) | OK | |
| core | dbdataready | n/a | ||
| core | dbdatecrack | (same) | OK | |
| core | dbdatlen | (same) | OK | |
| core | dbdead | DBDEAD | OK | |
| core | dbenlisttrans | n/a | never | |
| core | dbenlistxatrans | n/a | never | |
| core | dberrhandle | (same) | OK | |
| core | dbexit | (same) | OK | |
| core | dbfcmd | (same) | OK | |
| core | dbfirstrow | DBFIRSTROW | OK | |
| core | dbfreebuf | (same) | OK | |
| core | dbgetchar | (same) | OK | |
| core | dbgetmaxprocs | (same) | OK | |
| core | dbgetoff | (same) | never | |
| core | dbgetpacket | (same) | OK | |
| core | dbgetrow | (same) | OK | |
| core | dbgettime | DBGETTIME | OK | |
| core | dbgetuserdata | (same) | OK | |
| core | dbinit | (same) | OK | |
| core | dbisavail | DBISAVAIL | OK | |
| core | dbiscount | n/a | never | |
| core | dbisopt | (same) | partial | |
| core | dblastrow | DBLASTROW | OK | |
| core | dblogin | (same) | OK | |
| core | dbfreelogin | dbloginfree | OK | |
| money | n/a | dbmny4add | OK | |
| money | n/a | dbmny4cmp | OK | |
| money | n/a | dbmny4copy | OK | |
| money | n/a | dbmny4divide | stub | |
| money | n/a | dbmny4minus | OK | |
| money | n/a | dbmny4mul | stub | |
| money | n/a | dbmny4sub | OK | |
| money | n/a | dbmny4zero | OK | |
| money | n/a | dbmnyadd | stub | |
| money | n/a | dbmnycmp | OK | |
| money | n/a | dbmnycopy | OK | |
| money | n/a | dbmnydec | OK | |
| money | n/a | dbmnydivide | stub | |
| money | n/a | dbmnydown | stub | |
| money | n/a | dbmnyinc | OK | |
| money | n/a | dbmnyinit | stub | |
| money | n/a | dbmnymaxneg | OK | |
| money | n/a | dbmnymaxpos | OK | |
| money | n/a | dbmnyminus | OK | |
| money | n/a | dbmnymul | stub | |
| money | n/a | dbmnyndigit | stub | |
| money | n/a | dbmnyscale | stub | |
| money | n/a | dbmnysub | stub | |
| money | n/a | dbmnyzero | OK | |
| core | dbmorecmds | DBMORECMDS | OK | |
| core | dbmsghandle | (same) | OK | |
| core | dbname | (same) | OK | |
| core | dbnextrow | (same) | OK | |
| core | dbnullbind | (same) | OK | |
| core | dbnumalts | (same) | OK | |
| core | dbnumcols | (same) | OK | |
| core | dbnumcompute | (same) | OK | |
| core | dbnumorders | DBNUMORDERS | never | |
| core | dbopen | (same) | OK | |
| core | dbordercol | (same) | never | |
| core | dbprhead | (same) | OK | |
| core | dbprocerrhandle | n/a | never | |
| core | dbprocinfo | n/a | never | |
| core | dbprocmsghandle | n/a | never | |
| core | dbprrow | (same) | OK | |
| core | dbprtype | (same) | OK | |
| core | dbresults | (same) | OK | |
| core | dbrows | DBROWS | OK | |
| core | dbrowtype | DBROWTYPE | OK | |
| core | n/a | dbservcharset | OK | |
| core | dbserverenum | n/a | never | |
| core | dbsetavail | (same) | OK | |
| core | dbsetlapp | DBSETLAPP | OK | |
| core | dbsetlfallback | n/a | never | |
| core | dbsetlhost | DBSETLHOST | OK | |
| core | dbsetlnatlang | DBSETLNATLANG | OK | |
| core | dbsetlogintime | (same) | OK | |
| core | dbsetlpacket | DBSETLPACKET | OK | |
| core | dbsetlpwd | DBSETLPWD | OK | |
| core | dbsetlsecure | n/a | ||
| core | dbsetltime | n/a | ||
| core | dbsetluser | DBSETLUSER | OK | |
| core | dbsetlversion | n/a | OK | |
| core | dbsetmaxprocs | (same) | OK | |
| core | dbsetnull | (same) | OK | |
| core | dbsetopt | (same) | partial | |
| core | dbsettime | (same) | OK | |
| core | dbsetuserdata | (same) | OK | |
| core | n/a | dbspid | OK | |
| core | dbsqlexec | (same) | OK | |
| core | dbsqlok | (same) | OK | |
| core | dbsqlsend | (same) | OK | |
| core | n/a | dbstrbuild | OK | |
| core | dbstrcpy | (same) | OK | |
| core | dbstrlen | (same) | OK | |
| core | n/a | DBTDS | OK | |
| core | dbuse | (same) | OK | |
| core | dbvarylen | (same) | OK | |
| core | n/a | dbversion | OK | |
| core | dbwillconvert | (same) | OK | |
| core | dbwinexit (Windows only) | n/a | never | |
| cursor | dbcursor | (same) | never | |
| cursor | dbcursorbind | (same) | never | |
| cursor | dbcursorclose | (same) | never | |
| cursor | dbcursorcolinfo | (same) | never | |
| cursor | dbcursorfetch | (same) | never | |
| cursor | dbcursorfetchex | n/a | never | |
| cursor | dbcursorinfo | (same) | never | |
| cursor | dbcursorinfoex | n/a | never | |
| cursor | dbcursoropen | (same) | never | |
| datetime | n/a | dbdate4cmp | never | |
| datetime | n/a | dbdate4zero | never | |
| datetime | n/a | dbdatechar | never | |
| datetime | n/a | dbdatecmp | OK | |
| datetime | n/a | dbdatename | never | |
| datetime | n/a | dbdateorder | never | |
| datetime | n/a | dbdatepart | never | |
| datetime | n/a | dbdatezero | never | |
| datetime | n/a | dbdayname | never | |
| datetime | n/a | dbmonthname | OK | |
| procedure | dbhasretstat | (same) | OK | |
| procedure | dbnumrets | (same) | OK | |
| procedure | dbretdata | (same) | OK | |
| procedure | dbretlen | (same) | OK | |
| procedure | dbretname | (same) | OK | |
| procedure | dbretstatus | (same) | OK | |
| procedure | dbrettype | (same) | OK | |
| procedure | dbrpcexec | n/a | ||
| procedure | dbrpcinit | (same) | OK | |
| procedure | dbrpcparam | (same) | OK | |
| procedure | dbrpcsend | (same) | OK | |
| text | dbmoretext | (same) | OK | |
| text | dbreadtext | (same) | OK | |
| text | dbtxptr | (same) | OK | |
| text | dbtxtimestamp | (same) | OK | |
| text | dbtxtsnewval | (same) | ||
| text | dbtxtsput | (same) | ||
| text | dbupdatetext | n/a | ||
| text | dbwritetext | (same) | OK |
| [1] | Links such as these are quite perishable. Should you find them broken, please check the FreeTDS User Guide posted on our website. If it's out of date, please let us know, so we can correct it. Thanks. |