SAP Knowledge Base Article - Preview

2784330 - SQLCODE = -270 reported when creating DB2 User Defined Functions (UDFs)

Symptom

The following SQL error -270 is reported when attempting to create a User Defined Function (UDF) in Db2 z/OS:

-------------------------------------------------------------------------------------------
DSNT408I SQLCODE = -270, ERROR:  FUNCTION NOT SUPPORTED             
DSNT418I SQLSTATE   = 42997 SQLSTATE RETURN CODE                   
DSNT415I SQLERRP    = DSNXOFN3 SQL PROCEDURE DETECTING ERROR       
DSNT416I SQLERRD    = -112  0  0  -1  0  0 SQL DIAGNOSTIC INFORMATION
DSNT416I SQLERRD    = X'FFFFFF90'  X'00000000'  X'00000000'         
X'FFFFFFFF'  X'00000000'  X'00000000' SQL DIAGNOSTIC       
INFORMATION
-------------------------------------------------------------------------------------------


Read more...

Environment

DB2 z/OS all versions

Product

SAP NetWeaver all versions

Keywords

SQL0270N UDF SCALAR TABLE ALTER CREATE SYSLOG ZOS , KBA , BC-DB-DB2 , DB2 for z/OS , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.