Skip to Content
0
S T
Sep 20, 2016 at 04:24 PM

FOR USE SKIP WAIT WITH FETCH LIMIT ORDER UNION EXCEPT OFFSET

4987 Views

Hi All,

I have a scenario where I use a FF to load data into my Stg table. And in turn use this table as a lookup table which acts as in iput for an SQL transform. While running the Lookup table in the SQL tf, I am facing the error that says-

Token 07 was not valid. Valid tokens: FOR USE SKIP WAIT WITH FETCH LIMIT ORDER UNION EXCEPT OFFSET



Another error says-


<END-OF-STATEMENT> was not valid. Valid tokens: ( + - ? : DAY INF NAN NOT RID ROW.>.



Could you help me understand what exactly these errors mean?? Attached the screenshot for the same.


Attachments

error.PNG (36.8 kB)