| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| ESQL Function EXISTS. Difference between V5 and V6 ? |
« View previous topic :: View next topic » |
| Author |
Message
|
| EgilsJ.Rubenis |
 Posted: Tue Jul 31, 2007 4:38 am Post subject: ESQL Function EXISTS. Difference between V5 and V6 ? |
 |
|
Acolyte
Joined: 18 Nov 2002
Posts: 63
Location: Germany, Alfeld
|
Hi there,
i have an simple esql function in a WBIMB V5 esql. After importing the project in to Version 6 i receive an error when creating the bar file.
ERROR
BIP2493E: (.node.function.exists): unalowed type for parameter '1' in function exists.
I haven't found any information regarding a difference between v5 and v6
for the function. Any ideas?
Calling the Function
SET I=1;
WHILE xxx_Exists(I) = DO
SET OutputRoot.MRM.xxx[I] = xxx_Content(I);
SET I = I + 1;
END WHILE;
The Function
CREATE FUNCTION xxx_Exists(Number INT) RETURNS BOOLEAN
BEGIN
DECLARE xxx_Filename CHAR 'xxx' || CAST(Number AS CHAR) || '.CSV';
RETURN EXISTS (SELECT * FROM Environment.yyy.{xxx_Filename});
END;
Thanks,
Egils |
|
| Back to top |
|
 |
| vsr |
| Posted: Tue Jul 31, 2007 6:01 am Post subject: Re: ESQL Function EXISTS. Difference between V5 and V6 ? |
|
|
Centurion
Joined: 04 Apr 2006
Posts: 104
|
| EgilsJ.Rubenis wrote: |
WHILE xxx_Exists(I) = DO
|
The statement should be "WHILE xxx_Exists(I) DO" or is it a typo? |
|
| Back to top |
|
|
| EgilsJ.Rubenis |
| Posted: Tue Jul 31, 2007 6:33 am Post subject: |
|
|
Acolyte
Joined: 18 Nov 2002
Posts: 63
Location: Germany, Alfeld
|
|
| Back to top |
|
|
| vsr |
| Posted: Tue Jul 31, 2007 8:54 am Post subject: Re: ESQL Function EXISTS. Difference between V5 and V6 ? |
|
|
Centurion
Joined: 04 Apr 2006
Posts: 104
|
| EgilsJ.Rubenis wrote: |
RETURN EXISTS (SELECT * FROM Environment.yyy.{xxx_Filename});
|
Try changing the statement as :
RETURN EXISTS (SELECT * FROM Environment.yyy.{xxx_Filename}[]);
-- add braces after '{xxx_Filename}' |
|
| Back to top |
|
|
| EgilsJ.Rubenis |
| Posted: Tue Jul 31, 2007 11:35 pm Post subject: |
|
|
Acolyte
Joined: 18 Nov 2002
Posts: 63
Location: Germany, Alfeld
|
Thanks for the hint.
braces worked
Cheers, Egils  |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
