Error - variable has too long a value for the XXX library

[MadhavCheluka]

I am getting below error while creating a table on Redshift using (datastep) Redshift ODBC connection.

ERROR: The character variable VAR1 has too long a value for the RSCONN library.
 

my connection statement and datastep:

libname rsconn odbc datasrc='XXXXXXXXXX' user="&user." pwd="&rspwd." schema=XXXXX;

data rsconn.table1;

set work.table2(keep=var1);

run;

The length of the var1 is $10.

any help in resolving this issue is appreciated

[SASKiwi]

What's the length of VAR1 in Redshift. Most likely it is defined as less than 10 characters. Run this to confirm:

proc contents data =  rsconn.table1;
run;