Query about dscmdexport
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 38
- Joined: Tue Jan 10, 2006 1:25 am
Query about dscmdexport
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.
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.
Thanks & Regards,
Zabi
Zabi
The Correct syntax of the command
for e.g.
Hope that helps.
Code: Select all
usage: dscmdexport [/H][/U][/P][/O] project filepath
Code: Select all
dscmdexport /H=localhost /U=u123 /P=passwd project filepath
Success consists of getting up just one more time than you fall.
-
- Participant
- Posts: 38
- Joined: Tue Jan 10, 2006 1:25 am
-
- Participant
- Posts: 38
- Joined: Tue Jan 10, 2006 1:25 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Prevention is better than cure.
Code: Select all
DEL c:/scratch/project99.dsx
dscmdexport /H=R101 /O=1 dstage99 c:/scratch/project99.dsx
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Re: Query about dscmdexport
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.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.
Go back into Manager, open the Export Components window, uncheck the XML option, close it and then your command line export will work. :D
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 38
- Joined: Tue Jan 10, 2006 1:25 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.
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.
Thanks & Regards,
Zabi
Zabi
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
![Laughing :lol:](./images/smilies/icon_lol.gif)
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.
![Shocked :shock:](./images/smilies/icon_eek.gif)
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 38
- Joined: Tue Jan 10, 2006 1:25 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!
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!
Thanks & Regards,
Zabi
Zabi
You can export one job with this post viewtopic.php?t=98137 using dsexport.exe instead of dscmdexport.exe.
Mamu Kim
-
- Participant
- Posts: 38
- Joined: Tue Jan 10, 2006 1:25 am