[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
RE: [sqr-users] SQL output parameter in SQR
- Subject: RE: [sqr-users] SQL output parameter in SQR
- From: Charles Burns <charlesburns70@yahoo.com>
- Date: Mon, 28 Mar 2005 11:50:58 -0800 (PST)
- Comment: DomainKeys? See http://antispam.yahoo.com/domainkeys
- Delivery-date: Mon, 28 Mar 2005 14:52:05 -0500
- Domainkey-signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;b=b7knNsns3fI+UYPH42dMJGh/Cs4VXKXsl9BDbchhgCl1FwDUJSuzxFynGch9k3eiLvIvAZjM7sGrpaNsS5SVwzUFp+eplOnC6EVBnngHBAKCU63AFms9m6oo8OUhiwzgZ15bO2Ht4dFLwUoxnn9HaQcqSaFfXOqgKV5EF/B3tDQ=;
- In-reply-to: 6667
- List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
Yes, it has.
Jeff.Steinfeldt@wellsfargo.com wrote:Has the filename variable been declared
for OUTPUT within the stored
procedure?
Example of SQR code:
@#ProcReturnStatus = N839073.JVproc_DataHubInSyncChk
@inSync = #inSync OUTPUT
Example of procedure declaration:
ALTER PROCEDURE N839073.JVproc_DataHubInSyncChk @inSync INTEGER OUTPUT
-----Original Message-----
From: sqr-users-bounces+jeff.steinfeldt=wellsfargo.com@sqrug.org
[mailto:sqr-users-bounces+jeff.steinfeldt=wellsfargo.com@sqrug.org] On
Behalf Of Charles Burns
Sent: Monday, March 28, 2005 11:24 AM
To: sqr-users@sqrug.org
Subject: [sqr-users] SQL output parameter in SQR
Here's my sqr version:
SQR Server/6.1.3/PC/Windows NT 4.0/Odbc Level 2/Oct 20 2000.
Database is MS SQL Server 2000
I'm trying to print the output parameter from a Stored Procedure. Here's the
code I'm using, I can print everything but the $filename variable. Thanks in
advance for any help you can give.
begin-setup
declare-variable
text $filename
end-declare
end-setup
begin-program
do main
end-program
begin-procedure main
input $where
input $bdate maxlen=10 type=char 'Enter Beginning Date.'
input $edate maxlen=10 type=char 'Enter Ending Date.'
execute maxlawbill @bdate = $bdate,@edate = $edate,@filename = $filename
output show $filename print $bdate (+2,1)BOLD print $edate (+2,1)BOLD print
$filename (+2,1)BOLD Print 'SUCCESS!!'(+2,1)BOLD print 'End of Procedure'
(+2,1) end-procedure
---------------------------------
Do you Yahoo!?
Yahoo! Small Business - Try our new resources site!
_______________________________________________
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!?
Yahoo! Small Business - Try our new resources site!
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users