HOW TO WRITE ROUTINES

adisheshu.dwh · Post by **adisheshu.dwh** » Wed Jan 07, 2009 5:38 am

HI HOW TO WRITE ROUTINES IN MANAGER AND HOW TO CALL THAT PLS HELP ME STEP BY STEP,TAKE UR OWN EXAMPLE

ArndW · Post by **ArndW** » Wed Jan 07, 2009 6:02 am

Once again, all capitals is considered SHOUTING. This site is used as a supplement to training and experience and doesn't serve as a complete substitue for it. Writing routines is documented in the literature and taught as part of the DataStage courses. I think that, for the most part, the posters here are not willing to duplicate the documentation by writing a step-by-step tutorial for how to write the DS/Basic routines here.

If you ask specific questions to portions of the question that you are stuck on, you will surely get many responses; but a general question such as what you asked is certainly not going to get the answer you expect.

ray.wurlod · Post by **ray.wurlod** » Wed Jan 07, 2009 4:14 pm

1. Obtain the requirement.
2. Design the algorithm, considering other possibilities and documenting why you made particular choices. Design test data.
3. Convert your specification into DataStage BASIC code in a new Routine of the appropriate type.
4. Compile the routine. Fix the first error and re-compile. Repeat until no errors.
5. Test (not applicable for before/after subroutines).