XML Services - publish_lob_ref - SQL query string input limitation

Extensibility

XML Services - publish_lob_ref - SQL query string input limitation

Hi,

we try to use PUBLISH_LOB_REF Stored procedure with XML Services to publish a document with a SQL Query. But we have to face of the limitation of the SQL query string input (varchar 20000).
our SQL query is about 60000 char.

how can we bypass that limitation ?
any help please?

Regards.

1 REPLY
Teradata Employee

Re: XML Services - publish_lob_ref - SQL query string input limitation

Is that possible to introduce a view to shrink your query?