[CLOSED] only an ET or null statement is legal after a DDL statement in WebFocus
I have an issue with SQL passthrough in WebFocus. I have a requirement to create volatile table and to select from it further. While executed in Teradata the Query works fine, as the SQl was executed as single statements. But when tried from WebFocus its throwing error as
only an ET or null statement is legal after a DDL statement, as its processed as single transaction.Any way to overcome this error?And also if anyone can provide details on how we can control the execution of the SQL from WebFocus it would also be helpful.Thanks very much!
My Sql would look like this:
CREATE MULTISET VOLATILE TABLE TEST AS( SELECT COLUMN1 , COLUMN2 FROM ( SELECT COLUMN1,COLUMN2 FROM DB.TABLENAME GROUP BY COLUMN1) GROUPBY COLUMN1)
SELECT * FROM TEST;
Thnaks Prasanna WebFocus Version 7.1.7This message has been edited. Last edited by: Kerry,
April 16, 2009, 10:54 AM
I see posts say you need SQL SQLxxxxx for passthru. You using?
Client Server 8.1.05: Apache; Tomcat;Windows Server 2012 Reporting Server 8.1.05; Oracle; MS SQL; Windows Server 2012
April 16, 2009, 11:27 AM
Yes I'm using SQl SQLDBC which is for teradata.This was working fine for quite long time and suddenly I faced this issue.I think some connectivity might ahve changed which I'm not sure of.
When I have searched in forums it appears if we can do a tranaction commit with SQL pass through mode we can resolve this error.Any idea on this?
Thanks Prasanna WebFocus Version 7.1.7
April 16, 2009, 11:44 AM
If something has worked in one way and suddenly stops working then you must have either upgraded WebFOCUS or Teradata or changed the configuration in one, either or both systems.
If a WebFOCUS change has caused the problem then you need to raise a case with IBI. If a Teradata change has caused the problem you need to raise a case with IBI so they know and can possibly supply a fix.
April 16, 2009, 07:11 PM
I ran into this problem when we changed from 5.3.3 to 7.6.4. We had SQL /\/\/\/\/\/\ \/\/\/\/\/\/ ; -RUN -SET &NOW = HHMMSS('A8'); -TYPE PROCESSING SQL ANSWER SET &NOW TABLE FILE SQLOUT /\/\/\/\/\/\ \/\/\/\/\/\/
the "TABLE FILE SQLOUT" started throwing an error "discription not found for file SQLOUT" remove the DM code fixed it.
Jim Morrow Web Focus 7.6.10 under Windows 2003 MVS 7.3.3