[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: Dattatraya Shetty <datta_shetty@yahoo.com>
- Date: Thu, 5 Aug 2004 07:12:01 -0700 (PDT)
- Delivery-date: Thu, 05 Aug 2004 09:13:09 -0500
- In-reply-to: <62AFC819CCF3D611827A00065B3F798106BA8A30@sj-exchange.ci.sj.ca.us>
- List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
Gopal,
Did you run this command on the Unix command line?
I think you are also missing a '\' before the ";"
HTH
Datta.
--- "Alexander, Steve" <Steven.Alexander@sanjoseca.gov> wrote:
> 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
>
__________________________________
Do you Yahoo!?
Y! Messenger - Communicate in real time. Download now.
http://messenger.yahoo.com
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users