DATA Step, Macro, Functions and more

Data lengths from a mysql connection

Reply
N/A
Posts: 0

Data lengths from a mysql connection

Hi

I connect to a mysql database and all my maximum data length is 1024.
can i increase this somehow?
im under the impression that sas can handle 32,000.
i connect using the normal libname statement.

thanks

Spud
Super User
Posts: 5,257

Re: Data lengths from a mysql connection

You are probably trying to read a column of the text or blob types in MySQL. In SAS, use the DBMAX_TEXT= option to set the number of chars that you wish see in SAS. The default value is 1024. See:

http://support.sas.com/documentation/cdl/en/acreldb/59618/HTML/default/a002914076.htm

and

http://support.sas.com/documentation/cdl/en/acreldb/59618/HTML/default/a001371562.htm

/Linus
Data never sleeps
N/A
Posts: 0

Re: Data lengths from a mysql connection

Thats fantastic....cheers
Ask a Question
Discussion stats
  • 2 replies
  • 131 views
  • 0 likes
  • 2 in conversation