on 08-25-2010 3:33 PM
Dear all,
Is there a way to create local or transaction variable dynamically inside the BLS transactions.
I have a scenario where in i am reading the XMl document and based on the number of node (sub node ) items i need to temporary save those values into transaction variable . I want to use these saved transaction variable tvalues o later insert into database
closed as un resolved
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
you cannot dynamically create a local property. If you need to store values, maybe one of the following ideas may help you:
- create a XML property. You can append nodes with values as you need it
- create an Illum doc. You can add new rows later on
- if you want to store XML contents, you can use the queue actions. Create a queue and push XMLs on it. You can easily read those values afterwards
Michael
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
I am already having my data in the XML .
Now i want to read the nodes ( number of nodes may be varying ) and store values temporarily . This values needs to be pushed into Database table records.
Since i do not know how many nodes the incoming XML would have , i can not pre create total number of local or transaction variable to store the values .
What other best options are available
Suggestion please
After reading your second post, I wonder why you want to temporarily store the separate values from the XML node in a local property.
If you already have all values available in a XML, than it would be easier to process the XML directly in MII, as that is what MII does best. MII can directly access the node values and use it as input for your databse inserts. Using a repeater action, you can process 0 to n nodes. Use XPath to transfer the node values to the query parameters.
Is this the option you are looking for, or do I miss something?
Michael
User | Count |
---|---|
13 | |
6 | |
3 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.