Error using Universe

poornimajayan · Post by **poornimajayan** » Mon Aug 07, 2006 10:04 pm

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

rameshrr3 · Post by **rameshrr3** » Mon Aug 07, 2006 10:28 pm

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

poornimajayan · Post by **poornimajayan** » Mon Aug 07, 2006 10:34 pm

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

loveojha2 · Post by **loveojha2** » Mon Aug 07, 2006 10:37 pm

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

ray.wurlod · Post by **ray.wurlod** » Mon Aug 07, 2006 10:46 pm

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.