DSXchange

Hi, theese commands can be run in several ways: 1. from administrator via the command window. 2. from DS basic code using the DSExecute routine with TCL or execTCL. 3. from command line, after loading the dsenv being int the engine directory and runing bin/uv, then use LOGTO <project name>; now you...

Hi All,
Where do I run the ANALYZE.FILE or HASH.HELP commands to analyze a hash file.
I tried running at the - C:\Ascential\DataStage\Engine\bin prompt but it failed.
Please assist

Thanks in advance,
Nilotpal.

Hi,
There are coming from 3 different transformers.

I am on Wintows 2000 (DS version 7.0).
I cannot get the transactional grouping feature when I apply multiple links to a OCI stage.

Please advise.
Thanjks in advance.

Hi Ray, Pls correct me if i am wring. What I have understood from your tip is that If i create a physical file(hash) then I should be fine. I could not understand the - "container must have a means of sending its results out". If I amcreating the hashfile physically then it is available to...

Hi, As per a design directive I need to use hashfiles as lookups. So I have to pre-load my oracle dimension table in a hashfile. I proceeded the following way: 1) Created a shared container where I did the following: OCI -------> Transformer ----------------> Hashfile Hashfile stage has following se...

Unfortunately, you have to use a common data type model, and that is what DataStage is doing. When importing definitions, they are translated into the common model. When loading data, the metadata is cast into the target table type. Whatever DataStage imports as metadata is what should be (in most ...

Hi, How do I import the ODBC table definitions exactly as present in my Oracle tables. For all columns that have varchar2(n) definition in Oracle, Datastage is defaulting them to varchar(19). Date type of columns is becoming Timestamp in datastage after importing the table definitions. Is there any ...

Hi All,
How do i run a server job from command line.


Thanks,
Nilotpal.

Hi Ray,
Thanks for yoyr prompt response. Please advice if the parrel extender is available as part of standard suite or we need to purchase it seperately.

I have installed Datastage but I am not getting any menu option like -Datastage Parallel Extender.

Please advice.

Thanks.
Nilotpal.

Hi All, I need to load files of 1 GB and upwards in Oracle 9i database. As of now I have one-to-one mapping. The datastage server job is taking around 40 minutes to do the same. When I use SQLLDR along with the control files (in a conventional path load) I take around 5 minutes. Is possible to reach...

Hi All, I need to load files of 1 GB and upwards in Oracle 9i database. As of now I have one-to-one mapping. The datastage server job is taking around 40 minutes to do the same. When I use SQLLDR along with the control files (in a conventional path load) I take around 5 minutes. Is possible to reach...

Hi All, I am using DSSendMail on unix. When i try to execute the command from a routine, I get the following error: Arg1 = nroy@abc.com - ** This is my To Address Arg2 = paritosh@xyz.com - ** this is my From Address Arg3 = Testing from Xavient - ** THis is my Subject Arg4 = Testing - ** this is the ...

Hi All, I need to execute the mailx command on unix from data stage I am unable to append my Message body; My Command is: MailCmd = "mailx -s " : ArgSubject : " " : "abc@hotmail.com " : "n" : ArgMessageBody But i am not getting the mail. I have also tried repl...

Hi Ray, I have modified the code as follows: [/ $include UNIVERSE.INCLUDE ODBC.H ** PREPARE for DATABASE CONNECTION** status = SQLAllocEnv(HENV) status = SQLAllocConnect(HENV, HDBC) status = SQLConnect(HDBC, "DSNNAME", "UID", "PWD") CALLSTMT = "CALL SP_TEST(":...