Can anyone help me with accessing the property which is mentioned in user defined policy using esql on compute node.

Hi

You can declare a variable outside the module part of you ESQL which references your UDP. What's important is that the variable must be spelled exactly the same as your UDP, else it won't work.

Example:

DECLARE configGroup EXTERNAL CHARACTER 'default_group';

CREATE COMPUTE MODULE TransportOrder_Compute
    CREATE FUNCTION Main() RETURNS BOOLEAN
    BEGIN
        SET OutputRoot.JSON.Data.Config = configGroup;
        
        IF configGroup = 'PROD' THEN
            SET OutputRoot.JSON.Data.Status = 'Operational';
        END IF;

        RETURN TRUE;
    END;
END MODULE;

Can anyone help me with accessing the property which is mentioned in user defined policy using esql on compute node.

Hi,

Thanks for the reply however, my actual requirement is to access user defined policy with in the ESQL node without using any java code.

Hi

You can declare a variable outside the module part of you ESQL which references your UDP. What's important is that the variable must be spelled exactly the same as your UDP, else it won't work.

Example:

DECLARE configGroup EXTERNAL CHARACTER 'default_group';

CREATE COMPUTE MODULE TransportOrder_Compute
    CREATE FUNCTION Main() RETURNS BOOLEAN
    BEGIN
        SET OutputRoot.JSON.Data.Config = configGroup;
        
        IF configGroup = 'PROD' THEN
            SET OutputRoot.JSON.Data.Status = 'Operational';
        END IF;

        RETURN TRUE;
    END;
END MODULE;

Can anyone help me with accessing the property which is mentioned in user defined policy using esql on compute node.

Can anyone help me with accessing the property which is mentioned in user defined policy using esql on compute node.

Hello Narender,  

 You can access it in ESQL via java calls.  

Please see this for the details: 

Accessing a user-defined policy by using ESQL - IBM Documentation  

Can anyone help me with accessing the property which is mentioned in user defined policy using esql on compute node.

Can you guide me to use Java integration project(Java package) instead of JCN node to call user defined policy in esql.

Hello Narender,  

 You can access it in ESQL via java calls.  

Please see this for the details: 

Accessing a user-defined policy by using ESQL - IBM Documentation  

Can anyone help me with accessing the property which is mentioned in user defined policy using esql on compute node.

Perhaps it would be better for you to share your use case? It maybe that creating a UDP and then using a policy to over ride it achieves the same thing?

Can you guide me to use Java integration project(Java package) instead of JCN node to call user defined policy in esql.

Hello Narender,  

 You can access it in ESQL via java calls.  

Please see this for the details: 

Accessing a user-defined policy by using ESQL - IBM Documentation  

Can anyone help me with accessing the property which is mentioned in user defined policy using esql on compute node.

I have created a java integration project with class and method. And created an external procedure with java as external name in esql. And referenced the java project to application. But when I try to deploy the bar iam getting an error java methods could not be found in workpath/shared-classes directory.

Perhaps it would be better for you to share your use case? It maybe that creating a UDP and then using a policy to over ride it achieves the same thing?

Can you guide me to use Java integration project(Java package) instead of JCN node to call user defined policy in esql.

Hello Narender,  

 You can access it in ESQL via java calls.  

Please see this for the details: 

Accessing a user-defined policy by using ESQL - IBM Documentation  

Can anyone help me with accessing the property which is mentioned in user defined policy using esql on compute node.

Hi,

Have you placed the JAR file inside the shared-classes directory of the integration node?

I have created a java integration project with class and method. And created an external procedure with java as external name in esql. And referenced the java project to application. But when I try to deploy the bar iam getting an error java methods could not be found in workpath/shared-classes directory.

Perhaps it would be better for you to share your use case? It maybe that creating a UDP and then using a policy to over ride it achieves the same thing?

Can you guide me to use Java integration project(Java package) instead of JCN node to call user defined policy in esql.

Hello Narender,  

 You can access it in ESQL via java calls.  

Please see this for the details: 

Accessing a user-defined policy by using ESQL - IBM Documentation  

Can anyone help me with accessing the property which is mentioned in user defined policy using esql on compute node.

Hi,

Can please specify which jar needs to be added as I have already added jplugin. And when I created a new java project and re compiled with bar issue has been resolved and bar file is deployed. But when iam trying to call the java method after reaching to mbpolicy.getpolicy() method iam getting source folder not found tab I have added the message flow in the message flow container but still getting the error. If I press f6 the method is returning null(Policy or property not found). Ihave added the relevant sbips fyr.

Hi,

Have you placed the JAR file inside the shared-classes directory of the integration node?

I have created a java integration project with class and method. And created an external procedure with java as external name in esql. And referenced the java project to application. But when I try to deploy the bar iam getting an error java methods could not be found in workpath/shared-classes directory.

Perhaps it would be better for you to share your use case? It maybe that creating a UDP and then using a policy to over ride it achieves the same thing?

Can you guide me to use Java integration project(Java package) instead of JCN node to call user defined policy in esql.

Hello Narender,  

 You can access it in ESQL via java calls.  

Please see this for the details: 

Accessing a user-defined policy by using ESQL - IBM Documentation  

Can anyone help me with accessing the property which is mentioned in user defined policy using esql on compute node.

Go to java prespective , create java project , put the class into it , after this right click on the java project , select build path , then configure build path .

in the screen will open the libraries tab and the select add external jars from the right add below 2 jars :

• jplugin2.jar
• javacompute.jar

from this path :
C:\Program Files\IBM\ACE\12.0.12.19\server\classes

Hi,

Can please specify which jar needs to be added as I have already added jplugin. And when I created a new java project and re compiled with bar issue has been resolved and bar file is deployed. But when iam trying to call the java method after reaching to mbpolicy.getpolicy() method iam getting source folder not found tab I have added the message flow in the message flow container but still getting the error. If I press f6 the method is returning null(Policy or property not found). Ihave added the relevant sbips fyr.

Hi,

Have you placed the JAR file inside the shared-classes directory of the integration node?

I have created a java integration project with class and method. And created an external procedure with java as external name in esql. And referenced the java project to application. But when I try to deploy the bar iam getting an error java methods could not be found in workpath/shared-classes directory.

Perhaps it would be better for you to share your use case? It maybe that creating a UDP and then using a policy to over ride it achieves the same thing?

Can you guide me to use Java integration project(Java package) instead of JCN node to call user defined policy in esql.

Hello Narender,  

 You can access it in ESQL via java calls.  

Please see this for the details: 

Accessing a user-defined policy by using ESQL - IBM Documentation  

Can anyone help me with accessing the property which is mentioned in user defined policy using esql on compute node.