Follow-On Topics

Related Topics

# About Memory Definitions

Memory Definitions are used to specify the data, generated by a task at run-time, to be memorised. Users must have permission to use Memory Definitions, configured in the Memory Access tab of the User Properties dialog box.

Four Memory Definition types are available as follows:

|  | Internal Memory — The data is stored in a Repository

|  | ODBC Memory — Memorises data using an ODBC compliant data source and, if required, writes it back into the database

|  | OLEDB Memory — Memorises data using an OLEDB compliant data source and, if required, writes it back into the database

|  | Call Stored Procedure Memory — Runs a stored procedure using a OLEDB compliant data source, and stores the results in whatever format is required

Any number of Memory Definitions may be created for a task step.

## Features

The following are just a few of the features provided by Memory Definitions:

Internal Memory

|  | Using a Data Filter Step, the current Repository data for a Task may be compared to a new recordset produced at Task run time to filter the data passed to the Output Step for processing

|  | Repository data may be exported as an XML file or CSV file for backup purposes or use in other applications

|  | Previously exported XML files may be imported into King Task Centre

|  | Previously exported or new CSV files may be imported into King Task Centre

|  | A Repository may be selected for use in any Task so that different columns may be populated from different data sources

|  | Repository data values may be manually edited, rows deleted or the Repository "reset" by deleting all the data

|  | The Repository schema may be edited to change column details, insert columns or delete columns to match the data source

ODBC Memory

|  | Memorise data using an ODBC compliant data source

|  | Free-type and graphical generation of SQL Statements

|  | Transaction support

|  | Memorise based upon VBScript rules

OLEDB Memory

|  | Memorise data using an OLEDB compliant data source

|  | Free-type and graphical generation of SQL Statements

|  | Transaction support

|  | Memorise based upon VBScript rules

Call Stored Procedure Memory

|  | Memorise data using an OLEDB compliant data source supporting stored procedures

|  | Map values to procedure parameters

|  | Transaction support

|  | Memorise based upon VBScript rules

The following dialogs are provided for managing Memory Definitions:

|  | Memory Definitions

|  | Internal Memory

|  | ODBC Memory

|  | OLEDB Memory

|  | Call Stored Procedure Memory

Copyright © 2018 Quadrant Software B.V. All rights reserved.