I have some 3 particular fields ..i want to know which all
tables have those 3 fields. Is there any way to identify..
can we know by quering system tables..
Answer Posted / dalwinder singh--intense tech
db2 "select name ,tbname ,typeschema,source_tabname from
sysibm.syscolumns where name='coloumn name'"
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What kind of database is db2?
What do you mean by rollback?
What is catalog database in db2?
Explain the contents that are a part of dclgen.
What is a storage group (stogroup)?
How can we read records for specific member in CL? AND rpg?
What are the various data types available in db2?
What is view db2?
Is db2 a database?
Why do we need reorg in db2?
run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...
Is db2 a mainframe?
What is bind and rebind in db2?
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
What is access path in db2?