How do I get a count of database records?

View some of the Frequently Asked Questions to our support staff. Included are some tips and tricks making this forum ideal for users getting started with GoAnywhere Director. Note: Users can reply to existing topics but only our support staff can add new topics to this forum.

How do I get a count of database records?

Postby Support_Duane » Fri Mar 06, 2009 12:38 pm

To your project:

  • Add an SQL task and select the database resource you want to use.
  • Add a query element, and specify the following SQL statement. For example:
    select count(*) from libraryName.fileName
  • Specify a variable name in the Output Variable field (e.g. "data")
  • Then add a Set Variable task, found in the Miscellaneous folder.
  • Enter a variable name (call it "count" for now) and then using variable notation, specify column one of the rowset defined in the Output Variable above. (e.g. ${data[1]})
Now the variable count contains the number of records the query has returned. You can use this variable to conditionally execute/skip a task or module.

The snippet below shows what the project would look like:

Code: Select all
    <sql resourceId="resourceName">
            <query outputVariable="data">
                      <statement>select count(*) from table</statement>
             </query>
    </sql>
    <setVariable name="count" value="${data[1]}" />
Support_Duane
Support Specialist
 
Posts: 66
Joined: Thu Mar 05, 2009 3:49 pm

Return to Knowledge Center

Who is online

Users browsing this forum: No registered users and 1 guest