Dataflux Conditional Expression with ODBC connection

Vinz867 — Mon, 06 Apr 2020 14:43:53 GMT

Hi all,

I am new in Dataflux and I am trying to figure out how to do a conditional logic with an ODBC connection using multiple columns from the external data source. There are multiple columns in the RULES table and I need to use them in a conditional logic.

This is what I have so far.

static dbconnection db1 static dbstatement stmt1 dbcursor curs1 boolean retval1 if isnull(db1) then db1 = dbconnect('DSN=MS Access Database;DFXTYPE=ODBC') if isnull(stmt1) then begin stmt1 = db1.prepare("SELECT * FROM "RULES" WHERE ISALPHA = ?") stmt1.setparaminfo(0, 'string', 5) end <<missing comparison>> if retval1 == true then return true else return false

Re: Dataflux Conditional Expression with ODBC connection

VincentRejany — Wed, 08 Apr 2020 07:44:14 GMT

Hi

I could try to write the code for you, but I doubt it will work directly as I won't be able to test it with your RULES table.
As an example the following code lets you get a list of tables in a particular database.
// Set Expression node to "Generate row when no parent is specified" to true
//Pre Expression
string DSN
DSN="DataFlux Sample"
string connectStr
//Preparing the connection string
connectStr = "DSN=" & DSN
DBConnection dbConn
dbConn = dbConnect( connectStr )

string tablename
string datapath
string tcatalog
string tabletype
DBCursor cursTables

//Retrieve table information in a cursor
cursTables = dbConn.tablelist();
//Iterate through the cursor
while( cursTables.next() )
begin
datapath = cursTables.valuestring(0); tcatalog =
cursTables.valuestring(1); tablename = cursTables.valuestring(2);
tabletype = cursTables.valuestring(3)
pushrow()
end
cursTables.release();

//Expression
seteof()
return false

topic Re: Dataflux Conditional Expression with ODBC connection in SAS Data Management

Dataflux Conditional Expression with ODBC connection

Re: Dataflux Conditional Expression with ODBC connection