I need to update a oracle table from datastage routine. After going through earlier messages in this forum, I tried running the following routine:
Code: Select all
strLogin = DBUser : "/" : DBPwd : "@" : DBSid
strUpdate = "update myschema.mytable set myflag= 'Y' where mycolumn ='" :DSJob:"';"
Call DSExecute('UNIX','echo "': strUpdate : '" | sqlplus ' : strLogin, Output, SystemReturnCode)
Ans = Output:' =':SystemReturnCode
Code: Select all
'echo "': strUpdate : '" | sqlplus ' : strLogin
I don't know what am I missing here. Datastage and Oracle are on different servers. Any hints would be really helpful and I appreciate it.
Thank You,
Gregg