topic Re: Table Name Needed in Application Development and Automation Discussions

Table Name Needed

Former Member — Wed, 25 Jul 2007 16:34:01 GMT

Hi All,

can you tell me the database table where the name of the programs (Report programs) stored? i also want other details such as last modified, date of creation etc...

i need to display a report program which shows list of all Z programs and the related attirbutes( date of creation, last modified etc,,).

is there any table which has the source of the program we create? wher are these source code stored?

i am planning to create a report which shows the difference between 2 given report programs ( z program)

Regards,

Niyaz

Re: Table Name Needed

ferry_lianto — Wed, 25 Jul 2007 16:40:03 GMT

Hi,

Please check table TRDIR.

Regards,

Ferry Lianto

Re: Table Name Needed

Former Member — Wed, 25 Jul 2007 16:40:08 GMT

Hi,

Have you checked up TRDIR, TADIR and related tables?

Best Regards, Murugesh AS

Re: Table Name Needed

Former Member — Wed, 25 Jul 2007 16:41:51 GMT

Hi Niyaz,

Table TADIR has the reports, but I am not sure if you will find there the additional data you want.

You have to acces these table with key:

Object ID = R3TR

Program type = PROG

Regards

Marcelo Moreira

Re: Table Name Needed

Former Member — Wed, 25 Jul 2007 16:48:26 GMT

check these tables you should get your desire:

TRDIR, TADIR

Re: Table Name Needed

Former Member — Wed, 25 Jul 2007 16:49:52 GMT

Hi,

Thanks. i got the table name for program. i need the table name for other attributes and source code..

Regards,

Niyaz

Re: Table Name Needed

ferry_lianto — Wed, 25 Jul 2007 16:53:01 GMT

Hi,

Please check tables REPOSRC and REPOTEXT for source code and attribute.

Regards,

Ferry Lianto

Re: Table Name Needed

Former Member — Wed, 25 Jul 2007 16:55:07 GMT

Thanks Ferry..

what abt the other questions. where can i get the program attributes?

Re: Table Name Needed

ferry_lianto — Wed, 25 Jul 2007 17:25:41 GMT

Hi,

Any specific program attributes are you looking for?

Can you give an example?

Regards,

Ferry Lianto