how to write routine

sekharg_dw · Post by **sekharg_dw** » Sun Oct 23, 2005 11:31 pm

How to write routine and please explain with simple routine

chulett · Post by **chulett** » Sun Oct 23, 2005 11:36 pm

Same answer as when you asked this over in the PX forum. They are written in the Manager and that's your best resource for examples. All of the routines in there have source code, just double-click on them to see it.

ray.wurlod · Post by **ray.wurlod** » Mon Oct 24, 2005 1:04 am

How To Write Routine (server routine)

Start with a specification of what you want to achieve. The specification is written in normal language, for example English.

Formalize the input arguments needed; seek opportunities to make a more flexible reusable component.

Determine whether your need is a before/after subroutine or a transform function.

Have the specification reviewed (for example peer review). If it's a business requirement, have the business sign off that the specification is correct.

Design test data that ensure that invalid values, boundary conditions, and so on are handled appropriately.

Translate into DataStage BASIC, save, compile and test. Fix any syntax errors that prevent compilation. If any test result does not yield what was expected, investigate and correct the situation.