[cgamboa@gridui01 ~/frontapi]$ ls bin expat frontier_client__2.4.7_cms__gcc_3.2.3.tar.gz include lib README RELEASE_NOTES upsThe scripts that come with the Frontier client API were initially desinged at Fermilab. However, the script title as "fn-req" was used to retrieve queries to the Oracle database. To use this script correctly the Frontier BNL proxy and the Frontier server need to be specified on the environment variables of the client session as:
[cgamboa@gridui01 bin]$ setenv LD_LIBRARY_PATH /direct/usatlas+u/cgamboa/frontapi/lib setenv FRONTIER_SERVER1 http://gridui01.usatlas.bnl.gov:8080/FrontierBNL setenv FRONTIER_PROXY1 http://gridui01.usatlas.bnl.gov:3128 setenv FRONTIER_LOG_LEVEL debugOnces the environment variables have been defined the fn-req script can be deployed as:
[cgamboa@gridui01 bin]$ ./fn-req -f test_query.sqlWhere fn-req -f is the script name that is specified to read its imput from the file test_query.sql. This file will include a SQL query to be retrieved.
Please note that this site is a content mirror of the BNL USATLAS TWiki. To edit the content of this page, click the Edit this page button at the top of the page and log in with your BNL USATLAS account.