cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
BookmarkSubscribeRSS Feed
gorata
Obsidian | Level 7 gorata
Obsidian | Level 7

Truncate Issues after DB2 v11 to DB2 v12 Migration

Posted 04-28-2020 08:58 AM (556 views)

Hi Guys,

 

we migrated from DB2 v11 to DB2 v12 resp. our tables and since than we are facing some truncate issues in the column names.

SAS is selecting only 18 characters from the column names from the DB2 Tables.

 

In case that the column names are longer than 18 characters they are than truncated and not showed correctly.

 

Could you please suggest what we can do in order to workaround this.

Are they any specific customization requred from SAS perspective after this migration?

 

Thanks a lot and!

 

0 Likes
Reply

suga badge.PNGThe SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment. 

Join SUGA 

CLI in SAS Viya

Learn how to install the SAS Viya CLI and a few commands you may find useful in this video by SAS’ Darrell Barton.

Watch CLI in SAS Viya on YouTube

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 0 replies
  • ‎04-28-2020 08:58 AM
  • 557 views
  • 0 likes
  • 1 in conversation