MVSFORUMS.com

[shobhan]

Hi,

Can anyone pls help me out to unload a table using Sort utility(not BMC Utility)?

Have ran the Job using below sort card

//STEP010 EXEC PGM=SORT,PARM='DB2=DB2D'
//SORTOUT DD DSN=WXX262.SORT.UNLOAD.ENROLL,DISP=SHR
//SORTDBIN DD *
SELECT * FROM P72.ROC_ALLOC_GRP_MER_AFFL WITH UR
/*
//SYSIN DD *
SORT FIELDS=COPY
/*

got the result properly,but default values are not getting populated
i.e the field declared as not null.

please do provide any solutions

thanks