I've been trying all kinds of things to make this work but the following SQL stmt always returns this:
RC= -15 For Command: SELECT graph from table where uuid = '69f0ff84241c4d9bbfd3f8c984add411'
REXX/SQL-15: Conversion/truncation occurred on column GRAPH: Expecting 32767, got 922956 0 [MySQL][ODBC 5.3(w) Driver][mysqld-5.6.23-log] -15
I have been trying this: set rc = SQLVARIABLE(LONGLIMIT,10000000)
And I can see it is being set before my SELECT is executed.
The column "graph" is defined with datatype "mediumtext" which can be 16M. Tried on both mysql and SQL Server, same results. The SQL stmt returns a single row.
I also tried to use "prepare/open/fetch" but I get the same results.
Any idea on how I can make this work? (I need the entire column so I don't want to use IGNORETRUNCATE)
Thanks in advance!
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I've been trying all kinds of things to make this work but the following SQL stmt always returns this:
RC= -15 For Command: SELECT graph from table where uuid = '69f0ff84241c4d9bbfd3f8c984add411'
REXX/SQL-15: Conversion/truncation occurred on column GRAPH: Expecting 32767, got 922956 0 [MySQL][ODBC 5.3(w) Driver][mysqld-5.6.23-log] -15
I have been trying this: set rc = SQLVARIABLE(LONGLIMIT,10000000)
And I can see it is being set before my SELECT is executed.
The column "graph" is defined with datatype "mediumtext" which can be 16M. Tried on both mysql and SQL Server, same results. The SQL stmt returns a single row.
I also tried to use "prepare/open/fetch" but I get the same results.
Any idea on how I can make this work? (I need the entire column so I don't want to use IGNORETRUNCATE)
Thanks in advance!