Finding a particulor column in all the Teradata tables

[irajasekharhexa]

Hi,


We are using the Teradata as Target Database. But in some tables we defined one column CUSTOMER_ID as Decimal now we want to modify as Varchar.

But we are not sure in how many and what exactly tables we have defined with the coulmn CUSTOMER_ID.

Instead of checking manually each and every job/Teradata Table

Is there any way in identifying that this particulor column using list of teradata tables?

Alternatively is there any way to Identify in which Jobs/Teradata Table we are using this CUSTOMER_ID.


Thanks in Advance

[shamshad]

Select DatabaseName, TableName, ColumnName, ColumnFormat, ColumnTitle, SPParameterType, ColumnType, ColumnUDTName, ColumnLength, DefaultValue, Nullable, CommentString, DecimalTotalDigits, DecimalFractionalDigits, ColumnId, UpperCaseFlag, Compressible, CompressValue, ColumnConstraint, ConstraintCount, CreatorName, CreateTimeStamp, LastAlterName, LastAlterTimeStamp, CharType, IdColType, AccessCount, LastAccessTimeStamp, CompressValueList
From DBC.Columns WHERE DATABASENAME='<database_name>' AND COLUMNNAME='CUSTOMER_ID'

[Anrewm]

Hi,


We are using the Teradata as Target Database. But in some tables we defined one column CUSTOMER_ID as Decimal now we want to modify as Varchar.

But we are not sure in how many and what exactly tables we have defined with the coulmn CUSTOMER_ID.

Instead of checking manually each and every job/Teradata Table

Is there any way in identifying that this particulor column using list of teradata tables?

Alternatively is there any way to Identify in which Jobs/Teradata Table we are using this CUSTOMER_ID.


Thanks in Advance

If you need to look at the Jobs in DS, export the jobs / project into a dsx file and you can search for the CUSTOMER_ID field. If you have a advanced text editor like ultraedit you can infact count all the occurances of that particular field in the file.

Anrew

[Anrewm]

Hi,


We are using the Teradata as Target Database. But in some tables we defined one column CUSTOMER_ID as Decimal now we want to modify as Varchar.

But we are not sure in how many and what exactly tables we have defined with the coulmn CUSTOMER_ID.

Instead of checking manually each and every job/Teradata Table

Is there any way in identifying that this particulor column using list of teradata tables?

Alternatively is there any way to Identify in which Jobs/Teradata Table we are using this CUSTOMER_ID.


Thanks in Advance

If you need to look at the Jobs in DS, export the jobs / project into a dsx file and you can search for the CUSTOMER_ID field. If you have a advanced text editor like ultraedit you can infact count all the occurances of that particular field in the file.

Anrew

[irajasekharhexa]

Thanks lot.

It's solved the Issue.