[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
RE: [sqr-users] Unix command in SQR
- Subject: RE: [sqr-users] Unix command in SQR
- From: "Alexander, Steve" <Steven.Alexander@sanjoseca.gov>
- Date: Wed, 4 Aug 2004 12:18:18 -0700
- Delivery-date: Wed, 04 Aug 2004 14:21:08 -0500
- List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
I think you're missing a quote mark or two, but the immediate problem is the
curly brackets { and } on the same line. The compiler looks for curly
brackets on the same line before anything else compiles. It will try to
substitute text regardless of quote marks. It's looking for a defined
constant called ' || ' (including the quotes).
-----Original Message-----
From: Borde, Gopal S [mailto:gopal-borde@uiowa.edu]
Sent: Wednesday, August 04, 2004 11:59 AM
To: sqr-users@sqrug.org
Subject: [sqr-users] Unix command in SQR
Friends,
I am trying to issue following UNIX command in SQR to list names of all
*.txt files in a folder.
------
let $com1 ='find /ora10/inbound/evoucher -name "*.txt" -exec basename
'{' || '}' ";" > /ora10/inbound/evoucher/dan.lis'
call system using $com1 #s wait
However program erred with following message
Error on line 49:
(SQR 4707) No value found for substitution variable: {}
let $com1 ='find /ora10/inbound/evoucher -name "*.txt" -exec basename
'{}' ";" > /ora10/inbound/evoucher/dan.lis'
Error on line 49:
(SQR 4008) Unknown function or variable in expression: {}'
let $com1 ='find /ora10/inbound/evoucher -name "*.txt" -exec basename
'{}' ";" > /ora10/inbound/evoucher/dan.lis'
Any suggestion to run this command will be appreciated.
Thanks.
Gopal Borde
ITS Dept
_______________________________________________
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