[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
RE: [sqr-users] How to select multiple files for processing
Try the command in a cmd window to debug the syntax.
Richard Knapp
EAS - Data Warehouse Group
University of Missouri
615 Locust Street #200
Columbia, MO 65201
573-882-8856
knappr@umsystem.edu
-----Original Message-----
From: sqr-users-bounces+knappr=umsystem.edu@sqrug.org
[mailto:sqr-users-bounces+knappr=umsystem.edu@sqrug.org] On Behalf Of
Kaz.Narayanan@averydennison.com
Sent: Wednesday, August 29, 2007 12:55 PM
To: This list is for discussion about the SQR database reporting languagefrom
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
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users