Db2 Table

[stressman]

is there under DB2 a table that have the same as the DUAL table under Oracle

thanks for your help

 

[MarcLodge]

Not knowing Oracle I have to ask, what does the DUAL table do?

 

[Hattusas]

I was going to ask the same question :=).If u explain what it is used for it will be better. Salih Sipahi
Software Engineer.
City of Istanbul Turkey
openyourmind77@yahoo.com

 

[stressman]

it is used to get back informations stores in différents tables that i've created. thoses informations are insert by the way of the use of a sequence under Oracle.
Speaking about sequence i m not sure that sequence works undre DB2 vers 7.2

Thanks for your interest

 

[MarcLodge]

There are quite literally dozens of tables in DB2 that contain that type of information. They are all prefixed SYSIBM. and I suspect that you will need to look at a description of these in order to ascertain which one is most similar to the Oracle DUAL table.

Regards,

Marc

 

[dhecht]

the answer is sysibm.sysdummy1 which can be used when calling scalar functions.

select replace('batata','ta','na')
from sysibm.sysdummy1;

 

[stressman]

thanks dhecht
i was already using this table to get back the timestamp and i haven't try yet to get this info i will try tomorow