SriniTera

BTEQ Mainframe export JCL real example. //B09XYZD2 JOB (T,AA,XYZ),'BTEQ' TEMPATE', CLASS=S, MSGCLASS-0, //  REGION=6M,NOTIFY=B09XYZ //* //*+JBS BIND TDPO.UP //* //*---------------------------------------------------------------- //*  JOB INFORMATION AND COMMENTS //*---------------------------------------------------------------- // JOBLIB DD DSN=C309.BOSNCR.NM.R60.APPLOAD,DISP=SHR // DD DSN=C309.BOSNCR.NM.R60.TRLOAD,DISP=SHR //*---------------------------------------------------------------- //BTEQ1 EXEC PGM=BTQMAIN //LOGON    DD  DSN=B09XYZ.APPLUTIL.CLASS.JCL(ILOGN),D //IDBENV   DD  DSN=B09XYZ.APPLUTIL.CLASS.JCL(IDBENV),D //SYSIN    DD  DSN=B09XYZ.APPLUTIL.CLASS.JCL(BTEQSCPT) //SYSPRINT DD  SYSOUT=*

You may think that Teradata is super faster in handling data requests. The background is Parsing engine. It handles efficiently. I have given complete functions to your read now.   Basic functionalities of Teradata Parsing Engine It handles session control Logon/Logoff Managing Session BYNET AMP Other functions Acts like parser Parse and Optimize SQL requests Dispatching optimized plan to AMPs over BYNET Send Query result back to requesting client Responsible for Hashing data Flow diagram: Session control --> Parser --> Optimizer--> Dispatcher Locally couples SMP Nodes in multi node system Carries message between AMPs and PEs Communication between nodes -point to point broadcast Merges answer sets back to PE Performs DB and file management operations: - Finding requested rows - LOCKS - Sorting - Joins - Output data conversion -Accounting/Journaling