Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.
Moderators: chulett, rschirm, roy
-
snassimr
- Premium Member
- Posts: 281
- Joined: Tue May 17, 2005 5:27 am
Post
by snassimr »
Hi !
I wonder if any way to change all ODBC connection names in project by any command ?
If I can insert Enviroment Variable directly to ODBC nam or only through JOB PARAMETER ?
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
-
Contact:
Post
by ray.wurlod »
Only through job parameter. The ODBC stage will not compile unless there is something in the DSN property.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
snassimr
- Premium Member
- Posts: 281
- Joined: Tue May 17, 2005 5:27 am
Post
by snassimr »
I wonder if any way to change all ODBC connection names in project by any command ?
-
chulett
- Charter Member
- Posts: 43085
- Joined: Tue Nov 12, 2002 4:34 pm
- Location: Denver, CO
Post
by chulett »
There seems to be an echo in here.
-craig
"You can never have too many knives" -- Logan Nine Fingers
-
PhilHibbs
- Premium Member
- Posts: 1044
- Joined: Wed Sep 29, 2004 3:30 am
- Location: Nottingham, UK
-
Contact:
Post
by PhilHibbs »
snassimr wrote:I wonder if any way to change all ODBC connection names in project by any command ?
1. Export
2. Search/Replace
3. Import
I use perl to do step 3. but I think you can use a text editor as long as you aren't doing SAP IDoc load jobs.
Phil Hibbs.
Phil Hibbs | Capgemini
Technical Consultant