[sqr-users] Re: sqr-users Digest, Vol 2, Issue 4

[Rebecca.Barilleaux@Anthem.com]

Jae,

I use getenv to get environment variables from UNIX in my SQR program.
The following lines in SQR should create the same file names as your shell
script:

   let $DD_PRNTO1 = getenv('HOME') || '/pzrlbec_' || to_char(#sqr-pid) ||
'.lis'
   let $DD_PRNTO2 = getenv('HOME') || '/pzrlbec_' || to_char(#sqr-pid) ||
'_01.log'
   let $DD_PRNTO3 = getenv('HOME') || '/pzrlbec_' || to_char(#sqr-pid) ||
'_02.lis'

   open $DD_PRNTO1 as 1 for-writing record=150:vary status=#openstatus1
   open $DD_PRNTO2 as 2 for-writing record=250:vary status=#openstatus2
   open $DD_PRNTO3 as 3 for-writing record=150:vary status=#openstatus3

- Rebecca



Date: Mon, 05 Apr 2004 17:05:19 -0400
From: Jae Lee <leejc@appstate.edu>
Subject: [sqr-users] How do I use a variable file path for flat files?
To: sqr-users@sqrug.org
Message-ID: <4071CA0F.5070802@appstate.edu>
Content-Type: text/plain; format=flowed; charset=us-ascii

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







CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, 
is for the sole use of the intended recipient(s) and may contain confidential
and privileged information or otherwise protected by law.  Any unauthorized
review, use, disclosure or distribution is prohibited.  If you are not the
intended recipient, please contact the sender by reply e-mail and destroy
all copies of the original message.

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