Date:         Fri, 18 Mar 2005 12:58:42 -0500
Reply-To:     "Worlund, Max" <ZQY3@CDC.GOV>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Worlund, Max" <ZQY3@CDC.GOV>
Subject:      SQL commands passed from SEG v3 to SQL Dbase
Content-Type: text/plain; charset="us-ascii"

I'm working with SAS Enterprise Guide and trying to do a SQL Insert to a
SQL Database table.  I need to set IDENTITY_INSERT to ON.  The SQL
command is "Set Identity_Insert <table name> On".   I can't get PROC SQL
to recognize this command or pass it to the SQL database.  I'm trying to
do this via SEG and not SQL Enterprise Manager so that the table
build/maintenance process will be a one button process and not have the
user get the SQL DBA to do the Insert via DTS.  Any ideas? Thanks.
 
 
proc sql;
set IDENTITY_INSERT SQLTEST1.sys_df_standard on;
insert into SQLTEST1.sys_df_standard 
select standard_uid, field_to_standardize, standard_table_source,
standard_cd, standard_cd_descr, incoming_val
from dfpower.standard_tbl;
 
 

Max A. Worlund

CDC Information Technology Support Contract (CITS)

Software Engineer III

NCHSTP/SDMB

Phone:  404.639.4802

Fax:  404.639.8642

email:  zqy3@cdc.gov