Re: dataformatting in nodeJS SQL interface with IBM db2a

[Nathan Andelin <nandelin@xxxxxxxxx>]

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.