I am looking for a way to quickly look through 1500+ synonym files to locate any reference to a specific table name (TABLENAME). Is there a WebFOCUS system table that stores this type of information?

Reason: When creating metadata/synonym on our mainframe we are limited to an 8-character length. Any DB2 table names longer than 8-characters have to be shortened. Unfortunately, in the past we did not have a naming convention so it was user’s choice.

This message has been edited. Last edited by: ChadSS,

ona mainframe, i don't know.
If you were on windows, you can use TEXTPAD, which is a free/cheap text editor and rocks.
the feature under the Search option is 'Find in files' which lets you search all files, by filetype or not, with or w/o wildcards in names, and subdirectories or not.
its companion, WILDEDIT, lets you change strings in a bunch of files at once. for a geek, that's about as uber-dangerous as it gets.

You might be able to write a fex for this.

There is a WebFOCUS system table called SYSTABLE that has some columns that describe all the masters in the app folders. The columns you're interested in are NAME (master names) and REALNAME (db table name). This, unfortunately, does not tell you which app folder the master is located in.

TABLE FILE SYSTABLE
PRINT
SEG.NAME

WHERE READLIMIT EQ 100
WHERE NAME LIKE 'mytables_%'
END

Thanks Francis, I'm glad to see you reply to the question. I borrow from your code examples all the time...

I'll give it a try and get back to everyone.

Worked perfectly. Thanks Francis!

here's a fex that uses two system tables to determine the master name, db name, app name:

-SET &ECHO=ALL;

SET ASNAMES=ON
SET HOLDFORMAT=ALPHA
SET HOLDLIST=PRINTONLY
SET ALL=ON
-RUN

TABLE FILE SYSTABLE
PRINT *
BY NAME
ON TABLE HOLD AS HSYSTABLE
END
-RUN

DEFINE FILE SYSFILES
APPNAME/A20 = GETTOK(PHNAME, 80, 1, '/', 20, 'A20');
END

TABLE FILE SYSFILES
PRINT
APPNAME
*
BY FILENAME
ON TABLE HOLD AS HSYSFILES
END
-RUN

JOIN NAME IN HSYSTABLE TO ALL FILENAME IN HSYSFILES AS J1
-RUN

TABLE FILE HSYSTABLE
PRINT
NAME
FILENAME
APPNAME
REALNAME

SEG.NAME
SEG.FILENAME
END

This message has been edited. Last edited by: Francis Mariani,

Also remember that SYSTABLE only works on the current APP PATH, so if you have other folders not in the path, you may have to add them with an APP APPENDPATH/PREPENDPATH

Run this procedure from the DMC:

EX IMPCTSYN SEND_TO=WCF, SYN_NAME=ggorder

Or you can just use the Impact Analysis from the DMC <== way easier!