ibmi-brunch-learn

Announcement

Collapse
No announcement yet.

STRSQL vs opsNav Run SQL Script - result sets different??

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • STRSQL vs opsNav Run SQL Script - result sets different??

    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.
    Last edited by jayvaughn; November 22, 2017, 09:50 AM.

  • #2
    You don't by any chance have statement processing set to *VLD or *SYN in your strsql do you?

    Comment

    Working...
    X