I am using the SAS IOM OleDB provider to create and populate SAS tables via execution of SQL statements.
All is working fine, but, for creation of string fields, I am defaulting to a length of 400 because I cannot know the maximum string length in advance.
This results in very large disk space usage for string fields.
One option is to somehow set COMPRESS = CHAR as part of my CREATE TABLE execution, or some other command I can execute on the connection.
Does anyone know how to do this, or can suggest anything else to help?
Thanks
Kevin