Checks if DB rows available

Last published at: May 2nd, 2023

Description:

Checks if DB rows available

Inputs

  • connectionString– Connection
  • changeDatabase-- Connect to different database description 
  • sqlStatement– SQL statement multiline
  • variableName – Variable/Global to store the record count
  • commandTimeOut – Command timeout value 

Returns

  • True – step executed successfully
  • False – step failed to execute 

Usage:

Example:

Let’s build and execute the hasDBRowsDef example.          

  • Create a new definition called “hasDBRowsDef
  • Select the definition and click the “design” button
  • Drag a hasDBRows step from the toolbox
  • Connect the dots between the start and hasDBRows step 

  • Click on the “hasDBRows” step to configure its properties
  • Configure the following values for the properties as shown on the below graphic
  • Save the process definition, create a process instance and execute. Step should check database rows available or not. 
  • Render the process instance to view the result stored in the variable/global.