Follow-On Topics

Related Topics

# Technical Summary

## Working with other Tools

The other tools that the Call Stored Procedure (OLEDB) Step will interact directly with, whether by exposing information to it or consuming information from it, are listed below.

### Consuming from Other Tools

Icon | Tool Name | Tool Category
--- | --- | ---
| Import Flat File | Input
| Convert XML to Recordset | Format
| Create Workflow Job | Format
| Format as Flat File | Format
| Format as HTML | Format
| Format as Text | Format
| Run Crystal Report | Format
| Run Microsoft Reporting Services | Format
| Run Microsoft Word (Merge) | Format
| Filter Data | General

### Objects Consumed

Objects that the Call Stored Procedure (OLEDB) Step consumes that are exposed by other Steps are listed below.

|  | Recordset — Information structured into columns and rows

|  | Variables (Text) — Textual data is extracted from selected Variables

|  | Documents (Text) — One or multiple plain text documents

|  | Documents (HTML) — One or multiple HTML documents

|  | Documents (Paged HTML) — One or more multiple paginated HTML documents

|  | Documents (PDF) — One or multiple PDF documents

|  | Documents (RTF) — One or multiple RTF documents

|  | Documents (XML) — One or multiple XML documents

|  | Documents (CSV) — Output from a Run Crystal Report Step

### Exposing to Other Tools

Note that the below depends whether Call Stored Procedure (OLEDB) is outputting recordsets, variables, or XML.

Icon | Tool Name | Tool Category
--- | --- | ---
| Convert Recordset to XML | Format
| Convert XML to Recordset | Format
| Create Workflow Job | Format
| Transfer File (FTP) | Output
| Run External Program | Execute
| Filter Data | General

### Objects Exposed

Objects that the Call Stored Procedure (OLEDB) Step exposes that can be utilised by other Steps are listed below.

|  | Recordset — If an Input Recordset has been selected from a Step previously created in the Task, then it displays the columns included in the recordset. These are then supplied as the RecordSource to the next Step in the Task.

|  | Document Source — If a Document Source has been selected from a Step previously created in the Task, then it displays the columns included in the recordset used by the Step. These are then supplied as a DocumentSource to the next Step in the Task.

|  | Memory Definitions — Displays a list of Memory Definitions created for the Step and the columns to be memorised for each one. Double-clicking on a Memory Definition then opens the applicable memory configuration dialog box to enable the details to be edited.

|  | Properties — A number of properties for the Step are exposed in the Environment tab of the Task Browser dialog box.

## Dependencies

The products, technologies, protocols or systems that are required for the Call Stored Procedure (OLEDB) Step to work are listed below.

|  | Functional OLEDB Provider supporting exposure of Procedures and/or Functions

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