Index which table??????????

Hello,
dbdef utility will provide you that information.

Through dbdef utility we can find index corresponding to a table. we cannot find table corresponding to particular index. When we use dbdef utility we can have enter the table name as it is mandatory than only its coresponding index will be shown!!!!!!!!!!!!!!!!
I know through dbdoc we can find out the realtionship but it lists entire index for the tables used !!!!!!!!!!!!!!!

In LID use rngdbdump using filedef in GEN. Ex:

rngdbdump -c GEN FILEDEF -v PREFIX=EMP|lashow


PREFIXes are unique to tables and indexes.

If you have no access to rngdbdump then use sql tools or look at the data dictionary in this forum.

Any index that begins with the same prefix as the table belongs to that table. For instance, the prefix for the EMPLOYEE table is EMP. Therefore any index that begins with EMP belongs to the EMPLOYEE table. Indices are in the syntax of prefix|SET|# so that EMPSET1, EMPSET2, etc are indices to the EMPLOYEE table. The SET1 index is always the primary index that allows no duplicate keys.

Naming table index based on table prefix is a Lawson standard way (i.e., EMPLOYEE Table, Prefix = EMP, Index = EMPSET1) but in dbdef utility you can define a table with prefix 'LAW' and create an index for that table called 'ZZZSET1'. The utility will not force you to name your index as 'LAWSET1'. The most accurate way to find the index of the table is to dump the FILEIND table in GEN. Run the ff command in LID and search for the index name and you will see the corresponding filename using it:

rngdbdump -t gen fileind | lashow


Arvin Ojales

Thanx to all of you for your suggestions!!!!!!!!!!
I got it !!!!!!!!!!!!!!!

You can use the command laenv and call the table for that particular system