RE: [sqr-users] Invoking dos commands thru sqr

["Jim Womeldorf" <jwomeldo@fastenal.com>]

I have had the best luck pointing the command to the correct folder
something like this:

LET $PATH = GETENV('comspec')
LET #L = LENGTH($PATH)
WHILE 1
    IF SUBSTR($PATH, #L,1) = '\'
        BREAK
    END-IF
    LET #L = #L - 1
END-WHILE
LET $PATH = SUBSTR($PATH,1,#L)
LET $CMD = $path || 'Sort /+16 ' || $file1 || '>' || $file2

Jim
  

-----Original Message-----
From: sqr-users-bounces+jwomeldo=fastenal.com@sqrug.org
[mailto:sqr-users-bounces+jwomeldo=fastenal.com@sqrug.org] On Behalf Of
Vaidyanathan, Ramakrishnan (GE, Corporate, consultant)
Sent: Monday, October 09, 2006 4:45 PM
To: This list is for discussion about the SQR database reportinglanguage
from Hyperion Solutions.
Subject: RE: [sqr-users] Invoking dos commands thru sqr

I tried that also now its putting a blank sorted file..There is no data
in the second file..
Let $cmd = '/C Sort /+16 ' || $file1 || '>' || $file2



-----Original Message-----
From: sqr-users-bounces+ramakrishnan.vaidyanathan=ge.com@sqrug.org
[mailto:sqr-users-bounces+ramakrishnan.vaidyanathan=ge.com@sqrug.org]On
Behalf Of Knapp, Richard
Sent: Monday, October 09, 2006 5:26 PM
To: This list is for discussion about the SQR database reportinglanguage
fromHyperion Solutions.
Subject: RE: [sqr-users] Invoking dos commands thru sqr



Invoke the command interpreter with the /C flag so let $cmd = cmd /C ...
(your commands)

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
Vaidyanathan, Ramakrishnan (GE, Corporate,consultant)
Sent: Monday, October 09, 2006 4:11 PM
To: sqr-users@sqrug.org
Subject: [sqr-users] Invoking dos commands thru sqr

Hi All,

       Iam trying to use a dos sort command in sqr. it shud sort the
file and redirect the output to another file. I tried but its not
working for me.

Let $cmd_sort = 'Sort /+16 ' || $file1 || '>' || $file2

Iam not getting any error msg. The file is not sorted and iam not
getting any  sorted output file.
Please help

Thanks
Ram


_______________________________________________
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

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