Equivalent DB2 Query for select * from tab

ysuryawanshi_mcs · Posted: Fri Mar 31, 2006 4:17 pm

could anybody tell me a query for selecting list of tables have been created.
for eg.In oracle we can write a query
select * from tab;
which list the table names which hav been created.

thanooz · New User Joined: 28 Jun 2005 Posts: 99

hi ysuryawanshi_mcs,

you can try with this query

select * from sysibm.systables;

thank's
thanooz.

ysuryawanshi_mcs · Posted: Fri Mar 31, 2006 5:57 pm

THANKS TANOOZ
CAN U TELL ME WHERE FROM WE GET SUCH TYPES QUERIES.
I MEAN ANY BOOK OR WEB .

ysuryawanshi_mcs · Posted: Fri Mar 31, 2006 6:01 pm

I WANT TO EXECUTE A COBOL WITH MAPS
I HAV DONE EXECUTION OF MAPS THEN DEFINE,INS PROGRAM
THEN DEFINE TRANS AND INS TRANS THEN HOW CAN I INITIATE MY TRANSACTION.

martin9 · Posted: Fri Mar 31, 2006 6:05 pm

hy ysuryawanshi_mcs,

the post regarding your query is correct,
but waht exactly you want to know,
reagrding your last question...?

martin9

ysuryawanshi_mcs · Posted: Fri Mar 31, 2006 6:14 pm

EXACTLY I WANT TO RUN AN APPLICATION OF ADDITION OF TWO NUMBERS USING CICS MAP

martin9 · Posted: Fri Mar 31, 2006 6:20 pm

hy ysuryawanshi_mcs,

if i undertood right,
this is not any further sql question...
you need some additional cics answer...

how you want to use a cics map for any addition...?
pls, provide more details...

martin9