search for: sqltxnfvs

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

2009 Jul 30
0
RODBC and Oracle
...existing message on the topic. I gave up but figured I keep at least the same subject. In a gist I get an empty data frame after issuing the following select query from R 2.9.1 to Oracle 10.2.0.1 64bit via RODBC 1.3 and Oracle 11g 32bit driver -- all on the same Windows 2003 Server 64bit machine. 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 = '...