load fieldnames from ODBC

[#1]

Hi,

i have to add this statement load *;  before  sql select * from ODBC

but i wanna  see as

load  A, B, C, ...all field names sql select * from ODBC

and select field names automtically (not to be have to write by hand)

thanks

[#2 · Accepted solution]

If you use the wizard and check the box for preceding load it should do this automatically.

[Gabriel]

Hi merakist,

I think what you have to do is select each fieldname one at a time (i.e. select A, B, C separately by clicking each field ) and it will appear in the selection box below.

Let me know if thisis not clear enough.

Regards,

Gab

[hallquist_nate]

I think all you really need to do is check the box "Preceeding Load" in the Create Select Statement Dialog box.  That allows you to then select only the fields you need and lists each one in the load script.  Be sure to click Add, before OK.

[#5]

@marcsliving and  @gabsus04

thanks a lot.