User Defined Environment variables
Moderators: chulett, rschirm, roy
User Defined Environment variables
Hi,
In which file the user defined environment variables defined in director will be stored in datastage?
My requirement is to extract the user defined einvironment variables in Unix using shell script.
with regards,
MCH
In which file the user defined environment variables defined in director will be stored in datastage?
My requirement is to extract the user defined einvironment variables in Unix using shell script.
with regards,
MCH
harshakumar mc
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Whence arose that rather odd requirement?
What about all the other environment variables? Technically every environment variable is user-defined. The "User Defined" category in the Administrator client is just a nicety - you can create them anywhere (if you know how).
What about all the other environment variables? Technically every environment variable is user-defined. The "User Defined" category in the Administrator client is just a nicety - you can create them anywhere (if you know how).
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
All,
In the project we are using user defined variables in datastage jobs.
But in Oracle Load method we have to
a) disable the triggers as well, But this option is not present in the oracle Enterprise stage.
b) Some of the columns in the table having constraints which refer to the some other column in the same table.
So we need to alter the exection of enabling constraints, then only load method works fine.
To do above tasks we need have connection information for oracle.
with regards,
Harsha
In the project we are using user defined variables in datastage jobs.
But in Oracle Load method we have to
a) disable the triggers as well, But this option is not present in the oracle Enterprise stage.
b) Some of the columns in the table having constraints which refer to the some other column in the same table.
So we need to alter the exection of enabling constraints, then only load method works fine.
To do above tasks we need have connection information for oracle.
with regards,
Harsha
harshakumar mc
mc_harsha wrote:All,
In the project we are using user defined variables in datastage jobs.
But in Oracle Load method we have to
a) disable the triggers as well, But this option is not present in the oracle Enterprise stage.
b) Some of the columns in the table having constraints which refer to the some other column in the same table.
So we need to alter the exection of enabling constraints, then only load method works fine.
To do above tasks we need have connection information for oracle.
with regards,
Harsha
harshakumar mc
Not clear. I dont understand your requirement. Where do you want to use this connection information? In a third party tool? Disabling triggers can be done in the open command in the oracle enterprise stage. Regarding load options search for "APT_ORACLE_LOAD_OPTIONS" in the forum here, and read through the documentation on the stage.
Ping me if I am wrong...
Hi,BugFree wrote:Not clear. I dont understand your requirement. Where do you want to use this connection information? In a third party tool? Disabling triggers can be done in the open command in the oracle enterprise stage. Regarding load options search for "APT_ORACLE_LOAD_OPTIONS" in the forum here, and read through the documentation on the stage.
Thanks for your replay..
Is it possiable to execute multiple commands in open command?
ex:
ALTER TABLE RMSGAP.ITEM_MASTER DISABLE CONSTRAINT SYS_C006240 ;
ALTER TABLE RMSGAP.ITEM_MASTER DISABLE CONSTRAINT SYS_C006241 ;
with regards,
harsha
harshakumar mc
Code: Select all
Use it to specify a command, in single quotes, to be parsed
and executed by the Oracle database
Ping me if I am wrong...
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: