2 Replies Latest reply on Dec 14, 2014 7:07 PM by Scott Van Nostrand

    Calculated SQL Text / ODBC Import

    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