Jump to content

Calculated SQL text / ODBC Import Script Step - Error


This topic is 2061 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

Link to post
Share on other sites

SQL will expect the $lastImport date to be in a certain format.  Chances are that it is not the format that you have in your FM file.  Check into that first and see how you can reformat the FM date into the SQL format that Oracle expects.

Link to post
Share on other sites

This topic is 2061 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.