AnsweredAssumed Answered

Calculated SQL Text / ODBC Import

Question asked by Scott Van Nostrand on Dec 11, 2014
Latest reply on Dec 14, 2014 by Scott Van Nostrand

Title

Calculated SQL Text / ODBC Import

Post

I have a script that collects the last update date of a set of records. I set a local variable to it ($LastImport).

  Set Variable $LastImport  =xyz_0::MAX_LAST_UPDATE

I setup a Import Records script step that goes out to an ODBC database (Oracle 10g) to bring into a temp table only those records that are >= than the last update date.

   "SELECT * FROM xyz_LEVEL_0_DATA_V WHERE xyz_LEVEL_0_DATA_V.LAST_UPDATE_DATE >= " & $LastImport & ""

I get this error back:

    ODBC Error: [Oracle][ODBC][Ora] ORA-00936: missing expression

I have imported data from this Oracle database many times directly into tables but this is the first time I'm trying to filter down the import to make it execute faster (over 4,000,000 records to deal with )...

Any ideas?

Thanks

Scott

Outcomes