Sometimes we can store data as a JSON format in our DB2 database and we need to create a new table according to this JSON.
You can see an example for JSON to TABLE conversion DB2 below.
First of all we need to keep our data in BSON (Binary JSON)…
Here you can find an example of Java to DB2 On Cloud Connection.
First you need to add db2jcc4.jar like below.
After that you can execute the code below
While we are dealing with business objects in BAW javascript, we may need to do some comparation between values.
If we are dealing with complex business object and try to compare it in deeper levels it may get a Nullpointer exeption.
Lets say that we have a business object like below.
And we would like to check if address.number is X or not.
You can find the example of how to download content in IBM BPM coach view.
First we need to create a db2 connection like below
Then we need to add SSL setting under“Driver properties” tab.
Properties KeyValue Pair:
sslTrustStorePassword => Password of your trust store
sslTrustStoreLocation => Location of your trust store in your local harddrive
sslConnection => true
