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.
I am simply wanting to access an SQL Server DB and I continue to get the below error. Looked through the documentation and it seems the adapter syntax looks right. Am I missing something?
SET SQLENGINE = SQLMSS ENGINE SQLMSS SET CONNECTION_ATTRIBUTES SQLFND1 -RUN
SQL SELECT SAPData.dbo.communication_log.tk_init, SAPData.dbo.communication_log.date_ent FROM SAPData.dbo.communication_log ; TABLE ON TABLE HOLD AS HOLD_TMP FORMAT ALPHA END
-RUN TABLE FILE HOLD_TMP PRINT * END
(FOC1400) SQLCODE IS -1 (HEX: FFFFFFFF) XOPEN: 00000 : (-1) [00000] JDBFOC>> describecols(): error: getMetaData call on stmt : returned null ResultSetMetaData object! L (FOC1405) SQL PREPARE ERROR. 0 ERROR AT OR NEAR LINE 20 IN PROCEDURE sql_server_test (FOC205) THE DESCRIPTION CANNOT BE FOUND FOR FILE NAMED: HOLD_TMP BYPASSING TO END OF COMMANDThis message has been edited. Last edited by: J.Biza,
You are doing sql pass thru so metadata/access file is not part of the issue. Test the connection of the data adapter for SQLFND1. Also try this alternative syntax.
ENGINE SQLMSS SET DEFAULT_CONNECTION SQLFND1
SQL SQLMSS PREPARE SQLOUT FOR
SELECT
SAPData.dbo.communication_log.tk_init,
SAPData.dbo.communication_log.date_ent
FROM SAPData.dbo.communication_log
;
END
-RUN
TABLE FILE SQLOUT
PRINT *
END
You cannot do a TABLE FILE on an Alpha file without a reference. You can "READ" it but not "TABLE FILE" it.
SET SQLENGINE = SQLMSS
ENGINE SQLMSS SET CONNECTION_ATTRIBUTES SQLFND1
-RUN
SQL
SELECT
SAPData.dbo.communication_log.tk_init,
SAPData.dbo.communication_log.date_ent
FROM SAPData.dbo.communication_log;
TABLE
ON TABLE HOLD AS HOLD_TMP FORMAT ALPHA
END
-RUN
FILEDEF HOLD_TMP DISK <app>/hold_tmp.ftm
TABLE FILE HOLD_TMP
PRINT *
END
WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF In Focus since 2007
Posts: 2409 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013
: (-1) [00000] JDBFOC>> describecols(): error: getMetaData call on stmt
: returned null ResultSetMetaData object!
is a SQL error, not a WebFOCUS error.
I imagine the complication is reading an SAP table using a JDBC connection.
I would generate WF metadata, then write a simple fex to read the table, and turn SQL traces on. Perhaps the generated SQL will give you a clue as to how to code your SQL Passthru.
Francis
Give me code, or give me retirement. In FOCUS since 1991
Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
The table I created had a reserve word in the column title and it also didn't like the varchar(max) field format. Recreated the table with those changes and works fine. Thanks everybody for the help.