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 for Me (Login required).

Search for additional results

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