DS7 vs DS8 and dsexport vs dscmdexport

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
bcarlson
Premium Member
Premium Member
Posts: 772
Joined: Fri Oct 01, 2004 3:06 pm
Location: Minnesota

DS7 vs DS8 and dsexport vs dscmdexport

Post 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.
It is not that I am addicted to coffee, it's just that I need it to survive.
bcarlson
Premium Member
Premium Member
Posts: 772
Joined: Fri Oct 01, 2004 3:06 pm
Location: Minnesota

Post by bcarlson »

Sorry, forgot the other part of my question. What is the difference between dsexport and dscmdexport?

Thanks!

Brad.
It is not that I am addicted to coffee, it's just that I need it to survive.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post 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.
-craig

"You can never have too many knives" -- Logan Nine Fingers
wfis
Premium Member
Premium Member
Posts: 70
Joined: Wed Feb 28, 2007 2:38 am
Location: India

Post by wfis »

dscmdexport helps to take dsx export only, there is no funcationality to get xml export through dscmdexport as per my understanding.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post 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.
-craig

"You can never have too many knives" -- Logan Nine Fingers
priyadarshikunal
Premium Member
Premium Member
Posts: 1735
Joined: Thu Mar 01, 2007 5:44 am
Location: Troy, MI

Post 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
Priyadarshi Kunal

Genius may have its limitations, but stupidity is not thus handicapped. :wink:
chvenkat.v
Participant
Posts: 94
Joined: Fri Dec 14, 2007 3:22 am

Post by chvenkat.v »

if your problem is resolved then please make this topic as resolved... Smile
DSkkk
Charter Member
Charter Member
Posts: 70
Joined: Fri Nov 05, 2004 1:10 pm

Post 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 !!
g.kiran
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post 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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
zulfi123786
Premium Member
Premium Member
Posts: 730
Joined: Tue Nov 04, 2008 10:14 am
Location: Bangalore

all options for the command dsexport are not found in guide.

Post 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.
priyadarshikunal
Premium Member
Premium Member
Posts: 1735
Joined: Thu Mar 01, 2007 5:44 am
Location: Troy, MI

Post by priyadarshikunal »

have you tried /JOB switch in 7.5? it should work, give it a shot.
Priyadarshi Kunal

Genius may have its limitations, but stupidity is not thus handicapped. :wink:
cgi_bi
Premium Member
Premium Member
Posts: 4
Joined: Wed May 25, 2011 7:50 am
Location: Montreal, Canada
Contact:

7.5 server - /APPEND but only /EXEC

Post 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.
Post Reply