Re: dataformatting in nodeJS SQL interface with IBM db2a

Henrik,

The term "lazy programmer" is sometimes used with negative connotation, and
other times used with positive connotation. In this case, I don't fault
programmers who would rather not code the full SQL statement, including
rtrim() function calls required to trim fields.

I was just trying to say that this is a case where invoking a REST web
service API would provide a simpler interface for programmers. A
web-service API would relieve programmers of the verbosity and ofttimes
complexity of coding their own SQL statements.

I'm just suggesting that this is a case where a REST web service API would
have advantages over Node's db2a interface.



On Sat, Mar 24, 2018 at 7:41 AM, Henrik Rützou <hr@xxxxxxxxxxxx> wrote:

Nathan

you may call it lazy to want to have a transparent interface that hasn't to
be
touched every time you add a new or remove a column to a table.

Especially removing a column will cause errors if you specify resultsets
by specific field names, imho they sould automatically be removed from
the rest service and that should automatically result in the field are
removed
in the UI regardless of code defining the field may exsist.

We are back to constructing an UI where if you filter the SSN from UserA
it dosn't appear in his UI but dons't filter it from UserB it appears -
both running
on the same code.