[U2] VSG Creates Incompatible ODBC View

2010-04-05 Thread Kevin King
I have a customer who has a view that appears like this in SQL: SELECT ID,TYPE,BEGIN_DATE,END_DATE,FISCAL_PERIOD,PERIOD_OPEN FROM T_CRP_FISCAL_PERIODS UNNEST NL_ALL BEGIN_DATE,END_DATE,FISCAL_PERIOD,PERIOD_OPEN WHERE ID = 001FISCAL.PERIODS; This view, as far as I have been informed, was created

Re: [U2] VSG Creates Incompatible ODBC View

2010-04-05 Thread Anthony W. Youngman
In message j2j8c1cabce1004051146xf7980b4dzcfbaf08ab99de...@mail.gmail.com, Kevin King precisonl...@gmail.com writes I have a customer who has a view that appears like this in SQL: SELECT ID,TYPE,BEGIN_DATE,END_DATE,FISCAL_PERIOD,PERIOD_OPEN FROM T_CRP_FISCAL_PERIODS UNNEST NL_ALL