problem to chance a column length in management console

[Jose7]

Hi experts, nice to write you again !

I have a trouble modifying the length of a column in management console, when i import the metadata from a table, as a defult, it has 1024, but the length that i need for that column is 25,000 the datatype is alphanumeric.

The management console accepts this chance, but when I select the table from the enterprice guide (ver.7.15), it has always 1024.

I'm modifying in management console the lenght, the informat, and the format

[Patrick]

With SAS Enterprise Guide (your client) you're running a SAS workspace session that in the end accesses a physical SAS file (a SAS table) on the SAS server.

It depends on your libname statement if SAS accesses this table via SAS Metadata (you need to use the libname META engine - a library in SAS metadata that is defined to use the META engine). 

A SAS metadata table object can get out-of-sync with the underlying physical SAS table. If you change SAS Metadata column definitions then that's not going to change the actual column attributes in the physical table. IF you're accessing the physical table via the META engine (a libname defined accordingly) then the easiest way is to delete and recreate the physical table. 

If you can't re-create the physical table then you need to change the column attributes in the physical table first (using Proc Datasets or if it's lengths either Proc SQL change or just a SAS data step that re-creates the table from itself). And once your physical table looks like it should then you updated the table metadata object via SAS Management Console.

[Jose7]

I have the physical table in Sybase IQ and the column is varchar(25000), I imported the metadata by management console and always 1024 length is assigned.

Then I assigned the lib as meta in enterprise guide like this “libname LIB1 meta library="XXXX" metaout=data” , but when I want to see the table with a select or double click in the lib, I obtain an error, what can I do to solve this issue?

[SASKiwi · Accepted solution]

That length of 1024 is imposed by the default setting of the SAS option DBMAXTEXT. Try using it to see if it helps. You will need to reread your Sybase IQ table once you have set the option on a LIBNAME or SQL CONNECT statement.

[Jose7]

It worked, Thks !!