04-23-2014 02:19 AM
I have two charectar variables in a sas dataset;
I want to insert into Netezza database.
I have created the netezza database as
my question is how to insert the data . what is the sas code ?
04-23-2014 02:52 AM
- the table is defined as member of a netezza library
- SAS-formats to your SAS variables have been applied to their functionality
No need to think in SAS-code it will be converted. See: SAS/ACCESS(R) 9.3 for Relational Databases: Reference, Second Edition (Data Types for Netezza)
Only when the automatic conversion as documented is not according your specs you need to think.
By the way take care with the bigint types they are documented to be converted but failing by loss of precision
Message was edited by: Jaap Karman
04-23-2014 05:46 AM
Funny that you are asking for SAS code. One of the main features of DI Studio is that it will generate the code for you.
So just link you input data with your target data in the Table Loader. Be sure that the appropriate SAS formats is used, both in the loader and in the target table. When you get this far - try it. Then get back if there something that yo don't understand/get to work.