EXPORTING ROUTINE

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
sunil_acc
Participant
Posts: 28
Joined: Thu Oct 20, 2005 5:49 am

EXPORTING ROUTINE

Post by sunil_acc »

Hello!
I am stuck up wth a abnormal stuff. I am exporting all jobs (as individual dsx). It goes pretty good. but when i gave thought to import a routinr in same fashion, guess what :( . Gone through a lot of mails but no luck.

Anybody has any clue to this?
DSguru2B
Charter Member
Charter Member
Posts: 6854
Joined: Wed Feb 09, 2005 3:44 pm
Location: Houston, TX

Post by DSguru2B »

I did not get your question. You are having trouble exporting or importing a single routine?
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
sunil_acc
Participant
Posts: 28
Joined: Thu Oct 20, 2005 5:49 am

Post by sunil_acc »

DSguru2B wrote:I did not get your question. You are having trouble exporting or importing a single routine?
I want to import a routine as a single commodity not as part of whole project!
narasimha
Charter Member
Charter Member
Posts: 1236
Joined: Fri Oct 22, 2004 8:59 am
Location: Staten Island, NY

Post by narasimha »

While exporting the routine, in the Options tab - select "By individual component".

HTH
Narasimha Kade

Finding answers is simple, all you need to do is come up with the correct questions.
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

Currently neither the export nor import allow single routines to be selected.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

It can be done, as follows. When you import, choose Import Selected option button. The entire DSX file will be read into memory, but not imported. You can then select the individual component(s) you wish to import, before clicking the Import button. Note that executables may have been exported separately, so you may need to select both the job/routine and its executable to import the complete thing.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

Ray,

I tried that before posting, since I had a vague memory that I had done this before but no routines showed up in my list, this is at 7.5. Are you using V8?
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Can do either at the moment. Just tried it on 7.5.1 and the Routines are there in the export file (and can be imported). Try this export file
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

I just checked my "full export" file - which didn't contain object code or routines ;)
vanathy
Participant
Posts: 7
Joined: Wed Sep 19, 2007 7:09 am
Location: Chennai

Re: EXPORTING ROUTINE

Post by vanathy »

select DataStage Component in the export list, in that go to options tab select by indivijual component. then switch over to components tab. check only the routine box. in that you will be able to see the indivijual routines and you can select which routine that you want to export. if needed you can check the source code also.
sunil_acc
Participant
Posts: 28
Joined: Thu Oct 20, 2005 5:49 am

Post by sunil_acc »

Well,
thanks for all you comment! i can use manager and select all those tabs and check boxes as told by you. But the need is i need some command (as dsexport) to export a routine on the client machine. On top i need only that routine to be exported. I have dne this for job (can export individual job), but need to do same for routine!!!! :roll:
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Exporting a single routine using the command line is not possible.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
jdmiceli
Premium Member
Premium Member
Posts: 309
Joined: Wed Feb 22, 2006 10:03 am
Location: Urbandale, IA

A possible solution and a way to make this easier...

Post by jdmiceli »

Hi all,

I recently posted a bunch of my Perl utilities I have written. One of them will take a single DSX file and split each component part out into their own file. I did this for Release Management and external code versioning that we use at my company. If I remember correctly, it will also split routines and the like into individual files. So, instead of exporting jobs one by one, you could do them all at once and this script will split them for you.

We have been using it with no issues for months now, so I'm confident it should work for you. Follow this link to get the code: viewtopic.php?t=113429&highlight=.

The script you want is called DSX_Cutter.pl. If you have any questions on it that are not answered in the documentation (located in the header of the script) let me know and I'll try to answer your questions.

Bestest,
Bestest!

John Miceli
System Specialist, MCP, MCDBA
Berkley Technology Services


"Good Morning. This is God. I will be handling all your problems today. I will not need your help. So have a great day!"
Post Reply