Exporting jobs through DSEXPORT

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
sudeepmantri
Participant
Posts: 54
Joined: Wed Oct 25, 2006 11:07 pm
Location: Hyderabad

Exporting jobs through DSEXPORT

Post by sudeepmantri »

Dear All,

I need to take the export of each jobs in my project (At job level one by one) and put them into VSS for maintaining the versions.

I wrote scripts first to get all the job names form entire project into a .dat file and then I am reading from that file, one line at a time to execute DSEXPORT command.

Everything working perfectly fine but after export of each job a message pops up which needs a key press (enter)..

I dont want to sit and do this all day for all the jobs (there are around 1200 jobs)

Is there any way we can avoid this to automate this functionality completely?

Any help in this regard will be highly appreciated.

Thanks & Regards,
Sudeep
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

What exactly is it asking you to confirm?
-craig

"You can never have too many knives" -- Logan Nine Fingers
sudeepmantri
Participant
Posts: 54
Joined: Wed Oct 25, 2006 11:07 pm
Location: Hyderabad

Post by sudeepmantri »

Sorry for the delayed response....Nothing to confirm...Just a message which says "Omitted XXX read only entries" and a sinlge OK button. I press enter and thats it...can we not automate this "Enter Key Press" or skip this message some how
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Are you sure you're only exporting a single job at a time? That looks like an 'export the whole project' message to me. Can you post your syntax, please?
-craig

"You can never have too many knives" -- Logan Nine Fingers
sudeepmantri
Participant
Posts: 54
Joined: Wed Oct 25, 2006 11:07 pm
Location: Hyderabad

Post by sudeepmantri »

Here goes the syntax

for /F "tokens=1" %%i in (C:\EXPORT\DsxList.dat) do (C:\IBM\InformationServer\Clients\Classic\dsexport /H=FINODS /U=xxxxx /P=xxxxx /JOB=%%i FINODS_2_DEV C:\EXPORT\%%i.dsx)

where C:\EXPORT\DsxList.dat is a file which contains the job names I wanna export.

The command iterates through the list and calls DSEXPORT command creating a file named %%i.dsx (that is Job name.dsx)
sudeepmantri
Participant
Posts: 54
Joined: Wed Oct 25, 2006 11:07 pm
Location: Hyderabad

Post by sudeepmantri »

In some web page I saw to pass on a carriage return to the command by storing the "Enter Key" in a file..But even that did not work out

for /F "tokens=1" %%i in (C:\EXPORT\DsxList.dat) do (C:\IBM\InformationServer\Clients\Classic\dsexport /H=FINODS /U=xxxxx /P=xxxxx /JOB=%%i FINODS_2_DEV C:\EXPORT\%%i.dsx < enter.dat)
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

That would work if the prompt was on the command line. Since this is a dialogue box, that's going to make it more difficult.
-craig

"You can never have too many knives" -- Logan Nine Fingers
sudeepmantri
Participant
Posts: 54
Joined: Wed Oct 25, 2006 11:07 pm
Location: Hyderabad

Post by sudeepmantri »

So any alternate to this??? Or I have to live with this stuff :?
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

I don't know, it's certainly not an issue in 7. Have you asked your official support provider?
-craig

"You can never have too many knives" -- Logan Nine Fingers
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Do you need a /D switch for the domain, the same as dscmdexport?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
homeboy
Participant
Posts: 2
Joined: Wed Jul 02, 2008 5:38 pm

Export Job Without Dialouge Box

Post by homeboy »

Looks like you'll need 8.1 FP 1 with /NODEPENDENTS to run in silent mode. Found http://www-01.ibm.com/support/entdocvie ... wg1JR30121
homeboy
Participant
Posts: 2
Joined: Wed Jul 02, 2008 5:38 pm

Re: Export Job Without Dialouge Box

Post by homeboy »

homeboy wrote:Looks like you'll need 8.1 FP 1 with /NODEPENDENTS to run in silent mode. Found http://www-01.ibm.com/support/entdocvie ... wg1JR30121
Through the forum, I found that /xml runs in silent mode, no dialogue box.

http://dsxchange.com/viewtopic.php?t=12 ... 80d416aa33
lakshmi.vasu
Participant
Posts: 6
Joined: Thu Oct 22, 2009 3:57 am
Location: Bangalore

Re: Exporting jobs through DSEXPORT

Post by lakshmi.vasu »

Hi,
Can you please share the
script to get the list of jobnames from a particular folder in the project and also the script for taking the export of the specified folder which contains multiple jobs in it.

how to call that script or batch file through command prompt.

Please reply ASAP

Thanks in advance..
Thanks,
Lakshmi
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Is there a /O switch for dsexport?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply