Date:         Wed, 3 Oct 2007 14:34:39 -0700
Reply-To:     "Duell, Bob" <BD9439@ATT.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Duell, Bob" <BD9439@ATT.COM>
Subject:      Re: I tried to load integer data into db2 through proc sql
Comments: To: Kuladeep Mittapalli <kuladeep.m@GMAIL.COM>
In-Reply-To:  A<d44d467b0710031012w38863525v6ae0be2d323d282d@mail.gmail.com>
Content-Type: text/plain; charset="US-ASCII"

I don't use DB2, but you can try the DBTYPE data set option.  I use it
all the time creating Teradata tables and the SAS documentation says
it's good for DB2 as well.  Assuming you really have a SAS libref
somewhere that uses the DB2 engine, then this might work:

libname MYDB2 db2 (...);
proc sql noprint;
   CREATE TABLE MYDB2.T_recipients_tbl(BULKLOAD=YES
      dbtype=(transaction_id='integer' program_id='integer')
      ) AS
   SELECT  transaction_id,
           program_id
   FROM TEST;
QUIT;

-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of
Kuladeep Mittapalli
Sent: Wednesday, October 03, 2007 10:12 AM
To: SAS-L@LISTSERV.UGA.EDU
Subject: I tried to load integer data into db2 through proc sql

Hi,
When i tried to load integer data into db2 through proc sql,After
loading
data into db2,it converts into double.


I want to load integer data only.would you please help me out in this
critical situation .


Thanks
My code looks below :

*

PROC* *SQL* NOPRINT;

CREATE TABLE T_recipients_tbl(BULKLOAD=YES) AS

SELECT transaction_id FORMAT *10.*,

        program_id FORMAT *10.*

**FROM TEST;
*

QUIT*;

%*runstats*(tbl_name=T_recipients_tbl);