Re: Elevator speech on DB2 development and web enablement?

Hi kelly

I'm guessing that it is very much the same. CLOB and BLOB fields in DB2
are just storage addresses that points to allocated row storage outside the
actual table - without knowing it I think that XML and JSON is stored in the
same manner.

RLA is not the way to process such field types but sql or nosql are but for
your
cobol shop that may be a problem.

On Thu, Oct 1, 2015 at 5:36 PM, Kelly Cookson <KCookson@xxxxxxxxxxxx> wrote:

Hi Henrik,

I was referring to the technology preview regarding JSON:

https://www.ibm.com/developerworks/ibmi/library/i-json-store-technology/

I'm not sure if this is the same thing as storing JSON documents in
BLOB\CLOB fields. I suspect it isn't the same.

Thanks,

Kelly Cookson
IT Project Leader
Dot Foods, Inc.
1.217.773.4486 ext. 12676
kcookson@xxxxxxxxxxxx

-----Original Message-----
From: WEB400 [mailto:web400-bounces@xxxxxxxxxxxx] On Behalf Of Henrik
Rützou
Sent: Thursday, October 01, 2015 10:27 AM
To: Web Enabling the IBM i (AS/400 and iSeries)
Subject: Re: [WEB400] Elevator speech on DB2 development and web
enablement?

Kelly

JSON as weel as XML can be stored in a BLOB/CLOB fields i DB2.

This is however not the problem, but COBOL/RPG are since they are SBCS
languages and JSON is UTF-8 (Unicode) datastreams so any characters in the
store JSON must be within the range of the SBCS EBCDIC codepage the program
is running under.



On Thu, Oct 1, 2015 at 5:07 PM, Kelly Cookson <KCookson@xxxxxxxxxxxx>
wrote:

My apologies for such an open-ended question.

We're a COBOL shop (split between ILE and OPM). From what I can tell,
our COBOL developers don't do much more with DB2 than create physical
files and logical files using DDS. We have several SQL queries. We
also have several stored procedures. But mostly our developers write
COBOL programs that use record level access.

I have the IBM Redbook on modernization, and I'm starting to read the
chapter on data-centric development.

I'd appreciate any thoughts or info on the following:


1. I know DB2 for i has some new capabilities around storing JSON.

What

other capabilities does DB2 have that would be useful for web and
mobile development? What should we be taking advantage of in DB2 for
web and mobile enablement?



2. I have a very vague idea that moving business logic and development
from COBOL into DB2 as much as possible is a good thing. But I don't
really understand. I can't explain what this means, why we should do
it, or offer a few good examples. Would someone mind briefly sharing
some ideas or talking points for a good elevator speech?

Thanks in advance for any insights and info.

Thanks,

Kelly Cookson
IT Project Leader
Dot Foods, Inc.
1.217.773.4486 ext. 12676
kcookson@xxxxxxxxxxxx<mailto:kcookson@xxxxxxxxxxxx>

--
This is the Web Enabling the IBM i (AS/400 and iSeries) (WEB400)
mailing list To post a message email: WEB400@xxxxxxxxxxxx To
subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/web400
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/web400.

--
Regards,
Henrik Rützou

http://powerEXT.com <http://powerext.com/>
--
This is the Web Enabling the IBM i (AS/400 and iSeries) (WEB400) mailing
list To post a message email: WEB400@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/web400
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/web400.

--
This is the Web Enabling the IBM i (AS/400 and iSeries) (WEB400) mailing
list
To post a message email: WEB400@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/web400
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/web400.