Ray Wurlod

P.O. Box 1214

ABN 57 092 448 518

North Sydney  N.S.W.  2060

Education and Consulting Services

Australia

 

Email: rayw@mindless.com

 

 

Custom Coding of DataStage BASIC Routines

 

This page outlines the elements of DataStage BASIC custom coding, one of the services offered by this business.

 

Delivered at the end of the engagement is a report outlining what was produced, the test data that were used and test results, as well as a DataStage export file including the routine(s).

 

Specification

Routines are written to your specification.  If required, assistance may be provided in developing a formal specification document from an informal one.

 

Types of Routine

All of the following types of routine can be programmed.

  • Transform functions
  • Before/after subroutines
  • Job control routines

 

Documentation

Documentation provided as part of the engagement includes the following:

  • Design documents
  • DataStage documentation (included in developed Routines themselves)
  • Test data
  • Test report

 

DataStage Best Practices

Naming of objects follows any of your in-house standards that have been advised.  Otherwise our own standards are applied

Where alternative techniques exist, the most efficient will be implemented.

 

Samples

A set of sample routines is available for download from here in standard DataStage export format (dsx) suitable for version 7.5.

In Internet Explorer, right-click on the link and choose Save Target As…

File size is approximately 66KB.

 

Testing and Quality Assurance

Test data are developed with or without your assistance.  Some tests may be included in the specification document.

Any other restrictions are documented within the routine code and/or general description.

A report showing test data values, expected and actual results is provided.

 

Versioning

All routines are supplied as version 2.0.0.

(Version 1.x.x routines do not allow for named arguments.)

 

Copyright

Unless other arrangements are made, this business will continue to assert copyright ownership over any routines developed.

Permission to use the routines will be granted in writing to you, ordinarily with unfettered right to use but not to redistribute.

 

 

 

 

DataStage is a trademark of International Business Machines Corporation.

Formally the product name is IBM® Websphere® DataStage.

IBM and Websphere are registered trademarks of International Business Machines Corporation.

 

This page is copyright © 2006, Ray Wurlod. All rights reserved.

Page last updated 18 July 2006.