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
Error using Universe
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 16
- Joined: Sun Apr 17, 2005 11:27 pm
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.