[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
RE: [sqr-users] Invoking dos commands thru sqr
- Subject: RE: [sqr-users] Invoking dos commands thru sqr
- From: "Bambach, Tom" <TBambach@genchemcorp.com>
- Date: Tue, 10 Oct 2006 08:15:43 -0400
- Delivery-date: Tue, 10 Oct 2006 08:19:12 -0400
- List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
Below procedure works on Windows & UNIX
Input file must be closed first
begin-procedure sort-file
let $syscmd = 'sort ' || $dat_file_tmpx || ' /O ' || $dat_file_tmps
display $syscmd
CALL SYSTEM USING $syscmd #stat WAIT
if #stat <> 0
:
:
:
end-procedure sort-file
-----Original Message-----
From: Vaidyanathan, Ramakrishnan (GE, Corporate, consultant)
[mailto:ramakrishnan.vaidyanathan@ge.com]
Sent: Monday, October 09, 2006 5: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