Get Even More Visitors To Your Blog, Upgrade To A Business Listing >>

Awesome BTEQ Mainframe Export Script Example -Data Mode

/*........................................................................................................*/
/*..........................Program Information............................................*/
/*....................................................................................................... */
/* Script = XYY9999.....................................................................*/
/* SCRIPTTYPE=TERADATA Bteq.............................................*/
/* LANGUAGE=UTILITY COMMANDS AND SQL.................... */
/* RUN MODE=BATCH ................................................................. */
/* ------------------------------------------------------------------------------*/
/* PROGRAM DESCRIPTION..........................................................*/
/*..........................................................................................................*/

.SESSIONS 1
.RUN FILE Ilogon;  /*JCL ILOGON -.LOGON CDW/SQL01,WHYNOT;*/
.RUN FILE=IDBENV;  /*JCL IDBENV-DATABASE SQL_CLASS;*/
.EXPORT DATA DDNAME=REPORT

SELECT
    EMPLOYEE_NO,
    LAST_NAME,
   FIRST_NAME,
   SALARY,
   DEPT_NO
FROM EMPLOYEE_TABLE

.IF ERROR CODE > 0 THEN .GOTO DONE
.EXPORT RESET
.LABEL DONE
.QUIT


This post first appeared on SriniTera - Data Analysis Solutions, please read the originial post: here

Share the post

Awesome BTEQ Mainframe Export Script Example -Data Mode

×

Subscribe to Srinitera - Data Analysis Solutions

Get updates delivered right to your inbox!

Thank you for your subscription

×