Need a routine to create and run a Procedure.

sagar deshmukh · Post by **sagar deshmukh** » Wed Dec 02, 2009 6:50 am

Hi,

I am new to routines..I need a help about writing a routine..which will create a procedure and will execute it.

Thanks
Sagar

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Wed Dec 02, 2009 8:06 am

Routine "to create a procedure" ?

Maybe you need to clarify what you need in more detail.

chulett · Post by **chulett** » Wed Dec 02, 2009 8:31 am

Maybe.

For the 'execute' part... DSExecute().

ray.wurlod · Post by **ray.wurlod** » Wed Dec 02, 2009 1:21 pm

There is a DVD available from DSXchange Learning Center entitled Programming with DataStage BASIC which sounds like exactly what you want/need. Much of this training relates to creation of server routines of both kinds (transform function and before/after subroutine).