Conecte-se ao Netezza via ODBC em Lua

https://gist.github.com/4420315

-- Connect to Netezza via ODBC from Lua

-- load driver
require "luasql.odbc"

-- create environment object
env
= assert(luasql.odbc())

-- connect to data source using an existing DSN
-- assumes username/password are defined with DSN
con
= assert(env:connect("NZSQL"))

query
= "select count(*) from mytable"

cur
= assert(con:execute(query))

count
= cur:fetch()
print(string.format("count: %d", count))

-- close everything
cur
:close()
con
:close()
env
:close()