Re: SQL in SQR

[ANDERSD2 <ANDERSD2@OAKWOOD.ORG>]

Are you sure you need to create TEMP tables?  Would ARRAYS work with your
scenario??  ARRAYS are generally quicker than tables, require no
DBA/security clearance, and are temporary by nature.

-----Original Message-----
From: Wagner, Jennifer A [mailto:WAGNERJ@CDER.FDA.GOV]
Sent: Thursday, April 05, 2001 11:01 AM
To: SQR-USERS@list.iex.net
Subject: Re: SQL in SQR


It's working now... I cut the space requirements in half... I just don't
know if it will be enough space for all the temp tables I need to create...
so I may have to ask for more space or something.  Thanks!!!

> -----Original Message-----
> From: Jamadagni, Rajendra [mailto:rajendra.jamadagni@espn.com]
> Sent: Thursday, April 05, 2001 10:51 AM
> To: 'sqr-users@list.iex.net'; 'WAGNERJ@CDER.FDA.GOV'
> Subject: RE: SQL in SQR
>
>
> Jennifer,
>
> remove on-error=skip and see if second (and next one) create
> table throws
> any error. I assume that you have sufficient space in the specified
> tablespace.
>
> HTH
> Raj
> ______________________________________________________
> Rajendra Jamadagni            MIS, ESPN Inc.
> Rajendra dot Jamadagni at ESPN dot com
> Any opinion expressed here is personal and doesn't reflect
> that of ESPN Inc.
>
> QOTD: Any clod can have facts, but having an opinion is an art !
>
> *********************************************************************
>
> This e-mail message is confidential, intended only for the
> named recipient(s) above and may contain information that is
> privileged, attorney work product or exempt from disclosure
> under applicable law. If you have received this message in
> error, or are not the named recipient(s), please immediately
> notify ESPN at (860) 766-2000 and delete this e-mail message
> from your computer, Thank you.
>
> *********************************************************************
>
>