RE: [sqr-users] How do I use a variable file path for flat files?

[Franck Masson <Franck_Masson@Hyperion.com>]

Hi,

you can either pass your path as a parameters of your sqr program
or retreive this path from Unix shell variable
look to the ask command for Input parameters
and look to getenv()function to retreive a value of Unix variable

Franck,

-----Original Message-----
From: sqr-users-bounces+franck.masson=brio.com@sqrug.org
[mailto:sqr-users-bounces+franck.masson=brio.com@sqrug.org]On Behalf Of
Jae Lee
Sent: lundi 5 avril 2004 23:05
To: sqr-users@sqrug.org
Subject: [sqr-users] How do I use a variable file path for flat files?


Hi,

In my SQR(v. 6.2) programs I've been hard-coding the directory and file 
names when I read from or write to flat files. (for ex.    let 
$outfilename = '/u02/sct/banner/banHRPROD/asu/export/sis/UppsDemogra.txt'
open $outfilename as 1 for-writing...)

  We have Oracle 8.x db that runs on a UNIX machine.  This is obviously 
not a desirable solution... When I move my SQR programs from TEST to 
PROD, the DBA has to change the file path in the program... If I can 
define the file path and name for flat files just like the report files 
in the UNIX shell script that runs SQR program, it would be great!  Can 
I do this, and if I can, how?  Below is how I name the report files in a 
shell script:

#
# Define files
#
DD_PRNT01=$HOME/pzrlbec_$$.lis ; export DD_PRNT01
DD_PRNT02=$HOME/pzrlbec_$$_01.log ; export DD_PRNT02
DD_PRNT03=$HOME/pzrlbec_$$_02.lis ; export DD_PRNT03
....
#
# Run the program
#
$SQRDIR/sqr $EXEDIR/pzrlbec.sqt [db connection string] -RT -F$DD_PRNT01 
-F$DD_PRNT02 -F$DD_PRNT03 $3 | tee $LOGFILE

but I know this -F argument is for report files only....

As an alternative, If I can somehow pass our ban$ORACLE_SID 
environmental variable to the SQR program, that will work!

I'd appreciate any help I can get on this.... I am new to UNIX, Oracle 
and SQR...  Thank you folks!

-- jae

.:*~*:._.:*~*:._.:*~*:._.:*~*:._.:*~*:._.:*~*:._.:*~*:._.:*~*:._.:*~*:.

                            +=================================+
   ,-~~-.___.               |           Jae S. Lee            |          
   / |  '     \             |      Applications Analyst       |           
  (  )        0             | Information Technology Services |             
   \_/-, ,----'             |      Room 1109 Raley Hall       |   
      ====           //     |  Appalachian State University   |

     /  \-'~;    /~~~(O)    |         Boone, NC 28608         |
    /  __/~|   /       |    |Ph. 828/262-6283 Fax 828/262-2236|  
  =(  _____| (_________|    +=================================+
                         
.:*~*:._.:*~*:._.:*~*:._.:*~*:._.:*~*:._.:*~*:._.:*~*:._.:*~*:._.:*~*:.



_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users



************************************************************************

If you have received this e-mail in error, please delete it and notify the 
sender as soon as possible. The contents of this e-mail may be confidential and 
the unauthorized use, copying, or dissemination of it and any attachments to 
it, is prohibited. 

Internet communications are not secure and Hyperion does not, therefore, accept 
legal responsibility for the contents of this message nor for any damage caused 
by viruses.  The views expressed here do not necessarily represent those of 
Hyperion.

For more information about Hyperion, please visit our Web site at 
www.hyperion.com

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users