DB2 table name restricted to 18 characters (z/os)

Reply
Occasional Contributor
Posts: 9

DB2 table name restricted to 18 characters (z/os)

If I use the DB2 SAS/Access driver I'm restricted to 18 characters for table names, but if I use an ODBC driver, I don't face the same restriction, writing to the SAME database.

 

Is there some option to allow for table names to be longer? 

 

The DB2 driver is used in mainframe batch programming, whereas the ODBC driver is used in SAS/EG.

Super User
Super User
Posts: 6,842

Re: DB2 table name restricted to 18 characters (z/os)

From the documentation it should support up to 32 characters.  Perhaps you are running an old version of SAS?

 

https://support.sas.com/documentation/cdl/en/acreldb/68028/HTML/default/viewer.htm#p0yhmivki2ahxsn1h...

 

Ask a Question
Discussion stats
  • 1 reply
  • 181 views
  • 0 likes
  • 2 in conversation