I would like to generate a json file from oracle table,
the first step i did a job to generate a sequential file from oc
the second one, i tryed to compose a json file from sequetial file using Hiearchical Data stage, i prepared a shema json, the problem that my output(json file) still empty
based on ibm example i understood that schema json it could be the first record:
Code: Select all
{
"product": [
{ "NO_PROD": "10000",
"NO_VERS_PROD": "32",
"CD_FAML_PROD": "voy",
"IND_TAXB": "1",
"IND_PLAN_OBLG": "0",
"IND_PREN_DIFF_ASSR_PRIN": "0" ,
"DT_DEBT_DISP": "2007-12-01",
"MTN_PRIM_MIN": "25,00" ,
"DT_CREA": "07-SEP-07 10.08.28.875 AM+0100",
"CD_UTIL_CREA": "superadmin",
"NOM_PROD_FR": "Assurance Voyage À la Carte",
"NOM_PROD_EN": "Individual Travel Insurance",
"NOM_PROD_ABRG_FR": "Assurance Voyage À la Carte",
"NOM_PROD_ABRG_EN": "Individual Travel Insurance",
"DT_FIN_DISP": "2007-12-01",
"DT_ENTR_VIGR": "2007-12-01",
"DT_FIN_DISP_RENV": "2007-12-01",
"CLAS": "",
"SOUS_CLAS": "",
"CD_MOD_RENV": "",
"DT_RENV": "",
}
]
}
Thank you