Page 1 of 1
Sparse Lookup with DB2 ODBC Stage.
Posted: Tue Sep 20, 2005 6:30 am
by subasht
Does any body used OBDC stage to do sparse lookup against DB2? I am receiving the SQL error "SQL0805N" with package "NULLID.SYSLH203" not found. The lookup works fine in test with less number of rows.
Posted: Tue Sep 20, 2005 4:33 pm
by ray.wurlod
Welcome aboard! :D
Sparse lookup is documented only to work with DB2 and Oracle stage types (at least in version 7.1).
Posted: Wed Sep 21, 2005 5:19 am
by Eric
Are you using a DB2 8.x client running against a DB2 7.x Server?
Posted: Wed Sep 21, 2005 5:20 pm
by subasht
No. It is both 8.x.