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     SQL passthrough UPDATE

Read-Only Read-Only Topic
Go
Search
Notify
Tools
SQL passthrough UPDATE
 Login/Join
 
George Brown
Gold member
posted
Am I correct in assuming that I can do this...

SQL SQLORA SET SERVER SERVERNAME
SQL SQLORA
UPDATE SERVERNAME.table_name
SET column_name = '&new_value'
WHERE column_name = '&some_value';
END

as long as a .acx and .mas file have been created with write access to the table?

We are running Oracle as our database and we are running WebFOCUS 5.2.6 on a linux machine.
 
Posts: 77 | Location: Chicago, IL | Registered: May 06, 2004Report This Post
<Pietro De Santis>
posted
I'm not sure if your SQL syntax is correct, but the ACX and Master are not used when using SQL in a fex - the Oracle connection settings you coded are used instead.
 
Report This Post
George Brown
Gold member
posted Hide Post
quote:
I'm not sure if your SQL syntax is correct, but the ACX and Master are not used when using SQL in a fex - the Oracle connection settings you coded are used instead.
You are correct but also not correct Wink

Let me explain:
While it is true that you don't use the .mas and .acx files when connecting with the SQL passthrough you do use the "SET SERVER <server>" command which uses the userid and password from the data adapters screen. This is the name of the "<server>" you'll be connecting to.

So it is my understanding that the userid for this data adapter must either be the same as the schema of the table or needs to have write access to that table.

Does this make sense? I still have not tested this theory.
 
Posts: 77 | Location: Chicago, IL | Registered: May 06, 2004Report This Post
reFOCUSing
Guru
posted Hide Post
Yes that makes sense. Your connect will need to look like the one you created in your edasprof.prf file and you don't really need the .mas and .acx files. Also be careful when you have tables/views that are named the same in different schemes.
 
Posts: 406 | Location: Canada | Registered: May 31, 2004Report 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     SQL passthrough UPDATE

Copyright © 1996-2020 Information Builders