echo   "CREATE"
if ($row(TYPE) == ' ' echo " ";
else   
 if ($row(TYPE) == 'I' echo " ";
 else
  if ($row(TYPE) == 'K' echo " ";
  else
   if ($row(TYPE) == 'L' echo " LARGE ";
   else
    if ($row(TYPE) == 'O' echo " LOB ";

echo  "	TABLESPACE $row[name] IN $row[dbname] USING " ;

if ($row[STORTYPE] == 'I' {
 $PQTY = $row[PQTY] * 4;
 $SQTY = $row[SQTY] * 4;
 echo " STOGROUP $row[STORNAME] PRIQTY $PQTY SECQTY $SQTY ";}
else
 echo "	VCAT $row[VCATNAME] ";

if ($row[ERASERULE] == 'Y' 
 echo "	ERASE YES ";
else
 echo "	ERASE NO ";

echo  "	FREEPAGE $row[FREEPAGE] PCTFREE $row[PCTFREE] ";

if ($row[GBPCACHE] == ' ' echo " GBPCACHE CHANGED ";
else
 if ($row[GBPCACHE] == 'A' echo " GBPCACHE ALL ";
 else
   if ($row[GBPCACHE] == 'S' echo " GBPCACHE SYSTEM ";
   else
     if ($row[GBPCACHE] == 'N' echo " GBPCACHE NONE ";


if ($row[TRACKMOD] == ' ' echo " TRACKMOD YES ";
else
 echo " TRACKMOD NO ";

if ($row[LOG] == 'Y' echo " LOG YES ";
else
 echo " LOG NO ";

if ($row[DSSIZE] == 0 echo " ";
else {
 $DS = $row[DSSIZE] / 1048576
 echo " DSSIZE $DSG "; }

 if ($row(TYPE) == 'I' or ($row(TYPE) == 'K' echo " MEMBER CLUSTER ";
	

	NUMPARTS $row[ ]
	( PART $row[ ] 
	  USING
	  VCAT $row[ ]
	  STOGROUP $row[ ]
	  PRIQTY $row[ ]
	  SECQTY $row[ ]
	  ERASE $row[ ]

	FREEPAGE $row[ ]
	PCTFREE $row[ ]

	GBPCACHE $row[ ]

	TRACKMOD $row[ ]

	COMPRESS $row[ ]
	)

echo  "	SEGSIZE $row[SEGSIZE] 	BUFFERPOOL $row[BPOOL] ";

LOCKSIZE $row[ ] 

LOCKMAX $row[ ] 

if ($row[CLOSERULE] == 'Y' echo " CLOSE YES ";
else
 echo " CLOSE NO ";

if ($row[COMPRESS] == ' ' echo " COMPRESS NO ";
else
 echo " COMPRESS YES ";

	CCSID $row[ ]

if ($row[LOCKPART] == ' ' echo " LOCKPART NO ";
else
 echo " LOCKPART YES ";	

if ($row[MAXROWS] == 0 echo " ";
else
 echo " MAXROWS $row[MAXROWS] ";	
	
