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 ";
	

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

if ($row[LOCKRULE] == 'A' echo " LOCKSIZE ANY ";
else
 if ($row[LOCKRULE] == 'P' echo " LOCKSIZE PAGE ";
 else
  if ($row[LOCKRULE] == 'R' echo " LOCKSIZE ROW ";
  else
   if ($row[LOCKRULE] == 'S' echo " LOCKSIZE TABLESPACE ";
   else
    if ($row[LOCKRULE] == 'T' echo " LOCKSIZE TABLE ";
    else
     if ($row[LOCKRULE] == 'L' echo " LOCKSIZE LOB ";


if ($row[LOCKMAX] < 0 echo " LOCKMAX SYSTEM ";
else
 echo " LOCKMAX $row[LOCKMAX] ";

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

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

if ($row['ENCODING_SCHEME'] == "A") echo " CCSID ASCII; \n" ;
else
    if ($row['ENCODING_SCHEME'] == "E") echo " CCSID EBCDIC; \n" ;
    else
     if ($row['ENCODING_SCHEME'] == "U") echo " CCSID UNICODE; \n" ;



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

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