Just getting on with the SQLBlockFetch and everything works great except for the lack of return of SQL literals.
For instance:
Select FNAME as FirstName, LNAME as LastName, 'Manager' as Type, RPRTSTO as ReportsTo
From EMP WHERE EMPTYPE = 'M'
UNION ALL
Select FNAME as FirstName, LNAME as LastName, 'Employee' as Type, RPRTSTO as ReportsTo
From EMP WHERE EMPTYPE = 'E'
Order by Type, LastName, FirstName
The values for all the columns come back except for the literal column (Type). Anyone ever try something like this with the SQLBlockFetch Pattern?