Persistent Variable access in MII 14.0

[Former Member]

Hi Experts,

I have created persistent variable in shared properties of MII 14.0.

How i can access value of this variable in my SQL query?Is there any table which holds value of these variables?

Thanks in advance

Thanks & Regards,

Neha Jadhav

[swaroop_anasane]

Hi Neha,

You can create a linked server to connnect to this table. Then you can retrieve values from this table.

There need not be any involvement from MII side then.

Thanks,

Swaroop

[Former Member]

Hi Neha,

The table which holds this value is XMII_DB_MEMORY. What exactly is your use case.

Regards,

Anushree

[Former Member]

Dear Anushree,

Thanks you for reply.

I have created some persistent variable in shared properties.

Now i want to schedule SQL query on DB level where i need to pass this persistent variable as input.

How i can access this value from table XMII_DB_MEMORY?

Thanks & Regards,

Neha Jadhav

[Former Member]

Hi Neha,

In case you are using MII to schedule the SQL query here is what you can do:

1) Create the SQL query with a parameter(use param.1, param.2 etc.)

2) Create a transaction using this SQL query

3) Map the parameter of the action block to the persistent variable using Link Editor.

You don't need to use the table.

Regards,

Anushree

[Former Member]

Dear Anushree,

Thank you for reply.

I m not scheduling query in MII. Schedule is required in oracle database.

Can we access values from table you mentioned?

Thanks & Regards,

Neha

[Former Member]

Hi Neha,

I didn't quite understand your question. If you have access to DB you can easily read from the table mentioned

Regards,

Anushree