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.
Submitted by: Administratorselect * from sysibm.syscolumns where name = <name you 3
columns here>
The above query to metadata will show you the list of table
names where these 3 columsn present
Submitted by: Administrator
columns here>
The above query to metadata will show you the list of table
names where these 3 columsn present
Submitted by: Administrator
Read Online IBM DB2 Job Interview Questions And Answers
Top IBM DB2 Questions
| ☺ | what are the bind parameters IBM DB2? |
| ☺ | What is sqlcode -811? |
| ☺ | What is sqlcode -922 ? |
| ☺ | Cursors can be declared in both working-storage & procedure |
| ☺ | Can you have more than one cursor open at any one time in a program ? |
Top Databases Programming Categories
| ☺ | RDBMS Interview Questions. |
| ☺ | SQL Interview Questions. |
| ☺ | SSRS Interview Questions. |
| ☺ | Sybase Interview Questions. |
| ☺ | Database Administrator (DBA) Interview Questions. |
