Created On: 06 September 2012
Problem:
Trying to Load an XDB Table using DSNUTILB utilty through JCL. The job is failing with a SQL Error -177 , ERROR: THE NUMBER OF VALUES ASSIGNED IS NOT THE SAME AS THE NUMBER OF SPECIFIED OR IMPLIED COLUMNS
Resolution:
To ensure that the data on the input file used in your JCL isn't corrupt or mis-aligned use SQL Wizard to load the table as an import.
If this fails then the problem is data related and not with the DSNUTILB Utility.
If the Import is successful you will need to check the versions of programs you are currently using within your Project.
Within MFE 3.1 go to Project Settings > Aliases.
Under the Alias Column look for DSNUTILB if this has an associated Program Name of MFDB2LOA change this to XUTLB.
Under the Alias Column look for DSNTEP2 if this has an associated Program Name of MFDSNTEP change this to XTEP2.
If this fails then the problem is data related and not with the DSNUTILB Utility.
If the Import is successful you will need to check the versions of programs you are currently using within your Project.
Within MFE 3.1 go to Project Settings > Aliases.
Under the Alias Column look for DSNUTILB if this has an associated Program Name of MFDB2LOA change this to XUTLB.
Under the Alias Column look for DSNTEP2 if this has an associated Program Name of MFDSNTEP change this to XTEP2.
Incident #2534820
Old KB# 36282
#EnterpriseDeveloper
#MFDS
#DSNUTILB-117XDB
