DSXchange

hi
you can export the job in two ways
1. By using datastage manager
2. By using dsexport command from the command prompt

what is the problem u are facing from the command prompt

/../datastage7.5/dsexport /job=<jobname> <projectname> <Target DSX path>

This is working fine

RK

Hi
here when u are going to work with hetrogenous data sources
there is no direct stage where u can connect and extract data. you have to manually design the logic and extract the data. i think this feature has to be inculded in coming versions of datastage.

RK

Thanking you paricipants for your response

RK

Hi

i am encountered an error while importing a project from the command prompt.
the error messages is :
Failed to connect to host: 192.168.10.137, project: sap_sales
(Invalid account name supplied (39129))
any one have idea pls let me know
thanks in advance
RK

Hi
you can call ds job from shell script or batch file in windows.
DSjob -run project_name job_name
hope this will work for you

RK

Hi KCBland

In which situation can i use third party scheduler.
when can i schedule jobs using ds scheduler or any third party scheduler.
what are the other advantages when we go for third party scheduler.

Thanks in advance

RK

Hi Srinagesh

your response to the query is appreciable.Thanks for your reply

RK

This message is often seen in corrupted projects. Did anything go wrong during the upgrade or import into this project? Which of the tools is giving you the error (Director, Designer, Manager) or does it happen with all three? Hi Arndw can you give me suggestion that why you are asking this question...

Hi

You can not run any version of DS EE except version 7.5x2 on a Windows platform, and it is only supported on Windows 2003 Server. Some have been able to get it to run on XP Pro, but that is not supported

RK

Hope u are fine with the design in my view try to concentrate on performance area like the transaction size , array size. check whether u are able to connect to database for all the oci stages. why u are not using hash file stage , what is the problem .In general performance wise its better to use h...

Hi

you can use job parameters which can implies to the database connection , user id , password. its better to use dynamic parameterization rather than static parameters


RK

Hi

The version which is latest in the market is 7.5x
expecting release of Version 8 in near future

RK

Hi sarvan

As per the previous discussion you might have got some inputs from the Participants.
From my end regarding update strategy you can find the different update actions while using OCI Stage or ODBC Stage. use the appropriate update action as per your requirement

RK

Hi

You can solve this by using the builtin functions like ICONV and OCONV

where you can convert the date as per your requirement.

Hope your problem be solved

RK

Hi

You can set the Sequencer Mode to "Any" . IF any of the jobs u have connected to the sequencer run without fail then the control will pass to the next Stage on the Sequencer . But you have to design the job such a way that if any job aborts it should be notify you .

RK