Question

1
Replies
583
Views
 Adrian Wijaya (AdrianPrW)
KBRU

KBRU
ID
AdrianPrW Member since 2016 57 posts
KBRU
Posted: June 20, 2017
Last activity: June 21, 2017
Posted: 20 Jun 2017 22:43 EDT
Last activity: 21 Jun 2017 0:59 EDT
Closed
Solved

Update Syntax for update external database(oracle) in Connect SQL

Hi all,

Can you tell me syntax for update external DB in connect SQL?

i use below syntax, but it seems error.

{SQLpage:MySQLPage}
UPDATE {.Class:MyClass} SET
PROPERTY="C"
WHERE
NAME="HOTEL"

Data Integration
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.

Accepted Solution

Posted: 4 years ago
Posted: 20 Jun 2017 23:33 EDT
Mahendra Kumar Mahaveer Chand (Mahendra_Kumar)
Verizon

Verizon
IN

There shouldn't be a '.' before class.

{SQLpage:MySQLPage}
UPDATE {Class:MyClass} SET
PROPERTY='C'
WHERE
NAME='HOTEL'