Data Stage Job Status Values

    The Data Stage Job Status values can be found in
$DSHOME/include/dsapi.h file

  These are the values defined in dsapi.h file for JOB STATUS:

1. #define DSJS_RUNNING        0      /* Job running */
   
2. #define DSJS_RUNOK          1      /* Job finished a normal run with no warnings */
   
3. #define DSJS_RUNWARN        2      /* Job finished a normal run with warnings */
   
4. #define DSJS_RUNFAILED      3      /* Job finished a normal run with a fatal error */
   
5. #define DSJS_VALOK          11       /* Job finished a validation run with no warnings */
   
6. #define DSJS_VALWARN        12      /* Job finished a validation run with warnings */
   
7. #define DSJS_VALFAILED      13      /* Job failed a validation run */
   
8. #define DSJS_RESET          21       /* Job finished a reset run */
   
9. #define DSJS_CRASHED        96      /* Job was stopped by some indeterminate action */
   
10. #define DSJS_STOPPED        97      /* Job was stopped by operator intervention (can't tell run type) */
    
11. #define DSJS_NOTRUNNABLE    98      /* Job has not been compiled */
    
12. #define DSJS_NOTRUNNING     99      /* Any other status */
    

JobStatus

DataStage Version 8 on Information Server

Enterprise PACKs

SAP BW Pack o BAPI: (Staging Business API) loads from any source to BW. o OpenHub: extract data from BW.

SAP R/3 Pack o ABAP: (Advanced Business Application Processing) auto generate ABAP, Extraction Object Builder, SQL Builder, Load and execute ABAP from DataStage, CPI-C Data Transfer, FTP Data Transfer, ABAP syntax check, background execution of ABAP. o IDoc: create source system, IDoc listener for extract, receive IDocs, send IDocs. o BAPI: BAPI explorer, import export Tables Parameters Activation, call and commit BAPI.

Siebel Pack o EIM: (data integration manager) interface tables o Business Component: access business views via Siebel Java Data Bean o Direct Access: use a metadata browser to select data to extract o Hierarchy: for extracts from Siebel to SAP BW.

Oracle Applications Pack o Oracle flex fields: extract using enhanced processing techniques. o Oracle reference data structures: simplified access using the Hierarchy Access component. o Metadata browser and importer

DataStage Pack for PeopleSoft Enterprise o Import business metadata via a metadata browser. o Extract data from PeopleSoft tables and trees.

JD Edwards Pack o Standard ODBC calls o Pre-joined database tables via business views Database Connectivity The common connection objects functionality means the very wide range of DataStage database connections are now available across Information Server products. Latest supported databases for version 8:

DB2 8.1, 8.2 and 9.1

Oracle 9i, 10i, 10gR2 not Oracle 8

SQL Server 2005 plus stored procedures.

Teradata v2r5.1, v2r6.0, v2r6.1 (DB server) / 8.1 (TTU) plus Teradata Parallel Transport (TPT) and stored procedures and macro support, reject links for bulk loads, restart capability for parallel bulk loads.

Sybase ASE 15, Sybase IQ 11.5, 12.5, 12.7

Informix 10 (IDS)

SAS 612, 8.1, 9.1 and 9.1.3

IBM WS MQ 6.1, WS MB 5.1

Netezza v3.1

ODBC 3.5 standard and level 3 compliant

UniData 6 and UniVerse ?

Red Brick Source

New Stages in DataStage Version 8

New Stages in Datastage Version 8 A new stage from the IBM software family, new stages from new partners and the convergence of QualityStage functions into Datastage. Apart from the SCD stage these all come at an additional cost.

WebSphere Federation and Classic Federation

Netezza Enterprise Stage

SFTP Enterprise Stage

iWay Enterprise Stage

Slowly Changing Dimension: for type 1 and type 2 SCDs.

Six QualityStage stages New Functions in Existing Stages

Complex Flat File Stage: Multi Format File (MFF) in addition to existing cobol file support.

Surrogate Key Generator: now maintains the key source via integrated state file or DBMS sequence.

Lookup Stage: range lookups by defining checking high and low range fields on the input or reference data table. Updatable in memory lookups.

Transformer Stage: new surrogate key functions Initialize() and GetNextKey().

Enterprise FTP Stage: now choose between ftp and sftp transfer. Source :