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

["the dragon" <ceprn@hotmail.com>]

I think the sytax is getenv(ORACLE_SID), or something like that.  I am at 
home and my BOOK is at work.  I also have an example there I'll send you.

clark 'the dragon' willis



PSA: Salary <> Slavery.  If you earn a salary, your employer is renting your 
services for 40 hours a week, not purchasing your soul.  Your time is the 
only real finite asset that you have, and once used it can never be 
recovered, so don't waste it by giving it away.

"Time is the coin of your life. It is the only coin you have, and only you 
can determine how it will be spent.  Be careful lest you let other people 
spend it for you."

Carl Sandburg
(1878 - 1967)

----Original Message Follows----

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

_________________________________________________________________
Watch LIVE baseball games on your computer with MLB.TV, included with MSN 
Premium! 
http://join.msn.com/?page=features/mlb&pgmarket=en-us/go/onm00200439ave/direct/01/


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