## macros

#macro( notnull $nullString $col)
#if( $col.isNotNull() )
#set( $nullString = $props.getProperty("NOTNULL") )
#else
#set( $nullString = '')
#end
#end

#macro( printcols $res $columns )
#set($res = '')
#foreach($col in $columns)
#set($res = "$res $col.name,")
#end
#set($res = "$strings.chop($res,1)" )
#end

#macro( printcols_db2 $res $columns )
#set($res = '')
#foreach($col in $columns)
#if($col.name == "NAME" )
#set($colname = '"NAME"')
#else
#set($colname = "$col.name")
#end
#set($res = "$res $colname,")
#end
#set($res = "$strings.chop($res,1)" )
#end