My PB 8 application was connecting to SYBASE ASE using Sybase 11 native client.
Now i want to change the connection using ODBC driver provided with the PB. I find difficulties with buffer when executing SP from datawindow.

The follwing error occurs..
Select error : SQLSTATE = 01004 [INTERSOLV][ODBC SQL Server driver]String data, right truncated.
I tried increasing the datawindow variable length and the error was solved..
This solution cant be implemented as the appln contains 100s of DW...Can anyone suggest a generic solution to avoid this error and execute procedure or query from DW??