Skip to Content
0
Former Member
May 03, 2005 at 02:24 PM

UD Connect from SQL Server does not parse semicolons

15 Views

Hi,

I am trying to retrieve data from SQL Server database using UD Connect and a Remote Cube.

The data comes over and the string looks like this:

'07;2005;LOC;2345.45;Comment'

The first field is defined as 10 varchar in SQL Server so my Infoobject is also 10 char long.

However when I use LISTCUBE or a query the field contains the first 10 characters: '07;2005;LOC' and the second field picks up from the next character.

When the SQL Server definition of the field was changed to char(10) the first field was OK but the second field in BW started with ';'.

It looks like that the ';' is not interpreted as the divider between fields.

Does anybody know how to overcome this issue?

Thanks for your help,

Tamas Nagy