Want to use Sybase non-sharable temporary # tables in SQR

["Pimple, Vijay C Mr USAREC" <Vijay.Pimple@USAREC.ARMY.MIL>]

Hi all,

I am running SQR against sybase 11.9.2 database and I am testing whether I
can use sybase non-sharable temporary # tables in Begin-sql section and
select columns from the # tables in BEGIN-SELECT section.

I created the following sqr report and I am getting compile error -

Begin-Program
 Position (1,1)
 Do Master_Query
End-Program

Begin-Procedure Master_Query
begin-sql
select sname, etable into #vptest from dbo.adp_t
go
end-sql
Begin-Select
sname   (+1,5,15)
etable  (,17,20)
>From  #vptest
End-Select
End-Procedure

Begin-Heading 4
 Print $current-date (1,1) edit 'MM/DD/YYYY'
 Page-Number (1,5)
 Print 'SNAME' (+1,1,5) Underline  Bold
 Print 'ETABLE' (,17,8) Underline  Bold
End-Heading

I can call stored procedure in begin-sql and within stored procedure I can
create #tables but I cannot access the same table in Begin-select section.

Is it possible to create #temporary tables in Begin-sql section and use in
begin-select section ?


Please advise me.

Regards,

Vijay


-----Original Message-----
From: Ray Ontko [mailto:rayo@ONTKO.COM]
Sent: Friday, June 22, 2001 10:12 AM
To: SQR-USERS@list.iex.net
Subject: Re: Compiling SQR Code


The command for compiling an SQR under MS-DOS:

  SQRW prog.sqr usr/pwd -rs

To run a compiled program:

  SQRW prog.sqt usr/pwd -rt

or

  SQRWT prog.sqt usr/pwd

Ray

> Hi all,
>
> I am new to SQR and PeopleSoft. Could any one please
> let me know the different ways to compile a SQR
> program? Is it possible to compile the program from
> DOS prompt?
>
> Thanks,
> Ram
>
>
>
> _________________________________________________________________________
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
>

----------------------------------------------------------------------
Ray Ontko   rayo@ontko.com   Phone 1.765.935.4283   Fax 1.765.962.9788
Ray Ontko & Co.   Software Consulting Services   http://www.ontko.com/