Semarchy.com Tutorials Community
Start Now

Semarchy xDI

  • Release Notes
    • xDI 2023.2 Release Notes
    • xDI 2023.1 Release Notes
    • xDI 5.3 Release Notes
  • Install Semarchy xDI
    • Architecture
    • System requirements
    • Install the Designer
    • Configure the Designer
      • Manage the License
      • Choosing your JVM
    • Install Components
    • Install the Runtime
    • Configure the Runtime
      • Runtime Services
      • Runtime Security
      • External Value Resolvers
      • Session Logging
      • Delivery Repositories
      • Java Options
      • Runtime Parameters Reference
      • Runtime Scheduler
    • Install Analytics
    • Install the License Server
    • Configure the License Server
  • Upgrade Semarchy xDI
    • Upgrade the License Server
    • Upgrade the Designer
    • Upgrade the Runtime
    • Upgrade Analytics
  • Design Integration Flows
    • Get Started with Semarchy xDI Designer
      • Design-Time Views
      • Runtime Views
    • Work With Projects
      • Source Control
      • Advanced Features
    • Connect To Your Data
      • Set Up Your Environment
        • Install Components
        • Install and Manage Modules
        • Import Templates
      • Metadata and Reverse Engineering
        • Define a Database Model
        • Define a File Model
        • Define an XML Model
      • Enable Data Quality
      • Externalize Metadata Values
    • Work With Mappings
      • Create Mappings
      • Filters
      • Join Sources
      • Template Parameters
      • Advanced Topics
        • Change Data Capture (CDC)
        • Rejects Management
        • Stage the Sources
        • Deserialize Source Data
        • User-Defined Functions
    • Work With Processes
      • Create a Process
      • Execution Flow
      • Sub-Processes
      • Steps Repetition
      • Parameters
      • Linked Metadata
      • Scripting
    • Work with Variables
    • Work with Metadata Configurations
  • Components
    • Semarchy xDM
      • Release Notes
      • Getting Started
    • Actian Avalanche
      • Release Notes
      • Getting Started
    • Actian VectorWise
      • Release Notes
      • Getting Started
    • Amazon
      • Release Notes
      • Amazon Redshift
        • Redshift
        • Loading Data into Amazon Redshift via S3 Buckets
      • S3
    • AMQP
      • Release Notes
      • Getting Started
    • Avro
      • Release Notes
      • Getting started
    • Base
      • Release Notes
      • Certificates and Keys
        • Getting started
      • HSQL
        • Getting Started
      • H2
        • Getting Started
      • Kerberos
        • Getting started
      • Email
        • Getting Started with Email Server
      • LDAP
      • ODBC
        • Work with ODBC Datasources
    • Cassandra
      • Release Notes
      • Getting Started
    • Change Data Capture
      • Release Notes
      • CDC for DB2/400
    • CMIS
      • Release Notes
    • Couchbase
      • Release Notes
      • Getting Started
    • DBase
      • Release Notes
      • Getting Started
    • Delivery Repository
      • Google Storage Delivery Repository
        • Release Notes
    • Elasticsearch
      • Release Notes
      • Getting started
      • Search Guard Security
    • Google BigQuery
      • Release Notes
      • Getting Started
    • Google Cloud Platform Component
      • Release Notes
      • Getting Started
      • Cloud Storage
        • Getting Started
    • Google Sheets
      • Release Notes
      • Getting Started
      • Upgrade from API V3 to V4
    • Greenplum
      • Release Notes
      • Getting Started
    • Hadoop
      • Release Notes
      • HBase
        • Getting Started
        • Management Tools
        • Importtsv Tool
      • HDFS
        • Getting Started
      • Hive
        • Getting Started
      • Impala
        • Getting Started
      • Sqoop
        • Getting Started
    • HTTP REST
      • Release Notes
      • Getting Started
      • Retrieve response in one field
    • HyperFile SQL
      • Release Notes
      • Getting Started
    • IBM DB2
      • Release Notes
      • DB2 UDB
        • Getting Started
      • DB2/400
        • Getting Started
        • CCSID Reverse
    • IBM Lotus Notes
      • Release Notes
      • Getting Started
    • IBM Netezza
      • Release Notes
      • Getting Started
    • Informix
      • Release Notes
      • Getting Started
    • InterSystems Caché
      • Release Notes
      • Getting Started
    • JMS
      • Release Notes
      • Getting Started
    • Kafka
      • Release Notes
      • Getting Started with Kafka Raw Metadata
      • Getting Started with Kafka Structured Metadata
    • MemSQL
      • Release Notes
      • Getting Started
    • Microsoft Access
      • Release Notes
      • Getting Started
    • Microsoft Azure
      • Release Notes
      • SQL Database
        • Getting Started
      • Blob Storage
        • Getting Started
    • Microsoft Azure Table Storage
      • Release Notes
      • Getting started
    • Microsoft Excel
      • Release Notes
      • Getting Started
    • Microsoft SQL Server
      • Release Notes
      • Getting Started
      • BULK INSERT Configuration
    • MonetDB
      • Release Notes
      • Getting Started
    • MongoDB
      • Release Notes
      • Getting Started
    • MySQL
      • Release Notes
      • Getting Started
    • Oracle
      • Release Notes
      • Oracle Database
        • Getting Started
        • Slowly Changing Dimensions
        • Oracle SQL*Loader
      • Oracle RDB
        • Getting Started
      • Oracle BI
        • Getting Started
    • Paradox
      • Release Notes
      • Getting Started
    • Parquet
      • Release Notes
      • Parquet
    • PostgreSQL
      • Release Notes
      • Getting Started
    • Privacy Protect
      • Release Notes
      • Getting Started
    • Progress OpenEdge
      • Release Notes
      • Getting Started
    • Salesforce
      • Release Notes
      • Getting Started
      • Salesforce Replicator Incremental Mode
      • Attach Files to Records
      • Work with Relations
    • Sampling
      • Release Notes
      • Getting Started
    • SAP
      • Release Notes
      • Getting Started
    • SAP ASE
      • Release Notes
      • Getting Started
    • SAP Hana
      • Release Notes
      • Getting Started
    • SAP IQ
      • Release Notes
      • Getting Started
    • SAP SQL Anywhere
      • Release Notes
      • Getting Started
    • Semarchy xDM
      • Release Notes
      • Getting Started
    • Snowflake
      • Release Notes
      • Getting Started
    • Spark
      • Release Notes
      • Getting Started
    • SQreamDB
      • Release Notes
      • Getting Started with SQreamDB Database
    • Stored Procedure
      • Release Notes
      • Getting Started
    • Teradata
      • Release Notes
      • Getting Started
    • Twitter
      • Release Notes
      • Getting Started
    • Vertica
      • Release Notes
      • Getting Started
  • Deploy Integration Flows
    • Generate Packages
    • Generate Deliveries
    • Deploy Deliveries
    • Run Deliveries
    • Schedule Deliveries
    • Designer CLI
    • Runtime Commands
      • General Commands
      • Service Management
      • Delivery Management
      • Session Management
  • Manage Production
    • Configure Analytics
      • Runtimes
      • Log Databases
      • Profiles
      • Environments
      • Statistics
      • Preferences
    • Manage Runtimes
    • Configure Metadata
    • Manage Sessions
    • Manage Deployments
      • Create a Delivery Project
      • Manage Package Manager Versions
      • Manage Deployments
      • Advanced Deployment
      • Delivery Project Supervisor
      • Source Management Editor
    • Management REST API
  • Actions Reference
    • File Actions
      • Move Files
      • Copy Files
      • Delete Files
      • Write a File
      • Make a Directory
      • Zip Files
      • BZip File
      • GZip File
      • Tar Files
      • Unzip File
      • BUnzip File
      • GUnzip File
      • Untar File
      • Wait for Files
      • Concat Files
      • XSLT Transformation
    • Internet and Networking
      • Get Files with FTP
      • Send Files with FTP
      • Run FTP Commands
      • Run SFTP Commands
      • Send Email
      • Read Emails
      • Send Files with SCP
      • Get Files with SCP
      • Run SSH Commands
      • Send JMS File Message
      • Receive JMS File Message
      • JMS Operation Action
      • AMQP Send Message
      • AMQP Receive Message
      • AMQP Operation
      • AMQP Send File
      • AMQP Receive File
    • Misc
      • Sleep
      • Operating System Command
      • Start Delivery
      • Empty Action
      • Raise Error
      • Variable Manager
    • Script
      • Java Native Scripting
      • Bean Scripting Framework
    • SQL
      • SQL File Export
      • SQL Operation
      • SQL To Parameters
    • xDM Tools
      • Get LoadID
      • Submit Load
      • Get Load Status
      • Cancel Load
    • Other Tools
      • CDC
        • CDC for DB2/400
        • CDC DB2/400 Read Journal Data
      • Replicator
        • Replicator Rdbms to Snowflake
      • Snowflake
        • Snowflake - Snowpipe Operation
        • Snowflake - Upload File to Storage
    • License Information
Semarchy xDI 2023.2
  • Semarchy xDI
    • 2025.1
    • 2024.4
    • 2024.3
    • 2024.2
    • 2024.1
    • 2023.4
    • 2023.3
    • 2023.2
    • 2023.1
    • 5.3
  • Semarchy xDI
  • Components
  • Stored Procedure
2025.1 2024.4 2024.3 2024.2 2024.1 2023.4 2023.3 2023.2 2023.1 5.3

This is documentation for Semarchy xDI 2023.2, which is no longer supported.

For more information, see our Global Support and Maintenance Policy.

Stored Procedure Component

Overview

Stored Procedure Component contains the necessary resources to work with databases stored procedures.

Install the Stored Procedure Component

The Stored Procedure Component is installed from Semarchy xDI Designer using the component installation feature.

Getting Started with SQreamDB Database Release Notes

Copyright © Semarchy - all rights reserved.