<< DbLastQueryError SciDb DbTables >>

SciDb >> SciDb > DbQuery

DbQuery

execute a query on previously opened connection

Calling Sequence

DbQuery(query)
DbQuery(dblink, query)

Parameters

dblink

a pointer to database connection object (returned by DbConnect())

query

a string value of query executed

Description

DbQuery() executes a query on default connection and returns a pointer to result handler or results in an error if a query cannot be executed.

DbDisconnect(dblink) executes a query on previously opened connection, represented by dblink pointer and returns a pointer to result handler or results in an error if a query cannot be executed.

Examples

// Opens a “PostgreSQL” connection with a connexion string
dblink = DbConnect("PSQL", ..
"Server=127.0.0.1;Database=myDataBase;User Id=myUsername;Password=myPassword;");

resultHandle = DbQuery(dblink, "SELECT * FROM data_table");

results = DbFetchStruct(resulthandle);

//Disconnect from default (the last) database myDataBase
DbDisconnect();

See Also

Authors


Report an issue
<< DbLastQueryError SciDb DbTables >>