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.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     : IA with ODBC backend scripts SQL with nameless columns

Read-Only Read-Only Topic
Go
Search
Notify
Tools
: IA with ODBC backend scripts SQL with nameless columns
 Login/Join
 
TOM SCHULTE
Gold member
posted
I have come across a critical issue in rolling out IA to my user base.

A simple report (just two BY fields) gets transformed into SQL with a MAX() column that has now column name. Column names are a requirement of my ODBC driver. Can I configure IA or my WFRS to add column names for the columns it adds? Here is the full text of the error message:

(FOC1400) SQLCODE IS 10300 (HEX: 0000283C) : [S1000] [DataDirect][ODBC OpenAccess SDK driver][OpenAccess SDK SQL Engi : ne]A column without a name was detected in the result set for procedure : SELECT T1.Container_Status,T1.Add_Date, MAX(T1.Container_Status) FROM db :
o.Part_v_Container T1 WHERE (T1.Add_Date >= {ts '2010-08-17 09:43:42'}) : GROUP BY T1.Container_Status,T1.Add_Date ORDER BY T1.Container_Status,T1 : .Add_Date.
Please use an alias for conditional and calculated columns.[ : 10300] L

(FOC1406) SQL OPEN CURSOR ERROR. : PART_V_CONTAINER


WebFOCUS 7.7.04M/8001
Windows Server 2008
Excel, PDF, HTML, AHTML

http://www.plex.com
 
Posts: 73 | Location: Auburn Hills, MI | Registered: September 29, 2011Report This Post
j.gross
Virtuoso
posted Hide Post
Like the man said, "use an alias":
 
... , MAX(T1.Container_Status) as max_status FROM ... 
                               ^^^^^^^^^^^^^
 
Posts: 1925 | Location: NYC | In FOCUS since 1983 | Registered: January 11, 2005Report This Post
TOM SCHULTE
Gold member
posted Hide Post
Yeah, that works if I am writing the SQL, but when I am using IA with the GUI only (not even Editor), I don't have that option. I am looking for a way to get the "use an alias" message through to IA or deeper in the WF stack to the WFRS.

WF is adding the column without an alias, not me the IA user.


WebFOCUS 7.7.04M/8001
Windows Server 2008
Excel, PDF, HTML, AHTML

http://www.plex.com
 
Posts: 73 | Location: Auburn Hills, MI | Registered: September 29, 2011Report 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     : IA with ODBC backend scripts SQL with nameless columns

Copyright © 1996-2020 Information Builders