DSXchange

Huh... while I knew what Ray meant, I had no idea about the 'pregnancy' link nor the fact that is some kind of pudding.

They also fail to mention that it is Homer Simpon's favorite beer.

sonia jacob wrote:

chulett wrote:And who would you be?

I am sorry. Its the same me.

Ah... we seem to have a case of multiple personalities.

Specifically, I meant the 'it' he killed was his current connection.

No clue. Suggest you call Support for urgent help with things of this nature.

No, it just means you killed yourself.

Is that the problem? How about if you explain what you found and if John's guess was on the money...

No, I meant which database stage are you using for the lookup. And I wouldn't burn alot of brain cells wringing my hands and asking why, let's just get it working now, k?

Read my previous post again as it has undergone a little editing.

You could always give it a fake key, a hard-coded value that you ignore. Add an extra column to the stage, mark it as a key and then ignore it (except to select back into it) in your user-defined sql. Something like... SELECT 'X', SQXJOPRG.NEXTVAL FROM DUAL Stick anything in the Key Expression of th...

What stage are you using for the reference lookup? I'll be the first to admit I haven't done the keyless lookup thing recently, and I don't ever recall dealing with a message like that before. Perhaps that's something new with 7.5.x...

And the target table should contain the name of rundate: (i.e.) if suppose we run the job then it should contain the date & time as: 18-12-2006 / 21:00:13. You keep saying target table - do you really mean table as in your output target is a database table? Or do you mean file as people seem to...

I'd also call the routine something more specific, something that explains what you are doing. This is far from a generic routine to pass a value out in the User Status area, so it shouldn't have a generic name. IMHO.

well my code in the routine is like this Function SetUserStatus(V1, V2, V3) if V1='N' then if V2=V3 then Ans = '0'; else Ans = '1'; end if V1='Y' then Ans = '0'; end RETURN(Ans) I'm sorry, but where in this routine do you actually call the SetUserStatus function? You need to do more than just name ...

And who would you be?

Well, we ain't able to give you any help without more details. How did you setup these two notifications? What are the trigger values you've used? Details, man!

How about a clue as to what database you are connecting to with this? SQL Server?

I'd also suggest you post the .odbc.ini entry that was created for this so we can see if it was configured correctly or not.