BODS 4.0 Table's Records

[Former Member]

Dear all Experts ,

We got problem with Table (BUT000) from our Sol. manager sys. which is supposed to show all his (32) Varchar records from Column PARTNER GUID but just we get the first (16) varchar..!!!??  any Ideas

Appreciated

Mazin

[Former Member]

Dear all Experts,

now I'm facing this new problem with ODBC when SQL Submitted ??

DB SQL Server 2005

Windows server 2008 R2

BODS 14.0

SBOP 4.0 SP7. PAT 5

Appreciated

Mazin

[former_member186897]

Check if this thread is helpful.

[Former Member]

Dear Mohammad,

Thanks for your link

Mazin

[ahalya_inturi]

Hi

Can you please select option create NVARCHAR type columns for VARCHAR input column types for supported databases to "YES"  and check the data.

Regards

Ahalya

[Former Member]

Hi Ahalya,

thanks for your quick answer ...

would you please explain more!! ...sorry  I couldn't find the option in column ??

Thanks in Advance

Mazin

[ahalya_inturi]

u can check for options in template table ---> options tab-->>> NVARCHAR type columns for VARCHAR input column types for supported databases

[Former Member]

gotcha....but unfortunately it produce another error .

The problem is the source schema showed 16 varchar instead of 32 ... even though in column profile Tab showed 32 varchar ..

thanks again

Mazin