Interested to Buy Any Domain ? << Click Here >> for more details...
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..
- 5 Answers
- 11851 Views
- CTS, I also Faced
- E-Mail Answers
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 is 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 ?...
What is dbrm? What it contains?
Name the various locking levels available?
Why db2 is called db2?
Is db2 a mainframe?
What is db2 connect?
What types of tables are there in the db2 database?
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
What do you mean by rollback?
What is package in cobol db2?
What is a storage group (stogroup)?
Explain packages.
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
How do you select a row using indexes in db2?
