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 (874 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 

Get Started with SAS Information Catalog in SAS Viya

SAS technical trainer Erin Winters shows you how to explore assets, create new data discovery agents, schedule data discovery agents, and much more.

Watch Get Started with SAS Information Catalog in SAS Viya on YouTube

Find more tutorials on the SAS Users YouTube channel.

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