search for: is_po

Displaying 1 result from an estimated 1 matches for "is_po".

Did you mean: is_pf
2009 Jul 30
0
RODBC and Oracle
...ne. sqlTxnFvs = "select txn.*,pan.*,mcc.*,tmzip.* from mddsg100bp txn inner join mdd_panfvs pan on (txn.seq_no = pan.seq_no) inner join mdd_mccfvs mcc on (txn.seq_no = mcc.seq_no) inner join mdd_tmzipfvs tmzip on (txn.seq_no = tmzip.seq_no) where is_test = '%d' and is_pos = '%d' and ora_hash(txn.seq_no,%d,%d)=0" dbConn = odbcConnect("mysid",uid="myuser",pwd="mypass",case="toupper",believeNRows=FALSE) tfg = sqlQuery(dbConn, sprintf(sqlTxnFvs,0,0,1/sratg-1,seeds[i])) dbErr = odbcGetErrMsg(dbConn) All of the table...