Multiple Routines compile

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
datisaq
Participant
Posts: 154
Joined: Wed May 14, 2008 4:34 am

Multiple Routines compile

Post by datisaq »

Is there any option in Datastage for compiling multiple routines at a time like "Multiple Job compile"?

And one more thing I have a job that uses a routine.
Suppose if i didn't compile the routine and compile the job only.
Did the routine will also get compile or not ?Or we need to compile separately?


Pls help me out..
IBM Certified - Information Server 8.1
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

The Multiple Job Compiler will compile routines. As to your other questions - no, yes.
-craig

"You can never have too many knives" -- Logan Nine Fingers
cfuller
Premium Member
Premium Member
Posts: 70
Joined: Mon Mar 24, 2003 10:08 pm
Location: Australia

Post by cfuller »

In your installation directory there is a command line utility called 'dscc' that will allow you to compile your routines. When releasing code to new projects I invoke the following to ensure everything is compiled -

dscc /h <host> /u <user> /p <password> <Project> /j * /r * /f /rd <logfile> /rt T /jt -1

Just fill in the require pieces.

Good luck
:)
Regards
Chris Fuller

"Reality is what refuses to go away when you stop believing in it"
datisaq
Participant
Posts: 154
Joined: Wed May 14, 2008 4:34 am

Post by datisaq »

Thanks craig and cfuller for the help..

I'm able to compile through "dscc" cmd.
IBM Certified - Information Server 8.1
ag_ram
Premium Member
Premium Member
Posts: 524
Joined: Wed Feb 28, 2007 3:51 am

Post by ag_ram »

chulett,
chulett wrote:The Multiple Job Compiler will compile routines.
Can you please elaborate it saying how we can achieve this because i dont find any documentation on how to compile Routine as well by Multiple Job Compiler nor the proper search results from DSXchange.

Frankly saying i can not make Multiple Job Compiler list out available routines in the Project to be compiled.

Please clarify this.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Hmmm... There's a checkbox on the first page of the Wizard to 'Compile Custom Server Routines' but you don't seem to need to enable it. I just simply (and only) check the 'Show Manual Selection page' then click Next.

Under Project Contents you'll find Jobs, Custom Server Routines and Custom Parallel Stage Types. All of your custom / user written routines should be listed once you pop open that branch, then you can move them over to the Select Items pane and have them compiled.

What are you seeing or not seeing there? :?
-craig

"You can never have too many knives" -- Logan Nine Fingers
ag_ram
Premium Member
Premium Member
Posts: 524
Joined: Wed Feb 28, 2007 3:51 am

Post by ag_ram »

There's a checkbox on the first page of the Wizard to 'Compile Custom Server Routines' but you don't seem to need to enable it
There is no such checkbox in the wizard in the DataStage i use(v7.5x2).

I see only checkboxes - Server, Parallel, Mainframe, Sequence, Only select uncompiled Jobs, Show Job Selection page.

Is it anyway depedending on the version we do use?
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Apparently. Probably a problem with your 'x2' version, I would guess. [shrug]
-craig

"You can never have too many knives" -- Logan Nine Fingers
ag_ram
Premium Member
Premium Member
Posts: 524
Joined: Wed Feb 28, 2007 3:51 am

Post by ag_ram »

The check boxes Custom Server Routines and Custom Parallel Stage Types are not available in DataStage v7.5x2. Help pages do not ensure availability of such options in the wizard.

They are available in DataStage v7.5.1.
Post Reply