Thursday, June 18, 2009

MQL Enchancements

  • Modify bus statement has some enhancements, One the of the enhancements is given below. I think this one will be helpful in data migration scripts mostly, but i am sure we will find other uses for this too.MQL Stmt
modify bus current "";
  • Triggers do not fire.
  • History records are not added.
  • No signature affected.

  • MQL Statement "temp query bus" has and new clause with new operators. i think this will be help full for us when we want to show list of objects in particular order(Sorting)
MQL Stmt
temp query bus orderby -type orderby name order +attribute[Color];
  • - for descending + for ascending.

  • Finally an MQL Statment to query connections. I think this MQL statement has been awaited for a long time. Using this mql statement we can query for the connection objects and the attributes in the connections much easier.

MQL Stmt
query connection to "Project Space" "TestProj" 21240970107702 select id;
query connection [type PATTERN];
  • There are many more different options that can be used with this statement. For more information: "help connection" on mql prompt.

No comments:

Post a Comment