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     database connection problem

Read-Only Read-Only Topic
Go
Search
Notify
Tools
database connection problem
 Login/Join
 
<Vipul>
posted
we are using wf5.2.3 I am having the following problem when I try sql pass thru on the database (db2 udb). Any Insights: I have looked at knowledge base and not got any ideas.
I am appending a simple code w/o sql pass thru it is fine as a fiddle but sql pass thru' creates a havoc.


SET SQLENGINE=DB2
-*ENGINE DB2 SET DEFAULT_CONNECTION TMUPIT
ENGINE DB2 SET CONNECTION_ATTRIBUTES r_tmupi
-*SQL DB2 SET CURRENT SQLID = 'tmupi'
-*SQL DB2 SET CONNECTION_ATTRIBUTES r_tmupi/tmupi,tmupi
-*SQL DB2
select TMUPI.NAME from TMUPI.CORORG for fetch only;
TABLE FILE SQLOUT
PRINT *
ON TABLE SAVE AS BANK_NAME
END -RUN
(FOC1517) UNRECOGNIZED COMMAND select TMUPI.NAME from TMUPI.CORORG for fetch
only;
0 ERROR AT OR NEAR LINE 24 IN PROCEDURE MEMFEX FOCEXEC *
(FOC205) THE DESCRIPTION CANNOT BE FOUND FOR FILE NAMED: SQLOUT
BYPASSING TO END OF COMMAND
-EXIT
Thanks,

Vipul

This message has been edited. Last edited by: <Mabel>,
 
Report This Post
Silver Member
posted Hide Post
We use DB2 8.1 and 5.2.3 as well and have been using the following ( replace variables to match your environment):

ENGINE DB2 SET DEFAULT_CONNECTION &DBNAME
ENGINE DB2
SELECT
...
;
TABLE ON TABLE HOLD AS &VIEWNAME FORMAT ALPHA
END
TABLE FILE &VIEWNAME
...
END

Jon
 
Posts: 39 | Registered: January 26, 2004Report This Post
<Grzegorz>
posted
Vipul,

The error points that the PASSTHROUGH is not passed to DB2 - the native DB2 SELECT statement is handled as a FOCUS request.
For DB2 I used syntax:

-* Setting the engine here if necessary:
...
-*
SQL SQL
SELECT native DB2 statement
... ;
TABLE
ON TABLE HOLD AS HOLD_FILE
END

and I have never had any problems.
I noticed some issues (but not remember details) when using syntax SQL DB2.

Regards
Grzegorz
 
Report This Post
Member
posted Hide Post
Can someone tell me what is the syntax for the same if instead of the DB2 data source to access a Teradata datasource?

Please explain the engine settings that need to be specified also.

Thanks in advance
 
Posts: 4 | Location: Topeka | Registered: September 01, 2004Report This Post
Guru
posted Hide Post
This works like a charm using SQL Server in 4.3.6 (have not tested in 5.3):

SET SQLENGINE = SQLMSS
SQL &SQLDB SET USER VismaBusiness
SQL &SQLDB SET SERVER VismaBusiness
-RUN
-*
SQL
SELECT AcNo,Nm
FROM F9999.DBO.AC ;
TABLE FILE SQLOUT
SUM Nm
BY AcNo
ON TABLE HOLD AS ACTEMP FORMAT FOCUS INDEX AcNo
END
-RUN
 
Posts: 319 | Location: Stockholm, Sweden | Registered: February 04, 2004Report This Post
Member
posted Hide Post
Vipul,
I believe your code is missing the keyword "SQL" before the passthru code.

SET SQLENGINE=DB2
ENGINE DB2 SET CONNECTION_ATTRIBUTES r_tmupi

SQL
select TMUPI.NAME from TMUPI.CORORG for fetch only;
 
Posts: 26 | Location: Mercy College | Registered: May 06, 2003Report 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     database connection problem

Copyright © 1996-2020 Information Builders