1 Reply Latest reply on Aug 10, 2015 12:11 PM by Ramesh Reddy

    Native query proc with criteria

    virtualdatabase Apprentice

      I have modeled a physical procedure with a nativeQuery property

      when I set the property to this SELECT * FROM INFORMATION_SCHEMA.TABLES where table_cat='\\x\Datae\Client\6274\028\Tables'

      the query runs fine


      I then cloned this and changed the nativequery to this:

       

      SELECT * FROM INFORMATION_SCHEMA.TABLES where table_Cat = $TableCat

       

      TableCat is the name of the input property (I've tried naming it 1 just to match the documentation!)

       

      However, when I run a query at runtime:

       

      select * from INfoSchemaObjs where tableCat ='\\x\Datae\Client\6274\028\Tables'

       

      it returns no results

       

      From the logs it looks as though the '\\x\Datae\Client\6274\028\Tables' isn't being substituted for $TableCat

       

      What am I missing?