ibmi-brunch-learn

Announcement

Collapse
No announcement yet.

Navigator vs. green screen

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

  • Navigator vs. green screen

    Anyone heard of any differences in running Ops Nav and green screen query for the same query (for V5R4, maybe a PTF issue)?? I am running the same query (have been verified by multiple people which returns a result set on green screen but returns no result set in Nav. The where clause seems to be the culprit because when I comment out in Nav it returns a result set, here is the query:

    select str.strttynum,str.strcrgnnum,sales.weekid, item.skunumber, sales.custtype,
    str.strdsdid,sales.store_id,sales.sku_id,
    from lib1/dwstskwrk as sales
    join lib2/dwstrd as str
    on str.strid = sales.store_id
    join lib2/dwskud as item
    on sales.sku_id = item.skuid
    where str.strttynum <> ' ' and str.strcrgnnum <> ' '
    Golf is a game in which you yell "fore," shoot six, and write down five.

  • #2
    Re: Navigator vs. green screen

    select str.strttynum,str.strcrgnnum,sales.weekid, item.skunumber, sales.custtype,
    str.strdsdid,sales.store_id,sales.sku_id,
    from lib1/dwstskwrk as sales
    join lib2/dwstrd as str
    on str.strid = sales.store_id
    join lib2/dwskud as item
    on sales.sku_id = item.skuid
    where str.strttynum <> ' ' and str.strcrgnnum <> ' '
    This is obviously a typo, but I have a flair for stating the obvious.
    There is a comma after the last field name and before the "From". This could not possibly run in either STRSQL or iNav. And it can't possibly be part of the problem you're having, so I have no idea why I even brought it up!
    "Time passes, but sometimes it beats the <crap> out of you as it goes."

    Comment


    • #3
      Re: Navigator vs. green screen

      I have found a few minor differences, usually caused by the fact that OpsNav runs in a different subsystem than green screen. But i don't see why that would be different here.

      Have you tried where str.strttynum > ' ' and str.strcrgnnum > ' '

      Or changing the select to something other than blanks ? What about 2 quotes with no space between ? Just guessing here.

      Comment

      Working...
      X