Skip to main content

Support Tip: "INVALID NUMERIC VALUE" error given using symbolic names with ICETOOL: SELECT – USING

  • June 14, 2022
  • 0 replies
  • 0 views

Heather Caldwell

When executing JCL that uses ICETOOL SELECT with ON option using symbolic names, this results in an error "INVALID NUMERIC VALUE". The reason for this is that symbolic names are not currently supported in Enterprise Developer / Enterprise Server at the time of writing this article (current version: 7.0 Patch Update 8).

The following JCL snippet will result in the "INVALID NUMERIC VALUE" error when trying to use ON(CLAAVE1) ON(CLAVE2):

//SOR1CNTL DD  *
 SORT FIELDS=(CLAVE1,A,CLAVE2,A,CLAVE3,A,CLAVE4,D,CLAVE5,A)
/*
//SYMNAMES DD  *
CLAVE1,1,50,CH
CLAVE2,51,8,CH
CLAVE3,77,2,CH
CLAVE4,74,1,CH
CLAVE5,75,2,CH
/*
//TOOLIN   DD  *
SELECT FROM(I1) TO(O1) DISCARD(D1) FIRST USING(SOR1)-
ON(CLAVE1) ON(CLAVE2)

Full article: https://portal.microfocus.com/s/article/KM000007591


#SupportTips/KnowledgeDocs
#EnterpriseDeveloper