Page 1 of 3

Help on dsexport

Posted: Sun Nov 27, 2005 11:32 pm
by Andal
I am having a problem while using dsexport. By using the parameter /JOB , i am able to export a individual job. But the problem is , it is not exporting the job executables.

Is there any way to achive this. I am using

Code: Select all

C:\Progra~1\Ascential\DataStage7.5\DSExport.exe /U=<userid> /P=<pwd> /H=<host> /JOB= <jobname> <projectname> <Target DSX name>

Posted: Sun Nov 27, 2005 11:39 pm
by jenkinsrob
Hi Andal,

What exactly are you trying to achieve??

You can export datastage jobs via the Datastage Manager. Here you have the option to include job executables in your export.

Posted: Mon Nov 28, 2005 12:01 am
by Andal
Hi jenkinsrob,

We have to export certain jobs frequently. So i am trying to automate it by giving the jobnames as input.

I wrote a batch file , which will take jobnames as input and append to the the specified DSX. But my problem is, i am not able to get the job executables.

Posted: Mon Nov 28, 2005 12:04 am
by rkdatastage
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

Posted: Mon Nov 28, 2005 12:11 am
by jenkinsrob
Hi Andal,

As far as I know there is no way to export job executables from the command line...

Thats not to say it cant be done :)

Posted: Mon Nov 28, 2005 12:13 am
by loveojha2
I agree with jenkinsrob. Neither its possible with dsexport nor with dscmdexport.

Posted: Mon Nov 28, 2005 12:16 am
by Andal
Hey Love,

If you are using dscmdexport , it is taking the whole project, which contains Job executables also.

Hi RK,

The export is done without any problem, But the dsx doesnt contain the job executables.

Posted: Mon Nov 28, 2005 5:26 am
by ray.wurlod
The export is done without any problem, But the dsx doesnt contain the job executables. I think we'll just have to agree that such is the current state of the technology. You might like to lodge an enhancement request. It's not a big problem - just means that you will need to re-compile jobs after importing them.

Posted: Mon Nov 28, 2005 5:34 am
by Andal
Ray,

We are posting these jobs directly to Customers. So we have to give the executables also. I will ask my manager to lodge a enhancement request.

Posted: Mon Nov 28, 2005 5:42 am
by ray.wurlod
Sounds like your workaround needs to be a DSX "cutter". Export the entire project, then keep only the header, the job and the job executable. And, of course, any dependent objects, including routines and routine executables.

Layout of a DSX (or XML) export file is easily understood by inspection.

Posted: Mon Nov 28, 2005 5:52 am
by kcbland
Here's a DSX-Cutter you can use, export the whole project and then fire this script at the .dsx file. It explodes every object into a stand-alone file. You're free to expand the functionality however you like.

viewtopic.php?t=85518&start=0

Posted: Mon Nov 28, 2005 7:53 am
by snassimr
Hi !

Similar to Andal's way

I try to use dsexport within routine and the cmd and dsexport process hung up . I ran the command within cmd of Windows and it runs ok .

I use ExecDOS routine with some changes ? Do you know whats the problem ?

Posted: Mon Nov 28, 2005 10:15 pm
by Andal
Thanks Ray and Ken for Suggesting the Solutions. I wrote my own DSX splitter in VB long way back, but that doesnt solve my purpose. Because if we are posting a job to customer means we did some modifications on that job. So definetly we have to export the job from our development area only.

I posted this thread bcoz, in some of the earlier posts i have read that we have to do some modifications of manager settings in windows registry to make dsexport to work properly. so i thought that there woluld be some settings like that to achevie my solution.

Posted: Tue Nov 29, 2005 1:05 am
by WoMaWil
Why do you need the executables directly? Does not a commandline compile-Tool solve your problem as well?

Wolfgang

Posted: Tue Nov 29, 2005 1:35 am
by Andal
commandline compile-Tool
I am not aware of this. Are you talking about "dsjob". Please clarify.