Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Display all variables

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED] Display all variables
 Login/Join
 
Member
posted
I learned yesterday from njsden about the SAVEPRINT option but it does not display all of the variables see the output below.

-? & ;
-TYPE ============================
-? & SAVEPRINT
  


  
CURRENTLY DEFINED & VARIABLES:
 &ACCEPTS      =        0
 &APPROOT      = C:\ibi\apps
 &AUTOINDEX    = NO
 &BASEIO       =        0
 &CHNGD        =        0
 &DATE         = 12/06/13
 &DBMSERR      =        0
 &DEBUG        = TRUE
 &DELTD        =        0
 &DMY          = 061213
 &DMYY         = 06122013
 &DUPLS        =        0
 &ECHO         = OFF
 &EXCELSERVURL = SET EXCELSERVURL=http://localhost:8080/ibi_apps
 &FOCEXURL     = /ibi_apps/WFServlet?IBIF_webapp=/ibi_apps&IBIC_server=EDASERV
 &FOCFEXNAME   = TEST
 &FOCFOCEXEC   = _Test
 &FOCGRAPHCNT  =        0
 &FOCHTMLURL   = /ibi_html
 &FOCINCLUDE   = TEST
 &FOCNEXTPAGE  =        0
 &FOCREL       = R727703B
 &FORMAT       =        0
 &GOOGLEMAPSAP>=
 &HrpSmtpServe>= '127.0.0.1'
 &HrpSmtpServe>= 125
 &IBIC_server  = EDASERVE
 &IBIC_user    = CramerS
 &IBIMR_domain =
 &IBIMR_fex    =
 &IBIMR_folder =
 &IBIMR_user   =
 &IBIWF_LANGPE>=
 &IBIWF_langua>= en
 &IBI_REPORT_S>= EDASERVE
 &INDEXIO      =        0
 &INPUT        =        0
 &INVALID      =        0
 &LINES        =        0
 &MDY          = 120613
 &MDYY         = 12062013
 &MR_BASE_DIR  =  /basedir
 &NOMATCH      =        0
 &READS        =        0
 &RECORDS      =        0
 &REJECTS      =        0
 &SETFILE      =
 &SORTIO       =        0
 &TOD          = 08.30.32
 &TRANS        =        0
 &WFDESCRIBE   = XMLRUN
 &YMD          = 131206
 &YYMD         = 20131206
 ============================
 -*CURRENTLY DEFINED VARIABLES:
 -SET     &DEBUG = 'TRUE';
 -DEFAULT &ECHO = 'OFF ';
 -SET     &EXCELSERVURL = 'SET EXCELSERVURL=http://localhost:8080/ibi_apps';
 -SET     &FOCEXURL = '/ibi_apps/WFServlet?IBIF_webapp=/ibi_apps&|IBIC_server=EDASERVE&|IBIWF_msgviewer=OFF&|IBIAPP_app=cramersworld cramersworld kouriermeta salesiqu baseapp&|';
 -SET     &FOCHTMLURL = '/ibi_html';
 -SET     &FOCREL = R727703B;
 -SET     &GOOGLEMAPSAPIKEY = ' ';
 -SET     &HrpSmtpServer = '''127.0.0.1''';
 -SET     &HrpSmtpServerPort = '125';
 -SET     &IBIC_server = 'EDASERVE';
 -SET     &IBIC_user = 'CramerS';
 -SET     &IBIMR_domain = ' ';
 -SET     &IBIMR_fex = ' ';
 -SET     &IBIMR_folder = ' ';
 -SET     &IBIMR_user = ' ';
 -SET     &IBIWF_LANGPERM = ' ';
 -SET     &IBIWF_language = 'en';
 -SET     &IBI_REPORT_SERVER = 'EDASERVE';
 -SET     &MR_BASE_DIR = ' /basedir';
 -SET     &WFDESCRIBE = XMLRUN;




What I would like to do is to be able to display something like the following for all variables

 Name: &CurrentDateInternal                     Value: 41248                                                                                                Type: N Length: 05;
 Name: &CurrentDate                             Value: 20131206                                                                                             Type: N Length: 08;
 Name: &LastDayOfMonthInternal                  Value: 41273                                                                                                Type: N Length: 05;
 Name: &LastDayOfMonthDate                      Value: 20131231                                                                                             Type: N Length: 08;
 Name: &LastDayOfYearInternal                   Value: 41273                                                                                                Type: N Length: 05;
 Name: &LastDayOfYearDate                       Value: 20131231                                                                                             Type: N Length: 08;
 Name: &OneMonthAgoInternal                     Value: 41218                                                                                                Type: N Length: 05;
 Name: &OneMonthAgoDate                         Value: 20131106                                                                                             Type: N Length: 08;
 Name: &OneQuarterAgoInternal                   Value: 41157                                                                                                Type: N Length: 05;
 Name: &OneQuarterAgoDate                       Value: 20130906                                                                                             Type: N Length: 08;
 Name: &OneYearAgoInternal                      Value: 40883                                                                                                Type: N Length: 05;
 Name: &OneYearAgoDate                          Value: 20121206                                                                                             Type: N Length: 08;
 Name: &LastDayOfPreviousMonthInternal          Value: 41242                                                                                                Type: N Length: 05;
 Name: &LastDayOfPreviousMonthDate              Value: 20131130                                                                                             Type: N Length: 08;
 Name: &CurrentDayOfMonth                       Value: 06                                                                                                   Type: N Length: 02;
 Name: &CurrentMonthOfYear                      Value: 12                                                                                                   Type: N Length: 02;
 Name: &CurrentYear                             Value: 2013                                                                                                 Type: N Length: 04;
 Name: &PreviousYear                            Value: 2012                                                                                                 Type: N Length: 04;
 Name: &PreviousMonth                           Value: 11                                                                                                   Type: N Length: 02;
 Name: &FiscalYearStartingMonth                 Value: 11                                                                                                   Type: N Length: 02;
 Name: &FiscalYearStartingDay                   Value: 1                                                                                                    Type: N Length: 01;
 Name: &FiscalYearConvention                    Value: FYE                                                                                                  Type: A Length: 03;
 Name: &CurrentFiscalYear                       Value: 2014                                                                                                 Type: N Length: 04;
 Name: &CurrentFiscalQuarter                    Value: 1                                                                                                    Type: N Length: 01;
 Name: &CurrentFiscalYearStartDate              Value: 20131101                                                                                             Type: N Length: 08;
 Name: &CurrentFiscalYearStartInternal          Value: 41213                                                                                                Type: N Length: 05;
 Name: &PreviousFiscalYearStartInternal         Value: 40848                                                                                                Type: N Length: 05;
 Name: &PreviousFiscalYearStartDate             Value: 20121101                                                                                             Type: N Length: 08;
 Name: &PreviousFiscalYear                      Value: 2013                                                                                                 Type: N Length: 04;
 Name: &PreviousFiscalQuarter                   Value: 4                                                                                                    Type: N Length: 01;
 Name: &CurrentDateDashed                       Value: 1995                                                                                                 Type: A Length: 10;
 Name: &LastDayOfMonthDateDashed                Value: 1970                                                                                                 Type: A Length: 10;
 Name: &OneMonthAgoDateDashed                   Value: 1996                                                                                                 Type: A Length: 10;
 Name: &OneYearAgoDateDashed                    Value: 1994                                                                                                 Type: A Length: 10;
 Name: &LastDayOfPreviousMonthDateDashed        Value: 1972                                                                                                 Type: A Length: 10;


  


Currently I do this by displaying them one at a time but if I could get the collection to work it would be so much better. See post http://forums.informationbuild...1057331/m/3307000536

Any help would be great. Thanks!

This message has been edited. Last edited by: <Kathryn Henning>,


7.7.03, Windows
HTML, Excel, PDF,
 
Posts: 13 | Registered: October 07, 2013Report This Post
Virtuoso
posted Hide Post
Steven, based on the list of variables you want to display it seems to me that they are all application-specific variables and so they should show up when using SAVEPRINT if available in your session. Did you actually try and they didn't show?



Prod/Dev: WF Server 8008/Win 2008 - WF Client 8008/Win 2008 - Dev. Studio: 8008/Windows 7 - DBMS: Oracle 11g Rel 2
Test: Dev. Studio 8008 /Windows 7 (Local) Output:HTML, EXL2K.
 
Posts: 1533 | Registered: August 12, 2005Report This Post
Member
posted Hide Post
Correct as above they are NOT the same.


7.7.03, Windows
HTML, Excel, PDF,
 
Posts: 13 | Registered: October 07, 2013Report This Post
Virtuoso
posted Hide Post
quote:
Originally posted by StevenTCramer:
Correct as above they are NOT the same.


Yes, that had already been established but it wasn't my question.

Forget about WebFOCUS internal variables for now (&YYMD, &INVALID, &LINES, READS, etc.) which we already saw SAVEPRINT does not display.

What I want to know is if YOUR specific application variables, the ones I assume you really care about (&CurrentDateInternal, &CurrentDate, &CurrentYear, etc.) get displayed when using SAVEPRINT?

My guess is that they are indeed displayed and in that case it should be okay for you to use SAVEPRINT and capture their values. The fact that WebFOCUS "internal" variables are not displayed using SAVEPRINT should be irrelevant but I don't know what the purpose of your application is and it would be silly for me to make assumptions as to what your requirements are, so as I said in your other post about the same issue, if you need ALL available variables (both WebFOCUS' and yours) you know what -? & and -? & SAVEPRINT each can do for you so you'll have to capture both sets of results and find a way to merge them somehow.



Prod/Dev: WF Server 8008/Win 2008 - WF Client 8008/Win 2008 - Dev. Studio: 8008/Windows 7 - DBMS: Oracle 11g Rel 2
Test: Dev. Studio 8008 /Windows 7 (Local) Output:HTML, EXL2K.
 
Posts: 1533 | Registered: August 12, 2005Report This Post
Member
posted Hide Post
njsden,

Good point. They ones I most care about do display. Thanks.

The IBI ones I can live without for my purposes.


7.7.03, Windows
HTML, Excel, PDF,
 
Posts: 13 | Registered: October 07, 2013Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Display all variables

Copyright © 1996-2020 Information Builders