Running queries in IAPI

August 29, 2007 at 11:16 am | Posted in Troubleshooting | 3 Comments

Just noticed this post in the EMC Forums. The user wanted to know how to run a query in IAPI. Many of the answers talk about using execquery and readquery and so on which is all well and good, however there is a really nifty IAPI command that can run the query and display the results. If you read this blog regularly you will notice I use it a lot.

Using the ‘?’ command will run a query e.g.

?,c,select r_object_id,r_version_label from dm_document where object_name = 'template 1'

produces output like this:

r_object_id       r_version_label
----------------  --------------------------------
0900022b80003bfd  CURRENT
                  1.0
(1 row affected)

no need for next, get and close commands, it’s all done for you by IAPI.

Advertisements

3 Comments »

RSS feed for comments on this post. TrackBack URI

  1. very useful tip.. thx for sharing.

  2. Thanks Robin. I was the one who left the post.

    Where can I find info on that xsense tool?Is it expensive???

  3. The Xense Profiler can be purchased online at http://www.xense.co.uk/xense_profiler_purchase.htm . A single user licence is just $500.


Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Blog at WordPress.com.
Entries and comments feeds.

%d bloggers like this: