DSP.OpenGCI $DSP.open error -100
Posted: Thu Nov 22, 2012 10:05 pm
Hi,
Im using DB2 connector as look up to transformer and using SQL inside the connector for look up. when i run the job, the get the error "DSP.OpenGCI $DSP.open error -100" and a warning "schema reconciliation failed : the column names defined on the link donot match with that of the external resource". i checked all the columns and all look fine. as i have seen in one of the posts, i deleted and recreated the stage and link but still same error.
Please help.
Im using DB2 connector as look up to transformer and using SQL inside the connector for look up. when i run the job, the get the error "DSP.OpenGCI $DSP.open error -100" and a warning "schema reconciliation failed : the column names defined on the link donot match with that of the external resource". i checked all the columns and all look fine. as i have seen in one of the posts, i deleted and recreated the stage and link but still same error.
Please help.