nithinlenin
New User
Joined: 06 Feb 2007 Posts: 19 Location: Hyderabad
|
|
|
|
Hi I need help regarding the following
There is a table with some 20 million records .. It is estimated that if the table is summarized with respect to some fields, the number of records will get considerably reduced.
I need to write a JCL to do the same . As far as i have figured out , we require 3 steps
1)Dowloads data from table to flat file
2)Runs a sort job using SUMFILEDS to summarise the file
3)Uploads the job back to a table
Am i moving in the right direction.. Is there any other way out
The table i need to summarise is MSPPOC.MST_INTL_POS_SUM with the following layout
OUTL_ID CHAR ( 7 ) NOT NULL
, SVC_PROD_CLS CHAR ( 1 ) NOT NULL
, ACCT_DT DATE NOT NULL
, LEG_ACCT_DT DATE NOT NULL
, POS_DIV CHAR ( 3 ) NOT NULL
, REVNU_CTRCT_TYPE CHAR ( 2 ) NOT NULL
, REVNU_SRC CHAR ( 3 ) NOT NULL
, CNTRY_NM CHAR ( 15 ) NOT NULL
, HOST_REVNU_DSTRC CHAR ( 3 ) NOT NULL
, ND_FO_ORIG CHAR ( 3 ) NOT NULL
, ND_FO_DEST CHAR ( 3 ) NOT NULL
, ND_LEG_ORIG CHAR ( 3 ) NOT NULL
, ND_LEG_DEST CHAR ( 3 ) NOT NULL
, USE_AL CHAR ( 3 ) NOT NULL
, PLATE_AL CHAR ( 3 ) NOT NULL
, JNT_VNTR_CD CHAR ( 1 ) NOT NULL
, MATCH_STAT CHAR ( 1 ) NOT NULL
, MKT_ENT_ABBR CHAR ( 1 ) NOT NULL
, MKT_SUBENT_ABBR CHAR ( 6 ) NOT NULL
, LEG_ENT_ABBR CHAR ( 1 ) NOT NULL
, LEG_SUBENT_ABBR CHAR ( 6 ) NOT NULL
, USE_RAMT DECIMAL ( 13 , 2 ) NOT NULL
, FE_BASE_CAMT DECIMAL ( 11 , 2 ) NOT NULL
, FE_OVRD_CAMT DECIMAL ( 11 , 2 ) NOT NULL
, BEST_BE_CAMT DECIMAL ( 11 , 2 ) NOT NULL
, BEST_BE_GSA_CAMT DECIMAL ( 11 , 2 ) NOT NULL
, FO_PCNT INTEGER NOT NULL
, LEG_PCNT INTEGER NOT NULL
, FUEL_SCHRG_AMT DECIMAL ( 11 , 2 ) NOT NULL
I need to summarise the table with following fields
SVC_PROD_CLS
,ACCT_DT
,LEG_ACCT_DT
,POS_DIV
,REVNU_CTRCT_TYPE
,REVNU_SRC
,CNTRY_NM
,HOST_REVNU_DSTRC
,ND_FO_ORIG
,ND_FO_DEST
,ND_LEG_ORIG
,ND_LEG_DEST
,USE_AL
,PLATE_AL
,JNT_VNTR_CD
,MATCH_STAT |
|