DB2 With UR not appear in view sql section
Posted: Mon Feb 07, 2011 8:08 pm
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 (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.