Query about dscmdexport

Zabeerulla · Post by **Zabeerulla** » Tue Jul 11, 2006 2:48 am

Hi,

The dscmdexport command is a command line application and can be run unattended. But when I use the command for e.g.
dscmdexport /H=R101 /O=1 dstage99 c:/scratch/project99.dsx, from the command line it pops up a window and says "The project99.dsx file already exists. Do u want to replace it?". Actually before running the command there was no file with name project99.dsx in the scratch directory.

Can u please me what's wrong here.

loveojha2 · Post by **loveojha2** » Tue Jul 11, 2006 3:34 am

The Correct syntax of the command

Code: Select all

usage: dscmdexport [/H][/U][/P][/O] project filepath

for e.g.

Code: Select all

dscmdexport /H=localhost /U=u123 /P=passwd  project filepath

Hope that helps.

Zabeerulla · Post by **Zabeerulla** » Tue Jul 11, 2006 4:00 am

Hi,

The problem is not with the syntax. When it executes, its asking for to replace the existing file. When I say yes, it's exporting all the jobs to that file. The problem is there is no file in that path for which I am exporting the project.

loveojha2 · Post by **loveojha2** » Tue Jul 11, 2006 4:17 am

Try with /O=y

Zabeerulla · Post by **Zabeerulla** » Tue Jul 11, 2006 4:38 am

That's not working!

ray.wurlod · Post by **ray.wurlod** » Tue Jul 11, 2006 5:39 am

Prevention is better than cure.

Code: Select all

DEL c:/scratch/project99.dsx
dscmdexport /H=R101 /O=1 dstage99 c:/scratch/project99.dsx

chulett · Post by **chulett** » Tue Jul 11, 2006 6:34 am

Zabeerulla wrote:it pops up a window and says "The project99.dsx file already exists. Do u want to replace it?". Actually before running the command there was no file with name project99.dsx in the scratch directory.

Known 'bug' or issue with it where it wants to delete a non-existent export file. Your last manual export via Manager was done using the XML option instead of DSX and that screws up the command line export.

Go back into Manager, open the Export Components window, uncheck the XML option, close it and then your command line export will work. :D

Zabeerulla · Post by **Zabeerulla** » Tue Jul 11, 2006 6:49 am

I found the issue regarding this.

This is the problem with Manager. I have used the Manager for exporting jobs as XML Document. After that if u try to run from the Command line which exports as dsx file, we'll get this replace file window.

Before running the dscmdexport command, Go into the 'Export DataStage Components' and uncheck the "Export as XML Document" option.

ray.wurlod · Post by **ray.wurlod** » Tue Jul 11, 2006 6:53 am

Did you "find" that solution because Craig had posted it a mere 15 minutes before your post?

chulett · Post by **chulett** » Tue Jul 11, 2006 6:58 am

Hopefully, they 'found' it by searching the forums. I had the issue awhile back and helped someone else figure out an approach when they wanted to leave the XML option checked and still do command line exports.

They ended up scripting a registry hack that 'unchecked the option' first in the export script, performed the export and then restored the checked option.

I was quite impressed.

Zabeerulla · Post by **Zabeerulla** » Tue Jul 11, 2006 7:18 am

Ray,

I was working on the dscmdexport command. In the meanwhile I needed to export one job. So I used the Manager, there I unchecked the XML option as I wanted it in dsx format. After I resumed to dscmdexport issue, then it was working properly. So I thought this may be the issue.

Thanks to all!

kumar_s · Post by **kumar_s** » Tue Jul 11, 2006 5:40 pm

So coincidence. Found by yourself.

kduke · Post by **kduke** » Tue Jul 11, 2006 8:29 pm

You can export one job with this post viewtopic.php?t=98137 using dsexport.exe instead of dscmdexport.exe.

Zabeerulla · Post by **Zabeerulla** » Fri Jul 14, 2006 5:18 am

Thanks Kim.

The information was very useful.

DSXchange

Query about dscmdexport

Query about dscmdexport

Re: Query about dscmdexport