BTEQ and Derived table in mainframe...

[devendrap]

I have SQL for updating table. The SQL has derived table. The SQL works in Queryman but doesn't work in mainframe BTEQ.

Appreciate your help.

Thanks

 

[dnoeth]

You probably used ODBC SQL syntax within your query, e.g. month(..) or rtrim(...)

Uncheck "Allow use of ODBC SQL Extensions in queries" in Queryman, Tools -> Options

And now that query will fail in Queryman, too ;-)

If you don't know how to fix it, simply post it...

Dieter

 

[devendrap]

After reducing length of line from downloaded file, it works...

Thank you!!