All, we are running WebFOCUS for JDE Enterprise One on IBM i. Is there any possibility to point to the correct library without hard-coding it in the .acx file? (yes, we are having multiple tables with the same name in different libraries).

Tia
Håkan

This message has been edited. Last edited by: Håkan,

Don't know if it will work in your case, but in mine it does with AS400/DB2-400 IBM iSeries :

acx :
 SEGNAME=TBLNAME, TABLENAME=&&LIB/TBLNAME, CONNECTION=DB2, KEYS=0, $

mas :
FILENAME=TBLNAME, SUFFIX=DB2     , MFD_PROFILE=usual_modules/bidon, $
 VARIABLE NAME=&&LIB,  $
  SEGMENT=TBLNAME, SEGTYPE=S0, $
    FIELDNAME=REGION, ALIAS=REGION, USAGE=A3, ACTUAL=A3, $

fex:
-* File BIDON.fex
-* FEX BIDON USE IN MASTER AS MFD
-*

Then just need to assign &&LIB prior to do your TABLE FILE

-SET &&LIB = 'MYLIB';
TABLE FILE TBLNAME
BY REGION
END

Yes, you can define parameters in master file and the use then in master or acx files.

EXAMPLE:

IN ACX
TABLENAME=&&VMS2DBNAME

IN MAS
VARIABLE NAME=&&VMS2DBNAME,

in fex before TABLE REQUEST
-SET &&VMS2DBNAME = 'SOME VALUE';