Import multiple jobs

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
vish08
Premium Member
Premium Member
Posts: 16
Joined: Mon May 12, 2008 8:45 am

Import multiple jobs

Post by vish08 »

I have multiple individual jobs(dsx files) that need to be imported into current porject.
It is taking time to import all jobs and for compiling them
What would be easy way to do this?
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Concatenate the dsx files together and import them all at once. Then use the Multiple Job Compiler to compile them all at once.
-craig

"You can never have too many knives" -- Logan Nine Fingers
vish08
Premium Member
Premium Member
Posts: 16
Joined: Mon May 12, 2008 8:45 am

Post by vish08 »

I am getting .dsx files from ClearCase which need to be imported into project.
I am not sure how to concatnate them?Could you please elaborate on it?
nagarjuna
Premium Member
Premium Member
Posts: 533
Joined: Fri Jun 27, 2008 9:11 pm
Location: Chicago

Post by nagarjuna »

search for DSXCUTTER and DSXCONCATENATE ....you can find the perl script posted by one of our dsxchange member ...
Nag
swades
Premium Member
Premium Member
Posts: 323
Joined: Mon Dec 04, 2006 11:52 pm

Post by swades »

vish08 wrote:I am not sure how to concatnate them?Could you please elaborate on it?
Open DSX in notepad and concate them to a single file or else FTP to unix and use concate command...
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

For DOS:

Code: Select all

copy a.dsx+b.dsx+c.dsx d.dsx
For UNIX:

Code: Select all

cat a.dsx b.dsx c.dsx > d.dsx
fyi - either one supports wildcards.
-craig

"You can never have too many knives" -- Logan Nine Fingers
swades
Premium Member
Premium Member
Posts: 323
Joined: Mon Dec 04, 2006 11:52 pm

Post by swades »

chulett wrote:For DOS:
copy a.dsx+b.dsx+c.dsx d.dsx
Good to Know :D ....Never used DOS command.
kduke
Charter Member
Charter Member
Posts: 5227
Joined: Thu May 29, 2003 9:47 am
Location: Dallas, TX
Contact:

Post by kduke »

Not sure you can combine DSX files. There is a header record at the begining of each DSX file. It may ignore these when you try to import but I would not count on it.
Mamu Kim
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

I'm 99% sure it handles them just fine. I'll run a quick test later and see.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply