Netezza search database.sql

select * from (
select 'TRAINING' DB_NAME,'INT_SAMPLE_SALES' TABLE_NAME,'MONTH_ID' COLUMN_NAME,sum(sign(nvl(instr(MONTH_ID,'my_search_string'),0))) ROWS_COUNT from TRAINING..INT_SAMPLE_SALES
 union all select 'TRAINING' DB_NAME,'INT_SAMPLE_SALES' TABLE_NAME,'SALE_QTY' COLUMN_NAME,sum(sign(nvl(instr(SALE_QTY,'my_search_string'),0))) ROWS_COUNT from TRAINING..INT_SAMPLE_SALES
 union all select 'TRAINING' DB_NAME,'MERGE_DEMO1' TABLE_NAME,'FIRSTNAME' COLUMN_NAME,sum(sign(nvl(instr(FIRSTNAME,'my_search_string'),0))) ROWS_COUNT from TRAINING..MERGE_DEMO1
 union all select 'TRAINING' DB_NAME,'MERGE_DEMO1' TABLE_NAME,'ID' COLUMN_NAME,sum(sign(nvl(instr(ID,'my_search_string'),0))) ROWS_COUNT from TRAINING..MERGE_DEMO1
 union all select 'TRAINING' DB_NAME,'MERGE_DEMO1' TABLE_NAME,'LASTNAME' COLUMN_NAME,sum(sign(nvl(instr(LASTNAME,'my_search_string'),0))) ROWS_COUNT from TRAINING..MERGE_DEMO1
 union all select 'TRAINING' DB_NAME,'MERGE_DEMO2' TABLE_NAME,'FIRSTNAME' COLUMN_NAME,sum(sign(nvl(instr(FIRSTNAME,'my_search_string'),0))) ROWS_COUNT from TRAINING..MERGE_DEMO2
 union all select 'TRAINING' DB_NAME,'MERGE_DEMO2' TABLE_NAME,'ID' COLUMN_NAME,sum(sign(nvl(instr(ID,'my_search_string'),0))) ROWS_COUNT from TRAINING..MERGE_DEMO2
 union all select 'TRAINING' DB_NAME,'MERGE_DEMO2' TABLE_NAME,'LASTNAME' COLUMN_NAME,sum(sign(nvl(instr(LASTNAME,'my_search_string'),0))) ROWS_COUNT from TRAINING..MERGE_DEMO2
 union all select 'TRAINING' DB_NAME,'PATIENT_1' TABLE_NAME,'ID' COLUMN_NAME,sum(sign(nvl(instr(ID,'my_search_string'),0))) ROWS_COUNT from TRAINING..PATIENT_1
 union all select 'TRAINING' DB_NAME,'PATIENT_1' TABLE_NAME,'NAME' COLUMN_NAME,sum(sign(nvl(instr(NAME,'my_search_string'),0))) ROWS_COUNT from TRAINING..PATIENT_1
 union all select 'TRAINING' DB_NAME,'PATIENT_2' TABLE_NAME,'ID' COLUMN_NAME,sum(sign(nvl(instr(ID,'my_search_string'),0))) ROWS_COUNT from TRAINING..PATIENT_2
 union all select 'TRAINING' DB_NAME,'PATIENT_2' TABLE_NAME,'NAME' COLUMN_NAME,sum(sign(nvl(instr(NAME,'my_search_string'),0))) ROWS_COUNT from TRAINING..PATIENT_2
 union all select 'TRAINING' DB_NAME,'SAMPLE_SALES' TABLE_NAME,'MONTH_ID' COLUMN_NAME,sum(sign(nvl(instr(MONTH_ID,'my_search_string'),0))) ROWS_COUNT from TRAINING..SAMPLE_SALES
 union all select 'TRAINING' DB_NAME,'SAMPLE_SALES' TABLE_NAME,'SALE_QTY' COLUMN_NAME,sum(sign(nvl(instr(SALE_QTY,'my_search_string'),0))) ROWS_COUNT from TRAINING..SAMPLE_SALES
 union all select 'TRAINING' DB_NAME,'SAMPLE_TBL' TABLE_NAME,'ID' COLUMN_NAME,sum(sign(nvl(instr(ID,'my_search_string'),0))) ROWS_COUNT from TRAINING..SAMPLE_TBL
 union all select 'TRAINING' DB_NAME,'SAMPLE_TBL' TABLE_NAME,'NAME' COLUMN_NAME,sum(sign(nvl(instr(NAME,'my_search_string'),0))) ROWS_COUNT from TRAINING..SAMPLE_TBL
 union all select 'TRAINING' DB_NAME,'STUDENTS' TABLE_NAME,'CLASS' COLUMN_NAME,sum(sign(nvl(instr(CLASS,'my_search_string'),0))) ROWS_COUNT from TRAINING..STUDENTS
 union all select 'TRAINING' DB_NAME,'STUDENTS' TABLE_NAME,'COUNT' COLUMN_NAME,sum(sign(nvl(instr(COUNT,'my_search_string'),0))) ROWS_COUNT from TRAINING..STUDENTS
 union all select 'TRAINING' DB_NAME,'STUDENTS' TABLE_NAME,'PASS_FAIL' COLUMN_NAME,sum(sign(nvl(instr(PASS_FAIL,'my_search_string'),0))) ROWS_COUNT from TRAINING..STUDENTS
 union all select 'TRAINING' DB_NAME,'STUDENTS' TABLE_NAME,'SECTION' COLUMN_NAME,sum(sign(nvl(instr(SECTION,'my_search_string'),0))) ROWS_COUNT from TRAINING..STUDENTS
 union all select 'TRAINING' DB_NAME,'TEST123' TABLE_NAME,'COL1' COLUMN_NAME,sum(sign(nvl(instr(COL1,'my_search_string'),0))) ROWS_COUNT from TRAINING..TEST123
 union all select 'TRAINING' DB_NAME,'TEST_STRING' TABLE_NAME,'MY_STRING' COLUMN_NAME,sum(sign(nvl(instr(MY_STRING,'my_search_string'),0))) ROWS_COUNT from TRAINING..TEST_STRING
) a where ROWS_COUNT > 0;