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 <> ' '
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 <> ' '
Comment