The following is a sample of the JSON Output that you could expect from the example HDFS Apply Engine script. It represents the CDC record from a single changed row in the DB2 EMP Table:
{“object_name”:DSN81110.EMP,
"stck":"00d16918eb93309dc0",
"timestamp":"2017-05-27-13.18.41.780264",
"change_op":"U",
"after_image":
{
"empno":“000010”,
"firstnme":“SANDRA”,
"midinit":“i”,
"lastname":“HAAS”,
"workdept":“A00”,
"phoneno":"3978",
"hiredate":"1978-09-15",
"job":"PRES",
"edlevel":14,
"sex":"f",
"birthdate":"1954-03-31",
"salary":59250.00,
"bonus":6600.00,
"comm":2340.00
},
"before_image":
{
"empno":“000010”,
"firstnme":“CHRISTINE”,
"midinit":“I”,
"lastname”:“HAAS”,
"workdept”:“A00”,
"phoneno":"3978",
"hiredate":"1978-09-15",
"job":"PRES",
"edlevel":14,
"sex":"f",
"birthdate":"1954-03-31",
"salary":59250.00,
"bonus":6600.00,
"comm":2340.00
},
}