Hi,

Can any one help me how to get meta data informations about the joins for joining two or more master files??
I Need to get Information which master files are joined..
I tried to search in Syscolumn table but i coudnt find any.
Thanks a lot in advance.

Thanks,
Nel

This message has been edited. Last edited by: <Emily McAllister>,

Try

CHECK FILE FILENAME PICT
-RUN

Hi,

in this check file it works and i can see it.
Is this Information stored as well in some System table where i can query it??
Because i Need this Information in form of table for exporting.

Thanks many,
Nel

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

quote:

Is this Information stored as well in some System table where i can query it??
Because i Need this Information in form of table for exporting.

No Idea about this

But, you can see the Master file in synonym editor.

You can retrieve Master metadata using the SYSCOLUMN table, unfortunately, it appears this is static - JOINs are not considered:

JOIN CLEAR *
JOIN STORE_CODE IN GGORDER TO ALL STORE_CODE IN GGSTORES AS J1
-RUN

?FF GGORDER
-RUN

TABLE FILE SYSCOLUM
PRINT
NAME
WHERE TBNAME EQ 'GGORDER'
END
-RUN

Hi

Try the following:

JOIN CLEAR *
JOIN STORE_CODE IN GGORDER TO ALL STORE_CODE IN GGSTORES AS J1
-RUN
CHECK FILE GGORDER HOLD AS ABC

TABLE FILE ABC
PRINT *
END

Nice! I keep forgetting about CHECK ... HOLD ...

quote:

OIN CLEAR *
JOIN STORE_CODE IN GGORDER TO ALL STORE_CODE IN GGSTORES AS J1
-RUN
CHECK FILE GGORDER HOLD AS ABC

TABLE FILE ABC
PRINT *
END

Thanks Nelvina for asking this good question. I learn something interesting .

Good way to store Join info in Hold format !!

quote:

way to store Join info in Hold format

Hi Eran, Francis Mariani, Neelima,

Thanks a lot for your Support.

Do you have any idea how can i get the same Information about the joins from Oracle in Check file.

Thanks,
Nel

quote:

Do you have any idea how can i get the same Information about the joins from Oracle in Check file.

Its Generic code for all database master file

Am I right Eran?

-Neelima

Hi

Yes, this is generic code for any type of master file

Documentation can be found in:
Check File

Yours

Eran

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

Thanks Eran :-)

Hi,

How can i get definitions for static joins from Business view??
I cannout find it in check file or SYSCOLUMN table.

Thanks many for your Support.
Nel

Please see the below link

http://infocenter.informationb...source%2Ftopic83.htm