[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
[sqr-users] Fwd: Puzzling Input Argument File Error
- Subject: [sqr-users] Fwd: Puzzling Input Argument File Error
- From: "Jennifer Lee" <j-lee@groupwise.umn.edu>
- Date: Fri, 08 Oct 2004 13:42:17 -0500
- Delivery-date: Fri, 08 Oct 2004 13:43:44 -0500
- List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
>>> Jennifer Lee 10/6/2004 7:47:19 AM >>>
Hi,
I would like to seek advice from this group about an input argument
file error:
Q1) If an input argument file is to be up loaded into a Unix
environment, does it matter to SQRW whether or not each argument line
ends with '\r \n' (return followed by new-line) or simply '\n'?
Q2) If an argument line only contains '\n', will SQRW know that it
should take that as a 'null' value?
Q3) What happens after SQRW reads in a line with '\n'? Will it assume
that there is no more input values or will it continue to read in values
from the argument file until end of the file?
Q4) Are there some watch-outs for using argument files for input
command? What are the situations where 'Error getting INPUT' can
occur?
Some background info:
1) We are using SQR for PeopleSoft/8.20. Sun's Solaris is our Unix
OS.
2) I was able to run from my PC an sqr program with all input values
in an argument file.
The command line looks like this:
sqrw.exe ... @c:\csqr\umfac001.parm
3) There are five input statements in the program:
input $Parm1 'Enter Parm1 (Optional, Press ENTER to continue)'
input $Parm2 'Enter Parm2 (Optional, Press ENTER to continue)'
input $Parm3 maxlen=5 'Enter Parm3'
input $Parm4 maxlen=30 'Enter Parm4 (Optional, Press ENTER to
continue)'
input $Parm5 maxlen=10 'Enter Parm5'
4) The argument file used by the program looks like this (from a PC
text editor):
Line 1:A blank space followed by a catridge return
Line 2:A catridge return only
Line 3:OSF followed by a catridge return
Line 4:A catridge return only
Line 5:2005
5) Because we are trying to run this sqr program outside the Process
Scheduler but with a Unix script calling SQRW, we up loaded the program
and the argument file into our Unix environment. Of course the @
argument has the proper Unix file path and file name.
6) When the same program was executed on Unix with a Unix script, the
program died right after 'Enter Parm3' is display in the log file.
7) Here's what it was logged in the .err output file:
Error on line 162:
(SQR 2500) Error getting INPUT.
SQR for PeopleSoft: Program Aborting.
Thanks in advance for your help!!
This e-mail and its attachments have been scanned for viruses.
EAS - Systems Support, OIT, University of Minnesota
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users