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

[franck.masson2002@laposte.net]

You do the same, replace "ls" by "dir"
 ' dir  BANKREC_* > mylist.txt '






> Message du 28/08/07 00:39
> De : Kaz.Narayanan@averydennison.com
> A : "This list is for discussion about the SQR database reporting language  
>from Hyperion Solutions." 
> Copie à : "This list is for discussion about the SQR database reporting 
>language  from Hyperion Solutions." , 
>sqr-users-bounces+kaz.narayanan=averydennison.com@sqrug.org
> Objet : RE: [sqr-users] How to select multiple files for processing
>
> 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" 
> 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." 
> 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
>

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