topic Re: Error in Data mapping to db2 fields in PROC DB2UTIL in ODS and Base Reporting

Error in Data mapping to db2 fields in PROC DB2UTIL

deleted_user — Sun, 20 Dec 2009 19:50:02 GMT

I am trying to insert a record into db2 table thru my SAS code using the code below on os/390.
It gives me error "ERROR: Input map and input data do not match, procedure terminated. ". Can anyone please suggest me what is the bug in this code and why I am getting this error.

DATA STARTPROC;
STATUSCD = 'I' ;
TASKCD = 2;
BATCHCD = 3;

PROC PRINT DATA = STARTPROC ;
FORMAT _NUMERIC_ PIB2. ;

PROC DB2UTIL DATA = STARTPROC
TABLE = ADRDNST.BATCH_TASK
FUNCTION = INSERT UPDATE;
MAPTO BATCHCD = BATCH_TASK_OID
TASKCD = TASK_OID
STATUSCD = STATUS_CD ;

The three fields in the table are declared as follows:
BATCH_TASK_OID DECIMAL 17
TASK_OID DECIMAL 17
STATUS_CD CHAR 1

--Raju

Re: Error in Data mapping to db2 fields in PROC DB2UTIL

sbb — Mon, 21 Dec 2009 01:29:49 GMT

From a cursory view, your STARTPROC SAS file's variable names do not exactly match the DB2 table attribute names.

Also, have you searched the SAS support website at http://support.sas.com/ using your symptom keywords?

Scott Barry
SBBWorks, Inc.

Re: Error in Data mapping to db2 fields in PROC DB2UTIL

deleted_user — Mon, 21 Dec 2009 04:06:04 GMT

Thanks Scott. Now I got my answer. PROC DB2UTIL expects all columns need to be included in the statement. I was omitting some columns which were not intrested to me. Once I include all columns, it worked fine.

So PROC DB2UTIL insert does not work like a cobol db2 insert statement where one can insert only few columns.

Thanks once again.

--Raju