insert into a table from sysibm view but at the same time we have to insert the time

thawfii88 · #1 (**permalink**) 11-28-11, 08:10

Hi Guys,,

can any one help me out ?

i need to insert values from sysibmadm.dbcfg to a table with the current timestamp. previously i had the same columns as the sys view . But i need to insert the timestamp also (where the coulumn was not defined in the view.

Thanks in advance
thawfiii

przytula_guy · #2 (**permalink**) 11-28-11, 08:36

create table xx as sysibmadm.dbcfg with additional column
insert into xx select col1,col2....,current timestamp from sysibmadm.dbcfg

thawfii88 · #3 (**permalink**) 11-30-11, 07:24

Thanks a lot

Internet Services

Web Development

Digital Marketing

Consumer Tech