show generate statement