Only Routines Import

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
Prashantoncyber
Participant
Posts: 108
Joined: Wed Jul 28, 2004 7:15 am

Only Routines Import

Post by Prashantoncyber »

I have very big dsx file around 400 MB of whole project.
Out of this , I want to import only rountines.
Need ur suggestion.
Thanks
Prashant
kcbland
Participant
Posts: 5208
Joined: Wed Jan 15, 2003 8:56 am
Location: Lutz, FL
Contact:

Post by kcbland »

Either:

1. Import selected and put a big pot of coffee on to brew while you wait for it to dig thru 400MB of data. When it finally comes up, select all of the routines.

2. Make a copy of the dsx file and open it using Wordpad (DON'T USE NOTEPAD!!!) and highlight everything between BEGIN DSJOB and END DSJOB and cut. You'll probably see that all jobs are at the beginning of the file, the routines and metadata are in the middle, and the compiled code is at the end. Try just to leave the first few header lines of the file in place, cut everything up to the beginning of the routines, cut everything after the routines to the end of the file, leaving just the trailer line. You may accidentally delete some routines, depending on if the file was created by doing a full export, or adding jobs/routines individually.

3. Import the .dsx into a junk project, then export the routines when it's finished.

The safest choice is #1, it just will take a LONG time. Better than #3. Only do #2 if you have something stronger than coffee to drink first, preferably something with some kick to it.
Kenneth Bland

Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Prashantoncyber
Participant
Posts: 108
Joined: Wed Jul 28, 2004 7:15 am

Post by Prashantoncyber »

Hi Kenneth,
I shall go with 1st option, Atleast i can have tea :) .
Thanks you for your suggetion.
Prashant
kcbland
Participant
Posts: 5208
Joined: Wed Jan 15, 2003 8:56 am
Location: Lutz, FL
Contact:

Post by kcbland »

Next time do exports by category/folder. You want individual files at least at the folder level, so that you can more easily import specific jobs.

Or look at this post to get a copy of a perl script that explodes a single large dsx file into individual files for each job and each routine.


viewtopic.php?t=85518&highlight=steve+boyce
Kenneth Bland

Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Post Reply