Hello
Is there a way to use information in a column in one table and that info is part of a table name I need to access using a select statement?

Example:
Table one contains a column of item numbers.
My next select statement would be
Select *
From xxx(item number)xx
Where ......

This on a Z/os system

Any help would be greatly appreciated

Thanks
Frank

in a single statement, that's not possible.

You need dynamic SQL for that.