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

MadhavCheluka — Tue, 26 Apr 2022 18:11:42 GMT

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

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

SASKiwi — Tue, 26 Apr 2022 20:03:12 GMT

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;