Hi All,

We just upgraded our CA-Datacom environment and now when we try to join a "hold" file to a CA-Datacom table using 2 or more keys, we get the following error:

(FOC1400) SQLCODE IS -161 (HEX: FFFFFF5F)
: [S1000] [CA][ODBC CA-Datacom/DB Driver][CA-DATACOM/DB] DECIMAL(15,0) IN
: VALID DATA: 400000001C
(FOC1407) SQL FETCH CURSOR ERROR. : GR_POL_P

Has anyone experienced this problem?

Please let me know.

Thanks
Jim

This message has been edited. Last edited by: Kerry,

Jim,

As a general rule, even though WebFOCUS lets you do it, it is not a good idea to do a heterogeneous join as you are attempting.

One suggestions is to extract and hold the join keys from the hold file and use them in a WHERE fieldname IN FILE filename clause. There is a limit to the number of bytes for this file. Multiply the distinct number of key rows times the key length. If the number is less than 16,000 for relational then you are good to go and this technique will work for you.

Hi Ginny,

Our shop must not have read this rule. We do this alot. Unfortunately, now that we upgraded CA-Datacom, webfocus does not let us do this anymore.

I was hoping someone had run into this before and could recommend a fix.

Jim

It's not a rule; it is a best practice. If you don't want to try my idea, then I recommend that you open a case with IBI.

quote:

DECIMAL(15,0) IN
: VALID DATA: 400000001C

Looks like an Alpha character in a Numeric column???

We backed out the Datacom changes and everything worked again. We have since, re-applied the changes in test along with several patches and so far it appears to be working there as well. This case is closed. Thanks for the suggestions.

Jim