DATASTAGE——一DATASTAGE经验积累(20070621)

 一、JOB的分类与作用（？）
        1、Server JOB:
        最为常用的Job类型，Job可以组合使用，Server Job是Job的最小单位。
        原文档：If you have the Web Services pack installed an additional check box, Web Service Enabled, appears. Select it to indicate the job can be made available as a web service.
        2、Parallel JOB:
        3、Mainframe JOB:运行于大型机的JOB。
　　4、JOB Sequences:Job Sequence主要用于Job间的协作工作控制，如各Job的实行流程，出错处理，文件监控等。

二、jobstatus的用法      

        jobstatus
       –jobstatus waits for the job to complete, then returns an exit code derived
        from the job status.

        命令格式为：
        dsjob –run
        [ –mode [ NORMAL | RESET | VALIDATE ] ]
        [ –param name=value ]
        [ –warn n ]
        [ –rows n ]
        [ –wait ]
        [ –stop ]
        [ –jobstatus]
        [–userstatus]
        [-local]
        project job

三、判断NULL值
　　实例
        STAGE ：JOIN STAGE
        设置：
                           LEFT JOIN
                           左输入语句：SELECT * FROM PMP_Insured_Amount
                           右输入语句：SELECT COL_ID
                                                                  ,TAB_NAME
                                                                  ,WORK_DATE
                                                                 ,REF_COLUMN1 AS UNIQUE_ID_IN_SRC_SYS