CREATE SQL VIEW V_HOLSSTD_ALL AS ; > SELECT Holsstd.s_key, ; > Holsstd.descr, ; > Holsstd.day, ; > Holsstd.htype, ; > Holsstd.month, ; > Holsstd.dow, ; > Holsstd.wom, ; > Holsstd.adjust, ; > Holsstd.country, ; > Holsstd.region, ; > Holsstd.active, ; > CAST(IIF(day>0, day, wom*10+dow) AS N(2)) AS seq ; > FROM wots!holsstd ; > ORDER BY Holsstd.month, 12>
CREATE SQL VIEW V_HOLSSTD_ALL REMOTE CONNECTION rWots SHARE AS ; > SELECT Holsstd.s_key, ; > Holsstd.descr, ; > Holsstd.day, ; > Holsstd.htype, ; > Holsstd.month, ; > Holsstd.dow, ; > Holsstd.wom, ; > Holsstd.adjust, ; > Holsstd.country, ; > Holsstd.region, ; > Holsstd.active, ; > CAST(IIF(day>0, day, wom*10+dow) AS N(2)) AS seq ; > FROM wots!holsstd ; > ORDER BY Holsstd.month, 12>