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

["Bob Stone" <bstone@fastenal.com>]

Try opening a command prompt and seeing what works to get you that list.  Then 
copy and paste into your SQR $COMMAND variable.

________________________________

From: sqr-users-bounces+bstone=fastenal.com@sqrug.org on behalf of 
Kaz.Narayanan@averydennison.com
Sent: Wed 8/29/2007 12:54 PM
To: This list is for discussion about the SQR database reporting language from 
Hyperion Solutions.
Subject: RE: [sqr-users] How to select multiple files for processing



Bob,

Instead of I: Drive, I try using H: Drive, which is recognizable to all my
SQR programs.

$COMMAND = 'C:\WINDOWS\system32\cmd.exe /c DIR/B H:\TEMP\av1377ds* >
H:\TEMP\KMDIPLIST.txt'

CALL SYSTEM USING $COMMAND  #call_status wait

I still get nothing. The #call_status value is 3. I see in our forum that
the value need to be more than 10.

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/29/2007 06:38 AM
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


Is "I:" defined on the machine that is actually running the process?  Just
because you have an I: directory, doesn't mean the Production server calls
it the same thing.  Try the full path.

-----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: Tuesday, August 28, 2007 7:00 PM
To: This list is for discussion about the SQR database reporting language
from Hyperion Solutions.
Subject: RE: [sqr-users] How to select multiple files for processing

Hello ,

Thanks for your feedback. I am using the following, Still the program is
not writing the txt file in I:\AR\ directory.

Am I making any mistakes?

Thanks
Regards

Th

        LET $COMMAND = 'C:\WINDOWS\system32\cmd.exe/c DIR
H:\TRANSHIPMENT\RIP\bankrec_* > I:\AR\bankrec.txt'
        CALL SYSTEM USING $COMMAND  #call_status wait

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




"Tai Luong" <tluong@ccsf.edu>
Sent by: sqr-users-bounces+kaz.narayanan=averydennison.com@sqrug.org
08/28/2007 10:04 AM
Please respond to "This list is for discussion about the SQR database
reporting       language from Hyperion Solutions."

        To:     <franck.masson2002@laposte.net>, <sqr-users@sqrug.org>
        cc:
        Subject:        RE: [sqr-users] How to select multiple files for
processing


With option \b \o the following will display the file names in bare format

and sorted, one per line:
   DIR ' D:\DATA\BANKDATA\BANKREC_*.TXT /B /O >BANKLIST.TXT'

Use the dos command 'dir /?' for more info.
Tai Luong.


>>> franck.masson2002@laposte.net 08/28/07 7:51 AM >>>
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


_______________________________________________
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


- -----------------------------------------------------------------
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


Here was a non admissible message part of 'application/ms-tnef' MIME
type. It has been automatically discarded before sending the message to
the list. 
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users