Always involved in IT management. Experience in service costing, IT metrics, capacity planning, general ETL activities, data cleansing and normalization. Sas user for over 30 years.
@Babloo - the post was about SQL Server and you are assuming the same technique will work in DB2? Working out how to do this in DB2 is as simple as googling "how to list tables in db2". That is how I found this useful link:
https://chartio.com/resources/tutorials/how-to-list-tables-in-ibm-db2/
Now you can try the recommended way like this:
proc sql noprint;
connect to db2 (datasrc=db2gtu authdomain=DB2AuthODS
connection=global);
create table DB_Tables as
select * from connection to db2
(SELECT
*
FROM
SYSIBM.SYSTABLES
WHERE
type = 'T';
);
quit;
... View more
