Hi,
Can you please let me know is it possible to update the record using Open Command option?
I want to Update the record in the employee table using the command below:-
Update Employee set Name='Gaurav'
I know I can do it with user defined SQL which are available in ODBC/OCI Stages but I want to do it using Open Command option
Regards
Neeraj
Update using Open Command
Moderators: chulett, rschirm, roy
Yes..
I am using this appraach as per my business requirement
in the director, it looks like this
#### STAGE: ODBC_Enterprise_4
## Operator
odbcwrite
## Operator options
-db_cs [&DSProjectMapName]
-data_source 'dev'
-user 'test'
-password '[&"DBPassword"]'
-insertarraysize 2000
-table 'Test1'
-mode truncate
-open 'UPDATE Test1 SET name=\'Gaurav\'
## General options
[ident('ODBC_Enterprise_4'); jobmon_ident('ODBC_Enterprise_4')]
## Inputs
0< [] 'File_Set_0:DSLink2.v'
;
# End of OSH code
The job is running without any warning and without updating the record.
Please let me know the solution.
Regards
Neeraj
I am using this appraach as per my business requirement
in the director, it looks like this
#### STAGE: ODBC_Enterprise_4
## Operator
odbcwrite
## Operator options
-db_cs [&DSProjectMapName]
-data_source 'dev'
-user 'test'
-password '[&"DBPassword"]'
-insertarraysize 2000
-table 'Test1'
-mode truncate
-open 'UPDATE Test1 SET name=\'Gaurav\'
## General options
[ident('ODBC_Enterprise_4'); jobmon_ident('ODBC_Enterprise_4')]
## Inputs
0< [] 'File_Set_0:DSLink2.v'
;
# End of OSH code
The job is running without any warning and without updating the record.
Please let me know the solution.
Regards
Neeraj