Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at myibi@ibi.com and provide your corporate email address, company, and name.


Connect to myibi
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] only an ET or null statement is legal after a DDL statement in WebFocus

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] only an ET or null statement is legal after a DDL statement in WebFocus
 Login/Join
 
Gold member
posted
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,
 
Posts: 80 | Registered: March 21, 2007Report This Post
Platinum Member
posted Hide Post
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
 
Posts: 106 | Registered: April 06, 2009Report This Post
Gold member
posted Hide Post
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
 
Posts: 80 | Registered: March 21, 2007Report This Post
<JG>
posted
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.
 
Report This Post
Platinum Member
posted Hide Post
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



 
Posts: 129 | Registered: June 01, 2005Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] only an ET or null statement is legal after a DDL statement in WebFocus

Copyright © 1996-2020 Information Builders