updating the length of a character variable

[jubikunjumon]

Hi,

Can anyone guide in resolving the below issue.

While running the query in EG getting following error "Incorrect length in SAS Metadata Repository for columns ABC".  After looking at the structure of oracle database i could see that ABC column is having character length of 40 while in EG its showing up with  140,  Any way that we can update in SAS Mangement console and will this  http://support.sas.com/kb/38/707.html help us in resolving the issue, since we need are having multiple environments

Regards

Jubi

[Patrick · Accepted solution]

The KB you reference is only for the specific case where you're using DBSASTYPE= in your libname definition. Is this the case for you?

If not then I believe you could just change the column metadata definition in the table so it's in sync with what you have in Oracle (not sure but I would just try in a DEV environment, may be first by playing around on a copy of the existing table metadata object to not impact on anything existing).

In case you're using the table metadata not only in EG but also with tools like DIS then you will have to do some impact analysis first in order to determine where else you have to amend things.

I personally don't like to use the meta engine for EG. Is there any reason you have to?

[jubikunjumon]

Hi Patrick,

Thanks for sharing an update for the query

The KB you reference is only for the specific case where you're using DBSASTYPE= in your libname definition. Is this the case for you? NO ,

I think the below option which you have specified sounds good, will try to take the backup of the metadata in SMC before replicating the changes. Will try to go through dev env. 

If not then I believe you could just change the column metadata definition in the table so it's in sync with what you have in Oracle (not sure but I would just try in a DEV environment, may be first by playing around on a copy of the existing table metadata object to not impact on anything existing).

there is no specfic reason for doing this in EG will try to have in DIS