RE: [sqr-users] How to select multiple files for processing

[Kaz.Narayanan@averydennison.com]

Thanks Bob For quick reply.

What should I do if the files are in my Windows server?

Thanks
Regards
K.M.Narayanan
AVERY DENNISON
Corporate IT & Services
(702) 968-5727 -  Work
(702) 332-7118  -  Cell




"Bob Stone" <bstone@fastenal.com>
Sent by: sqr-users-bounces+kaz.narayanan=averydennison.com@sqrug.org
08/27/2007 03:25 PM
Please respond to "This list is for discussion about the SQR database 
reporting       language from Hyperion Solutions."
 
        To:     "This list is for discussion about the SQR database 
reporting language      from Hyperion Solutions." <sqr-users@sqrug.org>
        cc: 
        Subject:        RE: [sqr-users] How to select multiple files for 
processing


Use UNIX to create your list of files, and then loop through it opening
each one at a time.

  LET $cmd = ' LS BANKREC_* > mylist.txt '

  CALL SYSTEM USING $cmd

  OPEN mylist.txt as 1
  LOOP 1
    READ $line into $filename
      OPEN $filename as 2
      do process-this-file  (include moving it to a 'complete'
directory?)
      CLOSE 2
  END-LOOP
  CLOSE 1

Does that make sense?  You make a file that lists which files you're
going to process on, then you open each of those files as you loop
through your list, processing however you need to.  The unix command
might be >> instead of >...I forget which appends and which overwrites.
You'll want to check the syntax.



-----Original Message-----
From: sqr-users-bounces+bstone=fastenal.com@sqrug.org
[mailto:sqr-users-bounces+bstone=fastenal.com@sqrug.org] On Behalf Of
Kaz.Narayanan@averydennison.com
Sent: Monday, August 27, 2007 5:12 PM
To: sqr-users@sqrug.org
Subject: [sqr-users] How to select multiple files for processing

Hello,

I have multiple files in the following format in our Unix directory..

BANKREC_XXXXXXXX.TXT
where XXXXXX is the date time stamp.

I want the SQR to pick each file, open it , read and perform some
actions.

If it is single file, I can use Open 1 as......

How to open these multiple files?

An earlier reply would be highly appreciated.
Thanks
Regards
K.M.Narayanan


- -----------------------------------------------------------------
The information transmitted is intended only for the person or entity to
which it is addressed and may contain confidential and/or privileged
material. Any review, retransmission, dissemination or other use of, or
taking of any action in reliance upon, this information by persons or
entities other than the intended recipient is prohibited. If you
received this in error, please contact the sender and delete the
material from any computer.

_______________________________________________
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



- -----------------------------------------------------------------
The information transmitted is intended only for the person or entity to which 
it is addressed and may contain confidential and/or privileged material. Any 
review, retransmission, dissemination or other use of, or taking of any action 
in reliance upon, this information by persons or entities other than the 
intended recipient is prohibited. If you received this in error, please contact 
the sender and delete the material from any computer.

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