Page 1 of 1
DS7 vs DS8 and dsexport vs dscmdexport
Posted: Thu Oct 15, 2009 7:50 am
by bcarlson
We are migrating from DS7.51a to DS8.0.1 and have need to make some XML exports of jobs from both sides.
On the DS8 side, the dsexport seems to be doing what we need and exporting all related items for a job (buildops, table defs, etc.). However, the same command does not appear to give full output for DS7.
Were there changes to the export process between DS7 and DS8?
Brad.
Posted: Thu Oct 15, 2009 7:51 am
by bcarlson
Sorry, forgot the other part of my question. What is the difference between dsexport and dscmdexport?
Thanks!
Brad.
Posted: Thu Oct 15, 2009 10:50 am
by chulett
Can't speak to the 8.x side, but on earlier releases the dscmdexport exports an entire project whereas dsexport is for a single job.
Posted: Mon Oct 19, 2009 12:30 am
by wfis
dscmdexport helps to take dsx export only, there is no funcationality to get xml export through dscmdexport as per my understanding.
Posted: Mon Oct 19, 2009 7:24 am
by chulett
chulett wrote:Can't speak to the 8.x side, but on earlier releases the dscmdexport exports an entire project whereas dsexport is for a single job.
I've played with the commands on the 8.x side and found there that they can both pull an export of the entire project.
Posted: Mon Oct 19, 2009 8:49 am
by priyadarshikunal
it seems like the dsexport and dscmdexport are the same in 7.x and 8.0. Not talking about 8.1 as it has istools but comment made by both Craig and wfis are correct.
As Far as 8.0 is concerned:
dscmdexport exports entire project in dsx format.
while dsexport provides additional options for exporting like
/XML to export in xml format
/EXEC for expoting only executables (for dsx format only)
/APPEND for appending to an existing file.
/JOB to export specific job.
for details go through Designer Client guide.
I don't know why its not giving identical output in 7.5.1a
Posted: Wed Oct 21, 2009 3:54 am
by chvenkat.v
if your problem is resolved then please make this topic as resolved... Smile
Posted: Thu Apr 01, 2010 8:37 am
by DSkkk
priyadarshikunal wrote:
while dsexport provides additional options for exporting like
/XML to export in xml format
/EXEC for expoting only executables (for dsx format only)
/APPEND for appending to an existing file.
/JOB to export specific job.
Hi Priyadarshi :
When i use the dsexport command to export an executable it says that the option "/EXEC" can only be used in conjunction with a "/JOB" option. Can you please provide the Syntax of the command that needs to be used to export the executable. Thanks in advace !!
Posted: Thu Apr 01, 2010 3:54 pm
by ray.wurlod
All syntax is to be found in the manuals.
You can also type the command alone or with a --HELP option (in most cases) to get a usage summary.
all options for the command dsexport are not found in guide.
Posted: Tue Nov 02, 2010 4:23 am
by zulfi123786
ray.wurlod wrote:All syntax is to be found in the manuals.
You can also type the command alone or with a --HELP option (in most cases) to get a usage summary.
I see that the manual for DataStage Manager 7.5 says the command dsexport has the following options:
dsexport.exe /H hostname /U username /P password /O omitflag project
pathname1
/JOB is not available in 7.5x ?
I cant use the help flag as the designer is not installed over my PC we connect through an intermediate windows server.
Posted: Wed Nov 03, 2010 3:41 am
by priyadarshikunal
have you tried /JOB switch in 7.5? it should work, give it a shot.
7.5 server - /APPEND but only /EXEC
Posted: Fri Feb 24, 2012 9:01 am
by cgi_bi
Hello,
DS 7.5 Server
I tried this command and it works
dsexport.exe /H=>host> /U=<user> /P=<password> /JOB=<job name> /Append /EXEC <project> <dsx file>
b
But if I take off /EXEC it says me that /APPEND should be used in conjunction with /EXEC.
It seem that in DS 7.5 Server we can append to a DSX only executable jobs.