Swagger doesn't support decimal

As of version 7.10.0 using node.js the swagger doesn't support the decimal however it supports the number of type float of 32 bit, double of 64 bit but not decimal of 128 bit.

So you can declare as a field of type decimal as below..

  "amount" : {

          "type" : "number"

Then cast it to decimal like CAST(amount AS DECIMAL);

Create, Call procedures Websphere IBM IIB ESQL

1) CALL Schema.StatusOut (Inputroot.xmlnsc.status);

 -- Translate Status For SOAP Response
CREATE PROCEDURE StatusOut (IN ParmIn CHARACTER)
    RETURNS CHARACTER
BEGIN
        CASE ParmIn
        WHEN 'S' THEN
        RETURN 'SUCCESS';
        WHEN 'F' THEN
        RETURN 'FAILURE';
        WHEN 'P' THEN
        RETURN 'PARTIAL';
        END CASE;
END;

-- Translate SeverityLevel For SOAP Response
CREATE PROCEDURE SeverityLevelOut (IN ParmIn CHARACTER)
    RETURNS CHARACTER
BEGIN
        CASE ParmIn
        WHEN 'S' THEN
        RETURN 'CRITICAL';
        WHEN 'E' THEN
        RETURN 'ERROR';
        WHEN 'W' THEN
        RETURN 'WARNING';
        WHEN 'I' THEN
        RETURN 'INFORMATIONAL';
        END CASE;
END;

-- Translate SeverityLevel To Status For SOAP Response
CREATE PROCEDURE SeverityLevelToStatusOut (IN ParmIn CHARACTER)
    RETURNS CHARACTER
BEGIN
        CASE ParmIn
        WHEN 'S' THEN
        RETURN 'FAILURE';
        WHEN 'E' THEN
        RETURN 'FAILURE';
        WHEN 'W' THEN
        RETURN 'SUCCESS';
        WHEN 'I' THEN
        RETURN 'SUCCESS';
            ELSE
        RETURN 'SUCCESS';
        END CASE;
END;


2)
DECLARE inputref REFERENCE TO InputRoot.JSON.Hdr;
DECLARE outputref REFERENCE TO OutputRoot.SOAP.Hdr;

CALL TRReqHdr_JSONtoSOAP(inputref, outputref );

CREATE PROCEDURE TRReqHdr_JSONtoSOAP(IN InRef_trReqHdr REFERENCE, INOUT OutRef_TRReqHdr REFERENCE) BEGIN

------------
field level mapping
------------

END;

3) calling db/java procedures..
step1) create procedure in the esql module,

CREATE PROCEDURE DoSomething (IN in1 CHARACTER, OUT out1 CHARACTER, OUT out2 CHARACTER)
    LANGUAGE DATABASE
    EXTERNAL NAME "DoSomething";

step2) Now you can call this function from your ESQL main function as below:

CALL DoSomething(in,out1,out2) IN Database.yourschema.yourDB;

Windows PID kill

taskkill /PID 5708

to kill it with force

taskkill /f  /pid 5708