All environment variables are stored in DSParam file in your project directory. But this is not the best approach. And also i dont know any other way. So use it, but very carefully, till the time someone here has a better approach.
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.
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.
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
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.
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.
Hi,
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 ;