passthrough to DB2 - specific records

[dtoney]

I need to look at specific records where the root cause is marked TBD to
determine when the TBD changes to a valid root cause. However, when
attempting to pull only those records, I get an ODBC call failed error.

Here's my SQL:
SELECT tbl_allpmdata_RCofTBD.DATE_RECVD, tbl_allpmdata_RCofTBD.DATE_CLOSED,
tbl_allpmdata_RCofTBD.KEY_ID, tbl_allpmdata_RCofTBD.ALT_KEY,
tbl_allpmdata_RCofTBD.SEV, tbl_allpmdata_RCofTBD.INQ_CUST_ID,
tbl_allpmdata_RCofTBD.INQ_EMP_ID_NO, tbl_allpmdata_RCofTBD.INQ_TFT_DEPT,
tbl_allpmdata_RCofTBD.IDT_ADD, tbl_allpmdata_RCofTBD.IDT_ROOT_CAUSE_CD,
tbl_allpmdata_RCofTBD.IDT_ROOT_CAUSE_TXT, INFOP_VINFIDTZ.IDT_INACTIVE_DATE,
INFOP_VINFIDTZ.IDT_ROOT_CAUSE_CD, INFOP_VINFIDTZ.IDT_ADD_TIMESTAMP

FROM tbl_allpmdata_RCofTBD INNER JOIN INFOP_VINFIDTZ ON
tbl_allpmdata_RCofTBD.KEY_ID = INFOP_VINFIDTZ.IDT_KEY_ID;

 

[Stefan Hoffmann]

hi,

I need to look at specific records where the root cause is marked TBD to
determine when the TBD changes to a valid root cause. However, when
attempting to pull only those records, I get an ODBC call failed error.

As it's a passthrough, try it running in your native DB2 query tool.
Does it run without error?


mfG
--> stefan <--