SQLDA TRUNCATED - NEEDED 3XX ENTRIES

Products

• Datacom
• DATACOM - AD
• Datacom/AD
• Datacom/DB
• Datacom/Server

Issue/Introduction

An ODBC request fails with error SQLDA TRUNCATED - NEEDED 313 ENTRIES (State:S1C00, Native Code:FFFFFF78) which corresponds to an SQL code -136

Environment

Release: Datacom

Resolution

The Datacom Server code is architected and structured such that it can handle only 300 columns in a request or in a table/view definition.
You can create an SQL VIEW on that table that uses lesser columns than 300 and use this view in your SQL request.