DSXchange

While using a Universe and trying to create a table through th universe in run time, I am getting an error like "DSD.BCIOpenW call to SQLExecDirect failed.
Caret tabel......SQLSTATE=S1000, DBMS.CODE=950302
[DataStage][SQL Client][UNIVERSE]DataStage/SQL:
unexpected" The datasourcename I had given as localuv.
Can anyone please throw some light in this issue?
Thanks,
Poornima

Are you using a create table option in the Universe Stage? Have you clicked on the Create DDL button?

Hi Ramesh,
Yes I am using create table option inuniverse.I have already checked the "Create table in target Database" option.

Go to Edit DDL tab and click the Create DDL button to generate the DDL statement.

The message suggests that there's an unexpected newline in your SQL. All SQL statements have to be delivered to DataStage/UniVerse as single strings with no embedded newlines.