dblookupdestroy
This destroys the related resources, for example, JNI context and database connection, used by dblookup. This command returns an empty string.
Example:
dblookupdestroy table
dblookupdestroy is not required when using dblookup at engine runtime. The engine automatically destroys the resources that are used by the Database Lookup table during shutdown.
Examples
hcitcl>dblookup test_simple.tbl key01
test1
hcitcl>dblookup test.tbl key01 test1
1,2014-04-01,0,test1,key01
hcitcl>dblookup -metacolumnname test.tbl key01 test1
{RSMETACOLUMNNAME {intFLD} {dateFLD} {flag} {strFLD} {ID}} {RSDATA {{1} {2014-04-01} {0} {test1} {key01}}}
hcitcl>dblookup -maxrow 2 test_rows.tbl 0
2014-04-01,0,key01,1,test1
2014-04-02,0,key02,2,test2
hcitcl>dblookup –maxrow 2 -metacolumnname test_rows.tbl 0
{RSMETACOLUMNNAME {dateFLD} {flag} {ID} {intFLD} {strFLD}} {RSDATA {{2014-04-01} {0} {key01} {1} {test1}} {{2014-04-02} {0} {key02} {2} {test2}}}
hcitcl>dblookup -maxrow test_rows.tbl 0
2014-04-01,0,key01,1,test1
2014-04-02,0,key02,2,test2
2014-04-03,0,key03,3,test3
2014-04-04,0,key04,4,test4
2014-04-05,0,key05,5,test5
2014-04-06,0,key06,6,test6
2014-04-07,0,key07,7,test7
2014-04-08,0,key08,8,test8
2014-04-09,0,key09,9,test9
2014-04-10,0,key10,10,test10
hcitcl>dblookupdestroy test_rows.tbl
hcitcl>
hcitcl>dblookupdestroy test
hcitcl>