DI 3.4: remove labels during tables importing.

[Costas]

I use Data Integration 3.4 and usualy need import tables from oracle by a specific libname. Sometime DI is not able to correctly import labels that contain strange caracters ('), the job produces strange error without to create the log,  so I wish to elimitate that.

Is there a mode to resolve it?

I tried with options "nolabel" in the tool for SQL Join but without results.

Thanks

Costantino

[Haikuo]

Not sure if this is relevent, in SAS Base, one can use proc datasets to remove labels and formats,  the following code came from SAS help:

proc datasets lib=work memtype=data;

   modify class;

     attrib _all_ label=' ';

     attrib _all_ format=;

run;

Regards,

Haikuo

[LinusH]

Maybe you could try the DBSASLABEL=NONE libname option.

This will blank out any RDBMS labels, and let SAS use the column names instead.

/Linus