Re: HTTPGETCLOB en SYSTOOLS de tipo *N no encontrado.

failed, seems that SQLSTATE 57017 has something to do with CCSID?

ID de mensaje . . . . : CPF503E Gravedad . . . . . . . : 30
Tipo de mensaje . . . : Diagnóstico
Fecha envío . . . . . : 09/06/20 Hora envío . . . . . . : 13:29:11

Mensaje . . . . : Error en función definida por usuario en el miembro
SYSDUMMY1.
Causa . . . . . : Se produjo un error al invocar la función definida por

usuario HTTPGETCLOB de la biblioteca SYSTOOLS. El error se produjo
mientras
se invocaba el programa o programa de servicio externo asociado
B2RESTUDF:
de la biblioteca SYSTOOLS.D, punto de entrada de programa o nombre
externo
com.ibm.db2.rest.DB2UDFWrapper.httpGetClob, nombre específico
HTTPG00005. El
error se produjo en el miembro SYSDUMMY1 archivo SYSDUMMY1 de la
biblioteca
SYSIBM. El código de error es 1. A continuación se muestran los códigos
de
error y sus significados:
1 -- El programa o programa de servicio externo devolvió SQLSTATE
57017.
El mensaje de texto devuelto desde el programa es: ¢ .

El 09-06-2020 13:20, Justin Taylor escribió:

Try this in Run SQL Scripts, does it work?
SELECT SYSTOOLS.httpGetClob('https://google.com [1]', null)
FROM sysibm.sysdummy1

For ref, here's Google's translation of the log into English:

The Java virtual machine is IBM Technology for Java. PID (464243)
User-defined function failed in member SYSDUMMY1.
A cancellation response has been received for message CPF503E.
User-defined function failed in member SYSDUMMY1.
A cancellation response has been received for message CPF503E.
HTTPGETCLOB on SYSTOOLS of type * N not found.
HTTPGETCLOB in SYSIBM of type * N not found.
Symbol (invalid. Valid symbols: FOR USE SKIP WAIT WITH FETCH
LIMIT
ORDER UNION EXCEPT OFFSET.
Symbol (invalid. Valid symbols: FOR USE SKIP WAIT WITH FETCH
LIMIT
ORDER UNION EXCEPT OFFSET.
HTTPGETCLOB on SYSTOOLS of type * N not found.
Symbol (invalid. Valid symbols: FOR USE SKIP WAIT WITH FETCH
LIMIT

ORDER UNION EXCEPT OFFSET.
HTTPGETCLOB on SYSTOOLS of type * N not found.
User-defined function failed in member SYSDUMMY1.
A cancellation response has been received for message CPF503E.
User-defined function failed in member SYSDUMMY1.
A cancellation response has been received for message CPF503E.
User-defined function failed in member SYSDUMMY1.
A cancellation response has been received for message CPF503E.
User-defined function failed in member SYSDUMMY1.
A cancellation response has been received for message CPF503E.

Links:
------
[1] https://google.com

-- Este e-mail fue enviado desde el Mail Server del diario ABC Color --
-- Verificado por Anti-Virus Corporativo Symantec --