Question Finding, Where This Table Is Created?

[Carlo H. Francisco]

Hello Guys,

How to find this table, where does this table created? The system is too big.

 

[TomBascom]

find . -name "*.[ipw]" -exec grep -i create {} | grep -i tablename \;

 

[Carlo H. Francisco]

Thanks Mr. Tom,

Where will I put this code? In a procedure?
I am looking for table_crb.

 

[KrisM]

Don't forget .cls files if you have any

 

[Carlo H. Francisco]

Hey krism,

How? to find? five me an example krism please..

 

[Osborne]

If the table is not being created dynamically, another possible option would be to use RCODE-INFO. From this you can get a list of tables that are used in compiled files (.r), and although it will not tell you what program created it hopefully it will reduce the programs to check. The following reads all .r files in a specified directory and reports the program if the table was used:

DEFINE VARIABLE vCount AS INTEGER NO-UNDO.
DEFINE VARIABLE vFileName AS CHARACTER NO-UNDO.
DEFINE VARIABLE vFileType AS CHARACTER NO-UNDO.
DEFINE VARIABLE vFullPath AS CHARACTER NO-UNDO.
DEFINE VARIABLE vTableList AS CHARACTER NO-UNDO.

DEFINE STREAM sImport.
DEFINE STREAM sExport.

OUTPUT STREAM sExport TO "C:\Temp\ProgsContainingTable.txt".

INPUT STREAM sImport FROM OS-DIR("C:\Progress\Progs").
REPEAT:
    IMPORT STREAM sImport vFileName vFullPath vFileType.
    IF INDEX(vFileType, "F") > 0 AND vFileName MATCHES "*~~.r" THEN DO:
       ASSIGN RCODE-INFO:FILE-NAME = vFullPath
              vTableList = RCODE-INFO:TABLE-LIST.
       IF vTableList MATCHES "*table_crb*" THEN
          PUT STREAM sExport vFileName SKIP.
    END.
END.
INPUT STREAM sImport CLOSE.
OUTPUT STREAM sExport CLOSE.

 

[Carlo H. Francisco]

Thanks osborne,

But it say unknown attribute TABLE-LIST
Error on line 17?

 

[Osborne]

What version of Progress are you on? RCODE-INFO:TABLE-LIST is available in version 10 and thought it was also available for version 9? If not and you are earlier than version 10 then unfortunately this option is not available for you.

 

[TomBascom]

Thanks Mr. Tom,

Where will I put this code? In a procedure?
I am looking for table_crb.

It is a command line. You run it from the OS prompt while in the top level directory of your application source tree.

 

[tamhas]

ABL2DB answers these sorts of questions.
ABL2DB - Databasing ABL information for Analysis | The OpenEdge Hive

 

[GregTomkins]

I believe none of these solutions will work if you use dynamic queries. To be "guaranteed" to catch "everything", you can use session triggers. You don't need to have, or to modify, your source code although you would need to add code to establish the triggers somewhere. Realistically, it may or may not be practical depending on your environment.

 

[Carlo H. Francisco]

grep is not recognized in os-command why sir?

-caloy

 

[Cringer]

What OS are you on?

 

[TomBascom]

"grep" is THE prototypical UNIX tool. You'd have to have a very messed up install to lack it. Therefore I assume you must be running some horribly crippled environment such as Windows.

You have my sympathies.

 

[TheMadDBA]

On windows there are thousands of ways to find the code (editors that allow you to search files, findstr, etc).

ABL2DB will tell you where the references are for all of your non dynamic code (and some for the dynamic ones). You could try searching and compiling with XREF, but that work has already been done for you by The Doctor.