RE: [sqr-users] Can't move all files from folder

["Knapp, Richard" <KnappR@umsystem.edu>]

I've tried some other solutions including encoding the asterisks and
double quoting the command.  Nothing works.  The strange thing is an
error is returned even though one file is moved each time.  I think
there is something goofy about how the OS is communicating with SQR.  I
have also tried rename which doesn't seem to work at all.

Have you tried communicating with Hyperion, Karen?

Richard Knapp
AITS - Data Warehouse Group
University of Missouri
Locust Street Building
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
Karen Leary
Sent: Tuesday, November 14, 2006 9:01 AM
To: This list is for discussion about the SQR database reportinglanguage
fromHyperion Solutions.
Subject: RE: [sqr-users] Can't move all files from folder

Thank you for your replies.  I am on Windows NT.  I am reading one of
the files and my program is not creating any of them.


-----Original Message-----
From: Bob Stone [mailto:bstone@fastenal.com] 
Sent: Monday, November 13, 2006 4:05 PM
To: This list is for discussion about the SQR database reporting
languagefrom Hyperion Solutions.
Subject: RE: [sqr-users] Can't move all files from folder

would it help to ENCODE the * character as its ASCII key?  Perhaps
something in the translation to SYSTEM code sees * as a special
character?  Could also be the \ character that thinks it means something
else?  

Seeing as she says DOS prompt and uses MOVE instead of CP, I assume
we're in a Windows environment?  I don't do much in the way of windows
scripting, so I'm not familiar with a lot of commands.  But I would
check into whether or not there's a character in the string that SYSTEM
would translate to do something other than just represent the character.

While I see no CR in the code below, maybe there's a CRLF issue?

-----Original Message-----
From: sqr-users-bounces+bstone=fastenal.com@sqrug.org
[mailto:sqr-users-bounces+bstone=fastenal.com@sqrug.org] On Behalf Of
Knapp, Richard
Sent: Monday, November 13, 2006 2:00 PM
To: This list is for discussion about the SQR database reportinglanguage
from Hyperion Solutions.
Subject: RE: [sqr-users] Can't move all files from folder


I tried this and it will only move one file at a time and generates a
status of 1 each time.  This is a syntax error.  I tried all sorts of
variations on wildcarding but could find nothing that worked for all the
files and nothing in the documentation that indicates a different syntax
except leaving the final slash off but even that doesn't affect the
desired movement.

Richard Knapp
AITS - Reporting
University of Missouri
Locust Street Building
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
Bob Stone
Sent: Monday, November 13, 2006 1:09 PM
To: This list is for discussion about the SQR database reporting
languagefrom Hyperion Solutions.
Subject: RE: [sqr-users] Can't move all files from folder

are they files that your program created?  And if so, are they closed?
You can't move a file you're still writing to because the system shows
SQRUSER as having control of a open file.

Also note that you can't move the log file or the .lis file
automatically created, because those aren't closed until the program
finishes.  Maybe there's actually a way to do that, but if I've had to
do something where I want to delete the file (or move it, in your case)
then I always open a file for writing and close it before I have to do
anything with it.

What system is this on?  



-----Original Message-----
From: sqr-users-bounces+bstone=fastenal.com@sqrug.org
[mailto:sqr-users-bounces+bstone=fastenal.com@sqrug.org] On Behalf Of
Karen Leary
Sent: Monday, November 13, 2006 12:54 PM
To: sqr-users@sqrug.org
Subject: [sqr-users] Can't move all files from folder

I am trying to move some files from one folder to another when finished
processing.

I am using the following syntax which only moves one of the files
instead of all of them - any ideas why???


Let $move = getenv('COMSPEC') || ' /C move ' || $ArchivePath || '*.* '
|| $ArchivePath || 'archive\'

call system using $move #status wait


Each time I run the program it will move one file.  If I run the same
command from a dos prompt it does move all the files.



Thank you,
Karen






_______________________________________________
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