[sqr-users] RE: sqr-users Digest, Vol 43, Issue 11

["Barilleaux, Rebecca" <Rebecca.Barilleaux@anthem.com>]

Here are a couple of examples of how we check for the existence of temp
tables before creating them in our SQR programs:

Begin-SQL -XP
  if not exists (select 1 from {tmpenv}..sysobjects where name =
'ky_groups' and type = 'U')
  CREATE table {tmpenv}..ky_groups
    (
    GRGR_CK       int,
    STAT_EFF_DT   datetime,
    STAT_TERM_DT  datetime,
    STAT_BUS_DIV  char(4));
End-SQL 

  Begin-SQL
    if exists (select 1 from {tmpenv}..sysobjects where name =
'{claim_table}' and type = 'U')
      drop table {tmpenv}..{claim_table}
    if exists (select 1 from {tmpenv}..sysobjects where name =
'{check_table}' and type = 'U')
      drop table {tmpenv}..{check_table};
  End-SQL 

Thanks,
Rebecca
-----Original Message-----
Date: Wed, 19 Sep 2007 13:38:00 +0530
From: Sanjay Sambhe <ssambhe@cisco.com>
Subject: [sqr-users] Check the existance of table in SQR
To: "'This list is for discussion about the SQR database reporting
        language        from Hyperion Solutions.'" <sqr-users@sqrug.org>
Message-ID: <5833.94181190189410.pent.cisco.com@MHS>
Content-Type: text/plain;       charset="US-ASCII"

Hi All,

Hope you are doing good..

I need to modify a sqr . I need to check the existance of temporary
tables
(which should be created by sqr code if not exists in backend). Could
you
pls suggest me How to check the existance of temp tables through sqr
code ?

Thanks and regards
Ss
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users




CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, 
is for the sole use of the intended recipient(s) and may contain confidential
and privileged information or otherwise protected by law.  Any unauthorized
review, use, disclosure or distribution is prohibited.  If you are not the
intended recipient, please contact the sender by reply e-mail and destroy
all copies of the original message.

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users