| Author |
Message
|
| Galichet |
 Posted: Mon Dec 11, 2006 8:49 am Post subject: ESQL with Database : IN possible ? |
 |
|
Acolyte
Joined: 26 Jun 2001
Posts: 69
Location: Paris - France
|
Hi all,
I'm trying to retrieve a list of value from 2 tables with the following esql :
SET OutputRoot.XML.Flow.Content.LIST_Contrat[] = (SELECT T.CONTRAT FROM Database.CF_REGUL_DECOMPTE AS T WHERE T.FLAGDECOMPTE = 'N' AND T.CONTRAT NOT IN (SELECT V.CONTRAT FROM Database.CF_REGUL_JUSTIF AS V));
But the flow cannot be deployed (syntax error)
I'm afraid that 'NOT IN' isn't supported with WBI V5 ?
If this is the case, do you have an elegant means to retrieve what I want (without a passthru)
_________________
Eric Galichet
SMABTP
France |
|
| Back to top |
|
 |
| jefflowrey |
| Posted: Mon Dec 11, 2006 9:33 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
What is the syntax error?
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| Galichet |
| Posted: Tue Dec 12, 2006 12:43 am Post subject: |
|
|
Acolyte
Joined: 26 Jun 2001
Posts: 69
Location: Paris - France
|
Hi,
The error is :
BIP2401E: (.REGUL_MappingPhase1.Main, 40.47) : Erreur de syntaxe : marque attendue = ')' ; marque détectée = 'V'.
_________________
Eric Galichet
SMABTP
France |
|
| Back to top |
|
|
| Galichet |
| Posted: Tue Dec 12, 2006 1:31 am Post subject: |
|
|
Acolyte
Joined: 26 Jun 2001
Posts: 69
Location: Paris - France
|
It's curious, all is ok in the toolkit, the problem occurs only when deploying...
_________________
Eric Galichet
SMABTP
France |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Tue Dec 12, 2006 2:30 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
That looks like it might perhaps be a bug - but you may have to open a PMR to find out for sure.
It should work to do
| Code: |
Set Environment.Variables.Justif[] = (SELECT V.CONTRAT from Database.CF_REGUL_JUSTIF as V);
SET OutputRoot.XML.Flow.Content.LIST_Contrat[] = (SELECT T.CONTRAT FROM Database.CF_REGUL_DECOMPTE AS T WHERE T.FLAGDECOMPTE = 'N' AND T.CONTRAT NOT IN Environment.Variables.Justif[]); |
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
|
|
