Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED]Dynamic library name in .acx file
Go
New
Search
Notify
Tools
Reply
  
[SOLVED]Dynamic library name in .acx file
 Login/Join
 
Guru
posted
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,


WebFOCUS DS 8.0.06/08 DS/AS
WebFOCUS RS 8.0.08 (Linux/IBM i)
WebFOCUS Client 8.0.06 (Linux)
 
Posts: 319 | Location: Stockholm, Sweden | Registered: February 04, 2004Reply With QuoteReport This Post
Virtuoso
posted Hide Post
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


WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007
 
Posts: 2347 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013Reply With QuoteReport This Post
Master
posted Hide Post
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';




Scott

 
Posts: 865 | Registered: May 24, 2004Reply With QuoteReport This Post
Guru
posted Hide Post
Thanks guys, it seems to work. That is, if you don't use Info Assist.


WebFOCUS DS 8.0.06/08 DS/AS
WebFOCUS RS 8.0.08 (Linux/IBM i)
WebFOCUS Client 8.0.06 (Linux)
 
Posts: 319 | Location: Stockholm, Sweden | Registered: February 04, 2004Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED]Dynamic library name in .acx file

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.