November 18, 2004, 12:29 AM
George BrownSQL passthrough UPDATE
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.
November 18, 2004, 03:04 AM
<Pietro De Santis>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.
November 29, 2004, 08:41 PM
George Brownquote:
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
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.
November 30, 2004, 01:27 PM
reFOCUSingYes 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.