The Netezza Community: Header in create external table? ...

1 "correct" answer available (4 pts) 2 "helpful" answers available (2 pts)

1 Replies Last post: Nov 12, 2009 6:05 PM by David Birmingham

chrishane

1 posts since
Nov 12, 2009

Currently Being Moderated

Header in create external table?

Is there a way to create a first row of column names in a remote odbc text table export ?

Thanks

Tags: odbc, netezza

David Birmingham

161 posts since
Sep 24, 2007

Currently Being Moderated

1. Nov 12, 2009 6:05 PM

in response to: chrishane

Re: Header in create external table?

you would just union your output with an additional query to the netezza catalog - the catalog's output would be the first line

Report Abuse