MS SQL Uproc Template

This is an uproc template to execute SQL queries in MS SQL from Dollar Universe.

Descriprion

This is an uproc template to execute SQL queries in MS SQL from Dollar Universe.


Uproc description

The Uproc accepts the following variables:



    • SQL_SERVER: This is the name of the SQL Server instance

 

    • SQL_FILE: This is the SQL file to execute

 

    • SQL_DATABASE: This is the name of the database to connect to

 

    • SQL_LOGIN: Username to use to connect to MS SQL

 

    • SQL_PASSWORD: Password to use to connect to MySQL

 

    • SQL_LOG: Log to store the output (optional)

 

    • DISPLAY_JOBLOG: Display the output in the Job Log (Y or N)



This is a Windows uproc.

 

 

 

Prerequisites: MS SQL client installed locally.

 

Implementation: This has to be imported in Dollar Universe with the "uxins UPR" command.

0

Operating Systems

Applications


Versions

Created by....

A member of the Automic Community


Login to View or Leave Comments