i'm running a simple sql statement in STRSQL...
select bankac from LDATAJ08.bankmast
where bankac = '1001-00384-5'
no result set is produced, though there are two rows that meet the criteria...
I run the same statement in opsNav Run sql script on same system for same user profile... it produces the 2 rows that meet the criteria...
why?
when i do run and explain in opsNav it choosed index BANKMAST05...
when i debug STRSQL, it says...
**** Starting optimizer debug message for query .
The query access plan has been rebuilt.
All access paths were considered for file BANKMAST.
Arrival sequence access was used for file BANKMAST.
**** Ending debug message for query .
ODP created.
Blocking used for query.
select bankac from LDATAJ08.bankmast
where bankac = '1001-00384-5'
no result set is produced, though there are two rows that meet the criteria...
I run the same statement in opsNav Run sql script on same system for same user profile... it produces the 2 rows that meet the criteria...
why?
when i do run and explain in opsNav it choosed index BANKMAST05...
when i debug STRSQL, it says...
**** Starting optimizer debug message for query .
The query access plan has been rebuilt.
All access paths were considered for file BANKMAST.
Arrival sequence access was used for file BANKMAST.
**** Ending debug message for query .
ODP created.
Blocking used for query.
Comment