refering on my previous thread at viewtopic.php?t=132049&postdays=0&postorder=asc&start=0
I still get an error message in creating an ETL Job in Datastage 8.1 for DB2 UDP Stage.
When I compile the job, it has no error. But when I try to run the job, I got an error. And when I investigate the Datastage Director, it says:
Code: Select all
DB2_UDB_Enterprise_12: Error Idx = 1;
DB2Driver Embedded SQL message: ;
sqlcode = -1390;
sqlstate =
Code: Select all
DB2_UDB_Enterprise_12: Failed to connect to the database
Code: Select all
Error executing View Data command:##E IIS-DSEE-TNDB-00534 02:11:41(006) <DB2_UDB_Enterprise_12> Error Idx = 1;
Code: Select all
##E IIS-DSEE-TNDB-00534 02:11:41(006) <DB2_UDB_Enterprise_12> Error Idx = 1;
DB2Driver Embedded SQL message: ;
sqlcode = -1390;
sqlstate =
##E IIS-DSEE-TNDB-00000 02:11:41(007) <DB2_UDB_Enterprise_12> Failed to connect to the database
##E IIS-DSEE-TOPK-00007 02:11:41(011) <_PEEK_IDENT_> Input dataset does not have field: "PRODUCT_LINE_CODE".
##E IIS-DSEE-TOPK-00007 02:11:41(012) <_PEEK_IDENT_> Input dataset does not have field: "PRODUCT_TYPE_CODE".
##E IIS-DSEE-TOPK-00007 02:11:41(013) <_PEEK_IDENT_> Input dataset does not have field: "PRODUCT_CODE".
##E IIS-DSEE-TFSR-00019 02:11:41(015) <main_program> Could not check all operators because of previous error(s)
##E IIS-DSEE-TCOS-00029 02:11:41(022) <main_program> Creation of a step finished with status = FAILED.
and the setting I use in the stage is can be seen in this image:
I wish that all of the information is clear enough for anybody willing to help. if it's not enough, I will provide further.
thanks very much in advance,
Caterin[/url]