Etiqueta: iseries

select * from qsys2.sysprocs as pwhere upper(‘ProcedureName’) in (p.specific_name, p.routine_name, p.external_name)order by specific_name

select table_schema, table_name, system_table_name from qsys2.systableswhere UPPER(‘TableName’) IN (table_name, system_table_name)