Data sources

This tab view provides access to all databases defined in the Database Connections list. It is a convenience device for reports that make use of multiple databases and/or schemas without changing the default database/schema set in the Main resources tab.

• Resources - DBconnection
  This pop-up list contains all connections defined in the Administrator utility.

• Resources - Database/Source/Fields browser
  This portion of the Data sources view has three columns: Database, Source and Field. Schema ("database" for some RDBMS) shows all available schemas in the selected connection; source shows all available tables and views in the selected schema. Clicking on any table name will display in the Field column all fields contained in the selected table.
  
  • SCHEMA (DATABASE)
    shows all schemas ("databases" in some RDBMS terminology) in alphabetical order.
    
  • SOURCE
    shows all tables and views in the selected schema listed in alphabetical order. To load a table name (e.g. into a selected Retrieval object) click the table name or drag it into the object.
    
  • FIELDS
    shows all fields of the selected table listed under Source. To load a database field into an object in the Workspace (e.g. Retrieval, Calculation, etc.), select the object, then click on the field name.

• Resources - Operators and Dividers
  Operators and dividers are used in Calculations and Conditional statements. To load one of these into the selected object in the Workspace, click on the desired symbol or drag it. They consist of:

  

  +	Plus	==	Equal
  -	Minus	!=	Not equal
  X	Multiply	AND	Logical AND
  /	Divide	OR	Logical OR
  =	Assign value of	[	Start of variable name
  >	Greater than	]	End of variable name
  >=	Greater or equal	(	Start of group
  <	Less than	)	End of group
  <=	Less or equal	;	End of statement

• Resources - Components
  Components are the executable building blocks of the procedural flowcharts. To drag an object from the Palette to the Workspace, grab the icon with the mouse, and start dragging. The functionality and the usage is explained under Working with Components.