DSXchange

Posted: **Thu Jul 31, 2008 10:44 am**

Anyone got the 'single job' export to work in Version 8?

I have a script that among other things exports a named job, then imports the dsx into a target project and recompiles. Except in Version 8, the dsexport command fails with a window informing me .....

Code: Select all

Run time error '91'

Object Variable or With block variable not set

(which error I seem to recall from my days as a VB developer!) Here's the relevant part of the batch file

Code: Select all

SET DSExportCmd=C:\IBM\InformationServer\Clients\Classic\DsExport.exe 

SET Domain=braeval:9080
SET Host=littlemill
SET User=clarkep4
SET Password=[censored]
SET Job=%1
SET Project=misa_dev_2a

Echo Exporting %Job%

%DSExportCmd% /D=%Domain% /H=%Host% /U=%User% /P=%Password% /JOB=%Job% %Project% %Job%.dsx

%1 is passed as the Job Name. Am I doing something obviously dumb?

Posted: **Thu Jul 31, 2008 10:49 am**

I have used this and it works but I would adhere to the export in designer as it is robust and simple to use.

Posted: **Thu Jul 31, 2008 11:06 am**

Designer Export is fine, but my script is intended to do a lot more than just export - it will ultimately interact with a source code control process and it is irritating that I cannot include the export step in the batch, especially as it worked fine in v7.5.

Do you have an example of a command line that works, in case I am doing something wrong with the params?

Posted: **Thu Jul 31, 2008 12:10 pm**

There is no /JOB argument for dscmdexport. Besides your host needs to add the port number, e.g. littleemial:31538.

Posted: **Thu Jul 31, 2008 3:25 pm**

The server port number can be omitted if the default is still in use, so this command looks fine.

Please note that this will also include dependent objects of the Job, and if any are ReadOnly you will get a GUI dialog box after export to say that they were omitted from the export.

I suspect that your VB error is a peculiarity of this job and needs investigation by your support provider.

DSXchange

Using dsexport in v8

Using dsexport in v8