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
- 11887 Views
- CTS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / srini
select * 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
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / 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 |
Answer / rajnish kumar
SELECT R.TABSCHEMA , R.TABNAME FROM
(select TABSCHEMA,TABNAME,COLNAME from syscat.columns where
COLNAME='ROLL') R
INNER JOIN
(select TABSCHEMA,TABNAME,COLNAME from syscat.columns where
COLNAME='NAME') N
ON R.TABNAME=N.TABNAME AND R.TABSCHEMA= N.TABSCHEMA
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / apoorv sharma
Learn SQL Trace for that... Tcode is ST05.
After this u will come to know which table contain those fields
| Is This Answer Correct ? | 0 Yes | 0 No |
select name ,tbname ,typeschema,source_tabname from
sysibm.syscolumns where name='coloumn name'
This statement will work.
You can try this command also.
select tabname,colname
from syscat.columns
where COLNAME='ID'
and tabschema='MYSCHEMA'
| Is This Answer Correct ? | 0 Yes | 0 No |
What are leaf pages?
What is Declaration Generator(DCLGEN)?
Is ibm db2 open source?
what is the difference between join and union?
Mention and explain the contention situations caused by locks?
what is the differences between spufi and qmf and which is better?
4 Answers Accenture, Cap Gemini,
What is the maximum size of varchar data type in db2?
This was related to -811 sqlcode, In a COBOL DB2 program which accesses employee table and selects rows for employee 'A', it should perform a paragraph s001-x if employee 'A' is present. In this case it gets -811 sqlcode, but still it process the paragraph s001-x. What could be wrong in my code.
What are foreign keys?
how can you copy records present in a flat physical file to a database file(physical file).please explain in rpg400 with a simple example
What is an inner join, and an outer join ?
What do you mean by commit and rollback?
COBOL 
