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

[Pamela Lantzy <PLantzy@uamail.albany.edu>]

We have an environment variable set for us for each unix machine and then we
reference that in our programs.  


echo $UA_INPUTDIR
/av01/app/devl/uainput/


!****************************************************
! Get-Input-Dir
!****************************************************
begin-procedure Get-Input-Dir(:$input_dir)
  let $input_dir = getenv('UA_INPUTDIR')
end-procedure Get-Input-Dir


Sample source:

    let $input_dir = {NULL}
    do Get-Input-Dir($input_dir)
    let $Ua_Usernames_File = $input_dir || 'uaupccid.dat'


We have use a common function sqc that has these procedures in case we need
to add, change or delete environment varables we dont have to change alot of
sqrs.


Pam
-----Original Message-----
From: Jae Lee [mailto:leejc@appstate.edu]
Sent: Monday, April 05, 2004 5:05 PM
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

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