Hi, i have 2 jobs which look like this.
DB2 (ODBC) > Transformer > Text File
For first job, in DB2 ODBC > Output tab > Selection > Other clauses > I put WITH UR
So in the View SQL, it will automatcially show me the SQL statement eg Select * from tableA WITH UR;
For second job, all the same but in the View SQL, it shows Select * from tableB;
I do not understand why it does not include the WITH UR in the sql statement after i add in the WITH UR in Other clauses..
Any one can help? Thanks.
DB2 With UR not appear in view sql section
Moderators: chulett, rschirm, roy
I am using ODBC data access. There is a Other Clauses, is under Selection tab..kduke wrote:I noticed in DB2 connector there is no place for Other Clauses. What is the deal?
If you select Uncommitted Read is that the same as WITH UR? It is one of the choices like Cursor Stability. ...
From the reasearch in internet, Uncommitted Read seems same as With UR, i will try it out, thanks!