topic Re: Syntax for Load all columns in data editor in App Development

Syntax for Load all columns in data editor

jananireddy — Wed, 25 May 2016 11:43:47 GMT

I am currently using this script in my data load editor:

[portfolio]:

LIB CONNECT TO [portfolio(e45_lenovo)];

LOAD

[category] as CATEGORY,

[module] as MODULE,

[customeraccountid] as CUSTOMERACCOUNTID,

[customername] as CUSTOMERNAME;

SQL SELECT * FROM portfolio;

Since now my tables will have increasing number of columns/ renamed columns, can i have a way to avoid mentioning the column names in my script? May be something like this:

[portfolio]:

LIB CONNECT TO [portfolio(e45_lenovo)];

LOAD ALL

SQL SELECT * FROM portfolio;

Thanks,

Janani

Re: Syntax for Load all columns in data editor

Anonymous — Wed, 25 May 2016 16:37:41 GMT

Hi Janani,

I believe you can, I've successfully loaded all columns using the following;

LOAD *
;
SQL SELECT *
FROM db.view;

Hope this helps.

Re: Syntax for Load all columns in data editor

sunny_talwar — Wed, 25 May 2016 23:02:57 GMT

I think all you need is to replace ALL with a *

LIB CONNECT TO [portfolio(e45_lenovo)];

[portfolio]:

LOAD *;

SQL SELECT * FROM portfolio;