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

[Arjan Hoornstra <ahoor@YAHOO.COM>]

Vijay,

You must not use a 'go' within an sqr progam.

Begin-Procedure Master_Query
begin-sql
   select sname, etable
   into #vptest
   from dbo.adp_t
end-sql

Also make it a common rule that you do indent every statement
exept begin- and end- headers and column names within a begin-select
section.

Then also you have to use 2 # for sqr to know you mean a tablename and
not a numeric variable:

Begin-Procedure Master_Query
begin-sql                     ! you may have to use -C1 here
   select sname, etable
   into ##vptest
   from dbo.adp_t
end-sql
Begin-Select
sname   (+1,5,15)
etable  (,17,20)
>From  ##vptest                ! also use -C1 here in that case
End-Select
End-Procedure


Btw you didn't give the error message... but hope this helps

Arjan




--- "Pimple, Vijay C Mr USAREC" <Vijay.Pimple@USAREC.ARMY.MIL> wrote:
> 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/


__________________________________________________
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
http://personal.mail.yahoo.com/