Hi, is it possible for a view definition to be the following? or something like it w/o actually selecting anything from a table

SELECT 'X' FROM SYSIBM.SYSDUMMY

We basically want to make the view as fast as absolutely possible and we know the value we want it to return...Is know this is strange, but we cannot eliminate the reference to the view in many different SQLs throughout the system, so we want to alter it to almost act as a host variable value.

Thanks

defnitely possible to do this


sathyaram

CREATE VIEW MA_TRIAL (age, NAME) AS SELECT 26, 'RAHUL' FROM eone.TSYS_EXCLSN_FTRE
DB20000I The SQL command completed successfully.

select * from MA_TRIAL fetch first 1 rows only

AGE NAME
----------- -----
26 RAHUL

Hi,
SYSDUMMY does not exist, there is SYSDUMMY1. You can use for example:
Hope this helps,
Grofaty