Focal Point
[CLOSED] only an ET or null statement is legal after a DDL statement in WebFocus

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/68210538

April 16, 2009, 10:49 AM
Prasanna
[CLOSED] only an ET or null statement is legal after a DDL statement in WebFocus
Hi,

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.7

This message has been edited. Last edited by: Kerry,
April 16, 2009, 10:54 AM
Kofi
Prasanna,

I see posts say you need SQL SQLxxxxx for passthru. You using?

Kofi


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
Prasanna
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
<JG>
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
Jim Morrow
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