cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
447
Views
0
Helpful
4
Replies

IPCC Express - Programatically change db Datasource name in script.

marydoyle9
Level 1
Level 1

Hello - is there a way to programatically change the database Datasource name for database Read step in the script? The read step has a pre-populated dropdown list of datasource names which I assume come from the defined names in the system. I would like to be able to dynamically point to either TEST or PROD database (table names identical, DSN is different).

Thanks!

Mary

4 Replies 4

I looked at the link but found nothing that addressed the datasource names.

Amine-K
Level 1
Level 1

Why don't you try a SWITCH or IF step and have 2 DATABASE READ steps each one with a different DSN depending on the condition of the SWITCH or IF step.

Thank you for the suggestion. That would definitely work but I was hoping for something that might be a little "cleaner" since we have a couple of sripts that read/write to quite a few tables.

Getting Started

Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: