[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

RE: [sqr-users] Param for CALL System or CALL Spawn mustbeWAITorNOWAIT


Looks like the 1 in the second call is the culprit.  SQR expects either
wait or nowait in this position.  There is no place in the syntax, of
4.3 anyway, for a number of any sort.

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
Mingazov, Maya
Sent: Wednesday, July 26, 2006 10:08 AM
To: This list is for discussion about the SQR database reportinglanguage
fromHyperion Solutions.
Subject: RE: [sqr-users] Param for CALL System or CALL Spawn
mustbeWAITorNOWAIT

That's what I have in the code:

1st report:
'
let $SystemTime = 'date'
call system using $SystemTime #status1
display $SystemTime
'
I see this #status1 but there is no checking of that status within the
code.

2d report besides above lines there is the following:
'
let $DeleteString = ' rm ' || $PerlmutterFile1
call system using $DeleteString #status 1
open $PerlmutterFile1 as 1 record = 60 for-writing
'

3d report has 1st report lines and plus the following:

'
string 'rm' $ExceptionFile by ' ' into $DelString
call system using $DelString #status1
open $ExceptionFile as 2 record=46 for-writing
'

About error line number, I usually get line number when I run report
locally and if there is an error, but users got just two of those lines
that I provided.

Maya 

-----Original Message-----
From: sqr-users-bounces+mmingazov=newsamerica.com@sqrug.org
[mailto:sqr-users-bounces+mmingazov=newsamerica.com@sqrug.org] On Behalf
Of Knapp, Richard
Sent: Wednesday, July 26, 2006 10:47 AM
To: This list is for discussion about the SQR database reportinglanguage
fromHyperion Solutions.
Subject: RE: [sqr-users] Param for CALL System or CALL Spawn
mustbeWAITorNOWAIT


Hmmm.  

1. Shouldn't SQR be telling you what line number the error appears on?

2. Has the syntax for the call system command changed?

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
Mingazov, Maya
Sent: Wednesday, July 26, 2006 9:18 AM
To: This list is for discussion about the SQR database reportinglanguage
fromHyperion Solutions.
Subject: RE: [sqr-users] Param for CALL System or CALL Spawn must
beWAITorNOWAIT

I am not sure where it comes from, Users ran three different reports and
they are not sure after which one they got it.

Is there a way to find out where in report could it be if I narrow it
down to one specific report? Because when I run it locally I don't see
any errors.

Thank you,

Maya 

-----Original Message-----
From: sqr-users-bounces+mmingazov=newsamerica.com@sqrug.org
[mailto:sqr-users-bounces+mmingazov=newsamerica.com@sqrug.org] On Behalf
Of Knapp, Richard
Sent: Wednesday, July 26, 2006 10:05 AM
To: This list is for discussion about the SQR database reportinglanguage
fromHyperion Solutions.
Subject: RE: [sqr-users] Param for CALL System or CALL Spawn must be
WAITorNOWAIT


Maybe you could supply the statement that is producing that error?

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
Mingazov, Maya
Sent: Wednesday, July 26, 2006 9:00 AM
To: This list is for discussion about the SQR database reportinglanguage
fromHyperion Solutions.
Subject: [sqr-users] Param for CALL System or CALL Spawn must be WAIT
orNOWAIT



Hello,

I need help!!!!
When users running report they are getting the following:

'Param for CALL System or CALL Spawn must be WAIT or NOWAIT
 Param for CALL System or CALL Spawn must be WAIT or NOWAIT'

But seems like they are still getting report's output.

What can I do to prevent it from showing that message and what does that
message mean? Do I need to make some changes to SQR code?

Thank you,

Maya 


This message and its attachments may contain legally privileged or
confidential information.  It is intended solely for the named
addressee.  If you are not the addressee indicated in this message (or
responsible for delivery of the message to the addressee), you may not
copy or deliver this message or its attachments to anyone.  Rather, you
should permanently delete this message and its attachments and kindly
notify the sender by reply e-mail.  Any content of this message and its
attachments that does not relate to the official business of News
America Incorporated or its subsidiaries must be taken not to have been
sent or endorsed by any of them.  No warranty is made that the e-mail or
attachment(s) are free from computer virus or other defect.

_______________________________________________
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


This message and its attachments may contain legally privileged or
confidential information.  It is intended solely for the named
addressee.  If you are not the addressee indicated in this message (or
responsible for delivery of the message to the addressee), you may not
copy or deliver this message or its attachments to anyone.  Rather, you
should permanently delete this message and its attachments and kindly
notify the sender by reply e-mail.  Any content of this message and its
attachments that does not relate to the official business of News
America Incorporated or its subsidiaries must be taken not to have been
sent or endorsed by any of them.  No warranty is made that the e-mail or
attachment(s) are free from computer virus or other defect.

_______________________________________________
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


This message and its attachments may contain legally privileged or
confidential information.  It is intended solely for the named
addressee.  If you are not the addressee indicated in this message (or
responsible for delivery of the message to the addressee), you may not
copy or deliver this message or its attachments to anyone.  Rather, you
should permanently delete this message and its attachments and kindly
notify the sender by reply e-mail.  Any content of this message and its
attachments that does not relate to the official business of News
America Incorporated or its subsidiaries must be taken not to have been
sent or endorsed by any of them.  No warranty is made that the e-mail or
attachment(s) are free from computer virus or other defect.

_______________________________________________
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