🎉Community Raffle - Win $25

An exclusive raffle opportunity for active members like you! Complete your profile, answer questions and get your first accepted badge to enter the raffle.
Join and Win

How to Pass a Table Name variable within a ODBC Connection?

User: "Al_22614"
Al_22614
Altair Community Member
Updated by Al_22614

I have several COM automation jobs where Monarch Classic connects to a data source on an AS400.  Usually the connection is hard coded with the Monarch Project.  I have a requirement to pass the data source name (e.g. VENAFILE.TABLENAME) where TABLENAME contains the month year (e.g., 0224 within VENAFILE.DSA0224 table name).  Is it possible use a dynamically passed the full table name within the COM automation session with an AS400?

The Monarch programmer's guide mentions ODBC connection but does not provide examples.  If anyone has experience using user defined variables (specifically data source name) within COM Automation/AS400 sessions, please provide sample VBA or VBScript that I can edit for my purpose.

Many thanks in advance.

Al 

Find more posts tagged with

English
Monarch
v2023.1
Quick Links