DSXchange

I'm writing this topic cause i didn't find any already. I have a job server in which i use one Oracle OCI to query data to be looked up with an hash file. The custom query in this OCI works fine. The hash file is created and loaded using another OCI having a custom query to a different DB than the o...

I hope to be helpful. I retrieved ROWID to be used for the update by converting it using the Oracle function RowIDToChar(ROWID) assigning it to the metadata column called ID_ROW. In the updating OCI, my custom statement is UPDATE <table_name> SET <one or more fields> WHERE ROWID = CharToRowID(ORCHES...