CLOB: truncation of the last char ! #173
Comments
|
Hello @Didier68 I think the next step is to create a script that reproduces the bug. The recreate script should:
Having the script that reproduces the error will make it easier spotting the source of the bug. Can you report back the info for all the columns in the table? Calling SYSCOLUMNS2 should get you that info. SELECT * FROM QSYS2.SYSCOLUMNS2 WHERE TABLE_NAME = 'TABLE' AND TABLE_OWNER = 'OWNER' |
|
Hello @abmusse , The result of the query on SYSCOLUMNS2: {"COLUMN_NAME":"PARCOURS","TABLE_NAME":"BTRLIG","TABLE_OWNER":"EUREKA","ORDINAL_POSITION":"46" |
|
For all the table: {"criteres":{"table":"BTRLIG","schema":"EURO4","config":"config_DEMO"},"table":{"TNAME":"BTRLIG","TSCHEMA":"EURO4","LAST_ALTERED_TIMESTAMP":"2023-06-04-11.54.24.830000","TITLE":"003 "Lignes" du BT N","TABLE_TYPE":"T","jsTIMESTAMP":1685872464830},"columns":[{"FIELD":"NBTR","DDS":"A","ALIAS":"NBTR","DATA_TYPE":"CHAR","DFT_VALUE":"' '","TITLE":"N° Bordereau transporteur","POS":1,"LEN":8,"DEC":0,"DSTYPE":"A","NULLABLE":"","READONLY":"","KEYN":1},{"FIELD":"NLBT","DDS":"S","ALIAS":"NLBT","DATA_TYPE":"NUMERIC","DFT_VALUE":"0","TITLE":"N° ligne du B.T.","POS":2,"LEN":5,"DEC":2,"DSTYPE":"N","NULLABLE":"","READONLY":"","KEYN":2},{"FIELD":"TRFD","DDS":"A","ALIAS":"TRFD","DATA_TYPE":"CHAR","DFT_VALUE":"' '","TITLE":"Type de référence document","POS":3,"LEN":3,"DEC":0,"DSTYPE":"A","NULLABLE":"","READONLY":""},{"FIELD":"REFD","DDS":"A","ALIAS":"REFD","DATA_TYPE":"CHAR","DFT_VALUE":"' '","TITLE":"Référence document","POS":4,"LEN":13,"DEC":0,"DSTYPE":"A","NULLABLE":"","READONLY":""},{"FIELD":"LIGN","DDS":"S","ALIAS":"LIGN","DATA_TYPE":"NUMERIC","DFT_VALUE":"0","TITLE":"N° ligne","POS":5,"LEN":7,"DEC":0,"DSTYPE":"I","NULLABLE":"","READONLY":""},{"FIELD":"NDOC","DDS":"A","ALIAS":"NDOC","DATA_TYPE":"CHAR","DFT_VALUE":"' '","TITLE":"N° Document","POS":6,"LEN":8,"DEC":0,"DSTYPE":"A","NULLABLE":"","READONLY":""},{"FIELD":"NLIC","DDS":"S","ALIAS":"NLIC","DATA_TYPE":"NUMERIC","DFT_VALUE":"0","TITLE":"N° ligne","POS":7,"LEN":7,"DEC":3,"DSTYPE":"N","NULLABLE":"","READONLY":""},{"FIELD":"LILT","DDS":"A","ALIAS":"LILT","DATA_TYPE":"CHAR","DFT_VALUE":"' '","TITLE":"Libellé de livraison Tournée","POS":8,"LEN":200,"DEC":0,"DSTYPE":"A","NULLABLE":"","READONLY":""},{"FIELD":"HHAC","DDS":"S","ALIAS":"HHAC","DATA_TYPE":"NUMERIC","DFT_VALUE":"0","TITLE":"Heure d'arrivée chez le client","POS":9,"LEN":4,"DEC":0,"DSTYPE":"I","NULLABLE":"","READONLY":""},{"FIELD":"HACD","DDS":"S","ALIAS":"HACD","DATA_TYPE":"NUMERIC","DFT_VALUE":"0","TITLE":"Heure d'arrivée chez le client De","POS":10,"LEN":4,"DEC":0,"DSTYPE":"I","NULLABLE":"","READONLY":""},{"FIELD":"HACF","DDS":"S","ALIAS":"HACF","DATA_TYPE":"NUMERIC","DFT_VALUE":"0","TITLE":"Heure d'arrivée chez le client A","POS":11,"LEN":4,"DEC":0,"DSTYPE":"I","NULLABLE":"","READONLY":""},{"FIELD":"GPSX","DDS":"S","ALIAS":"GPSX","DATA_TYPE":"NUMERIC","DFT_VALUE":"0","TITLE":"Longitude (GPS)","POS":12,"LEN":10,"DEC":6,"DSTYPE":"N","NULLABLE":"","READONLY":""},{"FIELD":"GPSY","DDS":"S","ALIAS":"GPSY","DATA_TYPE":"NUMERIC","DFT_VALUE":"0","TITLE":"Latitude (GPS)","POS":13,"LEN":10,"DEC":6,"DSTYPE":"N","NULLABLE":"","READONLY":""},{"FIELD":"GEOK","DDS":"A","ALIAS":"GEOK","DATA_TYPE":"CHAR","DFT_VALUE":"' '","TITLE":"Flag Geolocalisation OK","POS":14,"LEN":1,"DEC":0,"DSTYPE":"A","NULLABLE":"","READONLY":""},{"FIELD":"NSEQ","DDS":"S","ALIAS":"NSEQ","DATA_TYPE":"NUMERIC","DFT_VALUE":"0","TITLE":"N° séquence","POS":15,"LEN":5,"DEC":2,"DSTYPE":"N","NULLABLE":"","READONLY":""},{"FIELD":"FARS","DDS":"A","ALIAS":"FARS","DATA_TYPE":"CHAR","DFT_VALUE":"' '","TITLE":"Flag Avec Réserve","POS":16,"LEN":1,"DEC":0,"DSTYPE":"A","NULLABLE":"","READONLY":""},{"FIELD":"RMRQ","DDS":"A","ALIAS":"RMRQ","DATA_TYPE":"CHAR","DFT_VALUE":"' '","TITLE":"Remarque","POS":17,"LEN":250,"DEC":0,"DSTYPE":"A","NULLABLE":"","READONLY":""},{"FIELD":"HARC","DDS":"S","ALIAS":"HARC","DATA_TYPE":"NUMERIC","DFT_VALUE":"0","TITLE":"Heure Arrivée Réelle","POS":18,"LEN":4,"DEC":0,"DSTYPE":"I","NULLABLE":"","READONLY":""},{"FIELD":"HDRC","DDS":"S","ALIAS":"HDRC","DATA_TYPE":"NUMERIC","DFT_VALUE":"0","TITLE":"Heure Départ Réelle","POS":19,"LEN":4,"DEC":0,"DSTYPE":"I","NULLABLE":"","READONLY":""},{"FIELD":"HACC","DDS":"S","ALIAS":"HACC","DATA_TYPE":"NUMERIC","DFT_VALUE":"0","TITLE":"Heure Arrivée Calculée","POS":20,"LEN":4,"DEC":0,"DSTYPE":"I","NULLABLE":"","READONLY":""},{"FIELD":"HDCC","DDS":"S","ALIAS":"HDCC","DATA_TYPE":"NUMERIC","DFT_VALUE":"0","TITLE":"Heure Départ Calculée","POS":21,"LEN":4,"DEC":0,"DSTYPE":"I","NULLABLE":"","READONLY":""},{"FIELD":"HHDT","DDS":"S","ALIAS":"HHDT","DATA_TYPE":"NUMERIC","DFT_VALUE":"0","TITLE":"Durée (h) du transit","POS":22,"LEN":4,"DEC":0,"DSTYPE":"I","NULLABLE":"","READONLY":""},{"FIELD":"HHDD","DDS":"S","ALIAS":"HHDD","DATA_TYPE":"NUMERIC","DFT_VALUE":"0","TITLE":"Durée (h) du déchargement","POS":23,"LEN":4,"DEC":0,"DSTYPE":"I","NULLABLE":"","READONLY":""},{"FIELD":"IFOB","DDS":"A","ALIAS":"IFOB","DATA_TYPE":"CHAR","DFT_VALUE":"' '","TITLE":"Mode Info BL","POS":24,"LEN":3,"DEC":0,"DSTYPE":"A","NULLABLE":"","READONLY":""},{"FIELD":"NILI","DDS":"A","ALIAS":"NILI","DATA_TYPE":"CHAR","DFT_VALUE":"' '","TITLE":"N° Interlocuteur Livraison","POS":25,"LEN":8,"DEC":0,"DSTYPE":"A","NULLABLE":"","READONLY":""},{"FIELD":"ELIV","DDS":"A","ALIAS":"ELIV","DATA_TYPE":"CHAR","DFT_VALUE":"' '","TITLE":"Code état livraison","POS":26,"LEN":10,"DEC":0,"DSTYPE":"A","NULLABLE":"","READONLY":""},{"FIELD":"FLIF","DDS":"A","ALIAS":"FLIF","DATA_TYPE":"CHAR","DFT_VALUE":"' '","TITLE":"Flag Livraison Faite","POS":27,"LEN":1,"DEC":0,"DSTYPE":"A","NULLABLE":"","READONLY":""},{"FIELD":"HMIN","DDS":"S","ALIAS":"HMIN","DATA_TYPE":"NUMERIC","DFT_VALUE":"0","TITLE":"Heure Mini","POS":28,"LEN":4,"DEC":0,"DSTYPE":"I","NULLABLE":"","READONLY":""},{"FIELD":"HMAX","DDS":"S","ALIAS":"HMAX","DATA_TYPE":"NUMERIC","DFT_VALUE":"0","TITLE":"Heure Maxi","POS":29,"LEN":4,"DEC":0,"DSTYPE":"I","NULLABLE":"","READONLY":""},{"FIELD":"TCTR","DDS":"A","ALIAS":"TCTR","DATA_TYPE":"CHAR","DFT_VALUE":"' '","TITLE":"Texte Contrainte","POS":30,"LEN":200,"DEC":0,"DSTYPE":"A","NULLABLE":"","READONLY":""},{"FIELD":"STRN","DDS":"S","ALIAS":"STRN","DATA_TYPE":"NUMERIC","DFT_VALUE":"0","TITLE":"Séquence tournée","POS":31,"LEN":5,"DEC":2,"DSTYPE":"N","NULLABLE":"","READONLY":""},{"FIELD":"FVDF","DDS":"A","ALIAS":"FVDF","DATA_TYPE":"CHAR","DFT_VALUE":"' '","TITLE":"Flag Signature","POS":32,"LEN":1,"DEC":0,"DSTYPE":"A","NULLABLE":"","READONLY":""},{"FIELD":"NLBC","DDS":"S","ALIAS":"NLBC","DATA_TYPE":"NUMERIC","DFT_VALUE":"0","TITLE":"N° de container du B.T.","POS":33,"LEN":3,"DEC":0,"DSTYPE":"I","NULLABLE":"","READONLY":""},{"FIELD":"UTIC","DDS":"A","ALIAS":"UTIC","DATA_TYPE":"CHAR","DFT_VALUE":"' '","TITLE":"Utilisateur création","POS":34,"LEN":10,"DEC":0,"DSTYPE":"A","NULLABLE":"","READONLY":""},{"FIELD":"DTC8","DDS":"S","ALIAS":"DTC8","DATA_TYPE":"NUMERIC","DFT_VALUE":"0","TITLE":"Date création","POS":35,"LEN":8,"DEC":0,"DSTYPE":"I","NULLABLE":"","READONLY":""},{"FIELD":"HHC6","DDS":"S","ALIAS":"HHC6","DATA_TYPE":"NUMERIC","DFT_VALUE":"0","TITLE":"Heure création","POS":36,"LEN":6,"DEC":0,"DSTYPE":"I","NULLABLE":"","READONLY":""},{"FIELD":"UTIM","DDS":"A","ALIAS":"UTIM","DATA_TYPE":"CHAR","DFT_VALUE":"' '","TITLE":"Utilisateur ayant fait la dernière màj","POS":37,"LEN":10,"DEC":0,"DSTYPE":"A","NULLABLE":"","READONLY":""},{"FIELD":"DMA8","DDS":"S","ALIAS":"DMA8","DATA_TYPE":"NUMERIC","DFT_VALUE":"0","TITLE":"Date de dernière mise à jour","POS":38,"LEN":8,"DEC":0,"DSTYPE":"I","NULLABLE":"","READONLY":""},{"FIELD":"HHM6","DDS":"S","ALIAS":"HHM6","DATA_TYPE":"NUMERIC","DFT_VALUE":"0","TITLE":"Heure de modification","POS":39,"LEN":6,"DEC":0,"DSTYPE":"I","NULLABLE":"","READONLY":""},{"FIELD":"IDUNIQ","DDS":"A","ALIAS":"IDUNIQ","DATA_TYPE":"CHAR","DFT_VALUE":"' '","TITLE":"Identifiant unique fichier/enregistrement","POS":40,"LEN":32,"DEC":0,"DSTYPE":"A","NULLABLE":"","READONLY":""},{"FIELD":"ENRV","DDS":"A","ALIAS":"ENRV","DATA_TYPE":"CHAR","DFT_VALUE":"' '","TITLE":"Enregistrement valide","POS":41,"LEN":1,"DEC":0,"DSTYPE":"A","NULLABLE":"","READONLY":""},{"FIELD":"DISM","DDS":"S","ALIAS":"DISM","DATA_TYPE":"NUMERIC","DFT_VALUE":"0","TITLE":"Distance en mètre","POS":42,"LEN":10,"DEC":0,"DSTYPE":"I","NULLABLE":"","READONLY":""},{"FIELD":"DRTS","DDS":"S","ALIAS":"DRTS","DATA_TYPE":"NUMERIC","DFT_VALUE":"0","TITLE":"Durée en seconde","POS":43,"LEN":10,"DEC":0,"DSTYPE":"I","NULLABLE":"","READONLY":""},{"FIELD":"GPSX2","DDS":"S","ALIAS":"GPSX2","DATA_TYPE":"NUMERIC","DFT_VALUE":"0","TITLE":"Longitude (GPS)","POS":44,"LEN":10,"DEC":6,"DSTYPE":"N","NULLABLE":"","READONLY":""},{"FIELD":"GPSY2","DDS":"S","ALIAS":"GPSY2","DATA_TYPE":"NUMERIC","DFT_VALUE":"0","TITLE":"Latitude (GPS)","POS":45,"LEN":10,"DEC":6,"DSTYPE":"N","NULLABLE":"","READONLY":""},{"FIELD":"PARCOURS","DDS":"1","ALIAS":"PARCOURS","DATA_TYPE":"CLOB","DFT_VALUE":null,"TITLE":"Parcours","POS":46,"LEN":99999,"DEC":0,"DSTYPE":"A","NULLABLE":"1","READONLY":""}],"iColumns":{"NBTR":{"FIELD":"NBTR","DDS":"A","ALIAS":"NBTR","DATA_TYPE":"CHAR","DFT_VALUE":"' '","TITLE":"N° Bordereau transporteur","POS":1,"LEN":8,"DEC":0,"DSTYPE":"A","NULLABLE":"","READONLY":"","KEYN":1},"NLBT":{"FIELD":"NLBT","DDS":"S","ALIAS":"NLBT","DATA_TYPE":"NUMERIC","DFT_VALUE":"0","TITLE":"N° ligne du B.T.","POS":2,"LEN":5,"DEC":2,"DSTYPE":"N","NULLABLE":"","READONLY":"","KEYN":2},"TRFD":{"FIELD":"TRFD","DDS":"A","ALIAS":"TRFD","DATA_TYPE":"CHAR","DFT_VALUE":"' '","TITLE":"Type de référence document","POS":3,"LEN":3,"DEC":0,"DSTYPE":"A","NULLABLE":"","READONLY":""},"REFD":{"FIELD":"REFD","DDS":"A","ALIAS":"REFD","DATA_TYPE":"CHAR","DFT_VALUE":"' '","TITLE":"Référence document","POS":4,"LEN":13,"DEC":0,"DSTYPE":"A","NULLABLE":"","READONLY":""},"LIGN":{"FIELD":"LIGN","DDS":"S","ALIAS":"LIGN","DATA_TYPE":"NUMERIC","DFT_VALUE":"0","TITLE":"N° ligne","POS":5,"LEN":7,"DEC":0,"DSTYPE":"I","NULLABLE":"","READONLY":""},"NDOC":{"FIELD":"NDOC","DDS":"A","ALIAS":"NDOC","DATA_TYPE":"CHAR","DFT_VALUE":"' '","TITLE":"N° Document","POS":6,"LEN":8,"DEC":0,"DSTYPE":"A","NULLABLE":"","READONLY":""},"NLIC":{"FIELD":"NLIC","DDS":"S","ALIAS":"NLIC","DATA_TYPE":"NUMERIC","DFT_VALUE":"0","TITLE":"N° ligne","POS":7,"LEN":7,"DEC":3,"DSTYPE":"N","NULLABLE":"","READONLY":""},"LILT":{"FIELD":"LILT","DDS":"A","ALIAS":"LILT","DATA_TYPE":"CHAR","DFT_VALUE":"' '","TITLE":"Libellé de livraison Tournée","POS":8,"LEN":200,"DEC":0,"DSTYPE":"A","NULLABLE":"","READONLY":""},"HHAC":{"FIELD":"HHAC","DDS":"S","ALIAS":"HHAC","DATA_TYPE":"NUMERIC","DFT_VALUE":"0","TITLE":"Heure d'arrivée chez le client","POS":9,"LEN":4,"DEC":0,"DSTYPE":"I","NULLABLE":"","READONLY":""},"HACD":{"FIELD":"HACD","DDS":"S","ALIAS":"HACD","DATA_TYPE":"NUMERIC","DFT_VALUE":"0","TITLE":"Heure d'arrivée chez le client De","POS":10,"LEN":4,"DEC":0,"DSTYPE":"I","NULLABLE":"","READONLY":""},"HACF":{"FIELD":"HACF","DDS":"S","ALIAS":"HACF","DATA_TYPE":"NUMERIC","DFT_VALUE":"0","TITLE":"Heure d'arrivée chez le client A","POS":11,"LEN":4,"DEC":0,"DSTYPE":"I","NULLABLE":"","READONLY":""},"GPSX":{"FIELD":"GPSX","DDS":"S","ALIAS":"GPSX","DATA_TYPE":"NUMERIC","DFT_VALUE":"0","TITLE":"Longitude (GPS)","POS":12,"LEN":10,"DEC":6,"DSTYPE":"N","NULLABLE":"","READONLY":""},"GPSY":{"FIELD":"GPSY","DDS":"S","ALIAS":"GPSY","DATA_TYPE":"NUMERIC","DFT_VALUE":"0","TITLE":"Latitude (GPS)","POS":13,"LEN":10,"DEC":6,"DSTYPE":"N","NULLABLE":"","READONLY":""},"GEOK":{"FIELD":"GEOK","DDS":"A","ALIAS":"GEOK","DATA_TYPE":"CHAR","DFT_VALUE":"' '","TITLE":"Flag Geolocalisation OK","POS":14,"LEN":1,"DEC":0,"DSTYPE":"A","NULLABLE":"","READONLY":""},"NSEQ":{"FIELD":"NSEQ","DDS":"S","ALIAS":"NSEQ","DATA_TYPE":"NUMERIC","DFT_VALUE":"0","TITLE":"N° séquence","POS":15,"LEN":5,"DEC":2,"DSTYPE":"N","NULLABLE":"","READONLY":""},"FARS":{"FIELD":"FARS","DDS":"A","ALIAS":"FARS","DATA_TYPE":"CHAR","DFT_VALUE":"' '","TITLE":"Flag Avec Réserve","POS":16,"LEN":1,"DEC":0,"DSTYPE":"A","NULLABLE":"","READONLY":""},"RMRQ":{"FIELD":"RMRQ","DDS":"A","ALIAS":"RMRQ","DATA_TYPE":"CHAR","DFT_VALUE":"' '","TITLE":"Remarque","POS":17,"LEN":250,"DEC":0,"DSTYPE":"A","NULLABLE":"","READONLY":""},"HARC":{"FIELD":"HARC","DDS":"S","ALIAS":"HARC","DATA_TYPE":"NUMERIC","DFT_VALUE":"0","TITLE":"Heure Arrivée Réelle","POS":18,"LEN":4,"DEC":0,"DSTYPE":"I","NULLABLE":"","READONLY":""},"HDRC":{"FIELD":"HDRC","DDS":"S","ALIAS":"HDRC","DATA_TYPE":"NUMERIC","DFT_VALUE":"0","TITLE":"Heure Départ Réelle","POS":19,"LEN":4,"DEC":0,"DSTYPE":"I","NULLABLE":"","READONLY":""},"HACC":{"FIELD":"HACC","DDS":"S","ALIAS":"HACC","DATA_TYPE":"NUMERIC","DFT_VALUE":"0","TITLE":"Heure Arrivée Calculée","POS":20,"LEN":4,"DEC":0,"DSTYPE":"I","NULLABLE":"","READONLY":""},"HDCC":{"FIELD":"HDCC","DDS":"S","ALIAS":"HDCC","DATA_TYPE":"NUMERIC","DFT_VALUE":"0","TITLE":"Heure Départ Calculée","POS":21,"LEN":4,"DEC":0,"DSTYPE":"I","NULLABLE":"","READONLY":""},"HHDT":{"FIELD":"HHDT","DDS":"S","ALIAS":"HHDT","DATA_TYPE":"NUMERIC","DFT_VALUE":"0","TITLE":"Durée (h) du transit","POS":22,"LEN":4,"DEC":0,"DSTYPE":"I","NULLABLE":"","READONLY":""},"HHDD":{"FIELD":"HHDD","DDS":"S","ALIAS":"HHDD","DATA_TYPE":"NUMERIC","DFT_VALUE":"0","TITLE":"Durée (h) du déchargement","POS":23,"LEN":4,"DEC":0,"DSTYPE":"I","NULLABLE":"","READONLY":""},"IFOB":{"FIELD":"IFOB","DDS":"A","ALIAS":"IFOB","DATA_TYPE":"CHAR","DFT_VALUE":"' '","TITLE":"Mode Info BL","POS":24,"LEN":3,"DEC":0,"DSTYPE":"A","NULLABLE":"","READONLY":""},"NILI":{"FIELD":"NILI","DDS":"A","ALIAS":"NILI","DATA_TYPE":"CHAR","DFT_VALUE":"' '","TITLE":"N° Interlocuteur Livraison","POS":25,"LEN":8,"DEC":0,"DSTYPE":"A","NULLABLE":"","READONLY":""},"ELIV":{"FIELD":"ELIV","DDS":"A","ALIAS":"ELIV","DATA_TYPE":"CHAR","DFT_VALUE":"' '","TITLE":"Code état livraison","POS":26,"LEN":10,"DEC":0,"DSTYPE":"A","NULLABLE":"","READONLY":""},"FLIF":{"FIELD":"FLIF","DDS":"A","ALIAS":"FLIF","DATA_TYPE":"CHAR","DFT_VALUE":"' '","TITLE":"Flag Livraison Faite","POS":27,"LEN":1,"DEC":0,"DSTYPE":"A","NULLABLE":"","READONLY":""},"HMIN":{"FIELD":"HMIN","DDS":"S","ALIAS":"HMIN","DATA_TYPE":"NUMERIC","DFT_VALUE":"0","TITLE":"Heure Mini","POS":28,"LEN":4,"DEC":0,"DSTYPE":"I","NULLABLE":"","READONLY":""},"HMAX":{"FIELD":"HMAX","DDS":"S","ALIAS":"HMAX","DATA_TYPE":"NUMERIC","DFT_VALUE":"0","TITLE":"Heure Maxi","POS":29,"LEN":4,"DEC":0,"DSTYPE":"I","NULLABLE":"","READONLY":""},"TCTR":{"FIELD":"TCTR","DDS":"A","ALIAS":"TCTR","DATA_TYPE":"CHAR","DFT_VALUE":"' '","TITLE":"Texte Contrainte","POS":30,"LEN":200,"DEC":0,"DSTYPE":"A","NULLABLE":"","READONLY":""},"STRN":{"FIELD":"STRN","DDS":"S","ALIAS":"STRN","DATA_TYPE":"NUMERIC","DFT_VALUE":"0","TITLE":"Séquence tournée","POS":31,"LEN":5,"DEC":2,"DSTYPE":"N","NULLABLE":"","READONLY":""},"FVDF":{"FIELD":"FVDF","DDS":"A","ALIAS":"FVDF","DATA_TYPE":"CHAR","DFT_VALUE":"' '","TITLE":"Flag Signature","POS":32,"LEN":1,"DEC":0,"DSTYPE":"A","NULLABLE":"","READONLY":""},"NLBC":{"FIELD":"NLBC","DDS":"S","ALIAS":"NLBC","DATA_TYPE":"NUMERIC","DFT_VALUE":"0","TITLE":"N° de container du B.T.","POS":33,"LEN":3,"DEC":0,"DSTYPE":"I","NULLABLE":"","READONLY":""},"UTIC":{"FIELD":"UTIC","DDS":"A","ALIAS":"UTIC","DATA_TYPE":"CHAR","DFT_VALUE":"' '","TITLE":"Utilisateur création","POS":34,"LEN":10,"DEC":0,"DSTYPE":"A","NULLABLE":"","READONLY":""},"DTC8":{"FIELD":"DTC8","DDS":"S","ALIAS":"DTC8","DATA_TYPE":"NUMERIC","DFT_VALUE":"0","TITLE":"Date création","POS":35,"LEN":8,"DEC":0,"DSTYPE":"I","NULLABLE":"","READONLY":""},"HHC6":{"FIELD":"HHC6","DDS":"S","ALIAS":"HHC6","DATA_TYPE":"NUMERIC","DFT_VALUE":"0","TITLE":"Heure création","POS":36,"LEN":6,"DEC":0,"DSTYPE":"I","NULLABLE":"","READONLY":""},"UTIM":{"FIELD":"UTIM","DDS":"A","ALIAS":"UTIM","DATA_TYPE":"CHAR","DFT_VALUE":"' '","TITLE":"Utilisateur ayant fait la dernière màj","POS":37,"LEN":10,"DEC":0,"DSTYPE":"A","NULLABLE":"","READONLY":""},"DMA8":{"FIELD":"DMA8","DDS":"S","ALIAS":"DMA8","DATA_TYPE":"NUMERIC","DFT_VALUE":"0","TITLE":"Date de dernière mise à jour","POS":38,"LEN":8,"DEC":0,"DSTYPE":"I","NULLABLE":"","READONLY":""},"HHM6":{"FIELD":"HHM6","DDS":"S","ALIAS":"HHM6","DATA_TYPE":"NUMERIC","DFT_VALUE":"0","TITLE":"Heure de modification","POS":39,"LEN":6,"DEC":0,"DSTYPE":"I","NULLABLE":"","READONLY":""},"IDUNIQ":{"FIELD":"IDUNIQ","DDS":"A","ALIAS":"IDUNIQ","DATA_TYPE":"CHAR","DFT_VALUE":"' '","TITLE":"Identifiant unique fichier/enregistrement","POS":40,"LEN":32,"DEC":0,"DSTYPE":"A","NULLABLE":"","READONLY":""},"ENRV":{"FIELD":"ENRV","DDS":"A","ALIAS":"ENRV","DATA_TYPE":"CHAR","DFT_VALUE":"' '","TITLE":"Enregistrement valide","POS":41,"LEN":1,"DEC":0,"DSTYPE":"A","NULLABLE":"","READONLY":""},"DISM":{"FIELD":"DISM","DDS":"S","ALIAS":"DISM","DATA_TYPE":"NUMERIC","DFT_VALUE":"0","TITLE":"Distance en mètre","POS":42,"LEN":10,"DEC":0,"DSTYPE":"I","NULLABLE":"","READONLY":""},"DRTS":{"FIELD":"DRTS","DDS":"S","ALIAS":"DRTS","DATA_TYPE":"NUMERIC","DFT_VALUE":"0","TITLE":"Durée en seconde","POS":43,"LEN":10,"DEC":0,"DSTYPE":"I","NULLABLE":"","READONLY":""},"GPSX2":{"FIELD":"GPSX2","DDS":"S","ALIAS":"GPSX2","DATA_TYPE":"NUMERIC","DFT_VALUE":"0","TITLE":"Longitude (GPS)","POS":44,"LEN":10,"DEC":6,"DSTYPE":"N","NULLABLE":"","READONLY":""},"GPSY2":{"FIELD":"GPSY2","DDS":"S","ALIAS":"GPSY2","DATA_TYPE":"NUMERIC","DFT_VALUE":"0","TITLE":"Latitude (GPS)","POS":45,"LEN":10,"DEC":6,"DSTYPE":"N","NULLABLE":"","READONLY":""},"PARCOURS":{"FIELD":"PARCOURS","DDS":"1","ALIAS":"PARCOURS","DATA_TYPE":"CLOB","DFT_VALUE":null,"TITLE":"Parcours","POS":46,"LEN":99999,"DEC":0,"DSTYPE":"A","NULLABLE":"1","READONLY":""}},"i0":["NBTR","NLBT"]} |
Thank you! |
|
I've formatted JSON from #173 (comment) and #173 (comment) for readability #173 (comment){
"COLUMN_NAME": "PARCOURS",
"TABLE_NAME": "BTRLIG",
"TABLE_OWNER": "EUREKA",
"ORDINAL_POSITION": "46",
"DATA_TYPE": "CLOB ",
"LENGTH": "99999",
"NUMERIC_SCALE": null,
"IS_NULLABLE": "Y",
"IS_UPDATABLE": "Y",
"LONG_COMMENT": null,
"HAS_DEFAULT": "Y",
"COLUMN_HEADING": "Parcours PARCOURS",
"STORAGE": "100028",
"NUMERIC_PRECISION": null,
"CCSID": "1147",
"TABLE_SCHEMA": "ERPZFDMCA",
"COLUMN_DEFAULT": "NULL",
"CHARACTER_MAXIMUM_LENGTH": "99999",
"CHARACTER_OCTET_LENGTH": "99999 ",
"NUMERIC_PRECISION_RADIX": null,
"DATETIME_PRECISION": null,
"COLUMN_TEXT": "Parcours",
"SYSTEM_COLUMN_NAME": "PARCOURS ",
"SYSTEM_TABLE_NAME": "BTRLIG ",
"SYSTEM_TABLE_SCHEMA": "ERPZFDMCA ",
"USER_DEFINED_TYPE_SCHEMA": null,
"USER_DEFINED_TYPE_NAME": null,
"IS_IDENTITY": "NO",
"IDENTITY_GENERATION": null,
"IDENTITY_START": null,
"IDENTITY_INCREMENT": null,
"IDENTITY_MINIMUM": null,
"IDENTITY_MAXIMUM": null,
"IDENTITY_CYCLE": null,
"IDENTITY_CACHE": null,
"IDENTITY_ORDER": null,
"COLUMN_EXPRESSION": null,
"HIDDEN": "N",
"HAS_FLDPROC": "N",
"INLINE_LENGTH": "0",
"NORMALIZE": null,
"DATALINK_LINK_CONTROL": null,
"DATALINK_INTEGRITY": null,
"DATALINK_READ_PERMISSION": null,
"DATALINK_WRITE_PERMISSION": null,
"DATALINK_RECOVERY": null,
"DATALINK_UNLINK_CONTROL": null,
"DDS_TYPE": "1",
"SECURE": "0",
"DATE_FORMAT": null,
"DATE_SEPARATOR": null,
"TIME_FORMAT": null,
"TIME_SEPARATOR": null,
"REFERENCE_LIBRARY": null,
"REFERENCE_FILE": null,
"REFERENCE_FORMAT": null,
"REFERENCE_FIELD": null,
"EDIT_CODE": null,
"EDIT_CODE_FILL": null,
"EDIT_WORD": null,
"COLUMN_USAGE": "BOTH",
"JOIN_REFERENCE": null,
"INTERNAL_FIELD_NAME": "PARCOURS"
}#173 (comment){
"criteres": {
"table": "BTRLIG",
"schema": "EURO4",
"config": "config_DEMO"
},
"table": {
"TNAME": "BTRLIG",
"TSCHEMA": "EURO4",
"LAST_ALTERED_TIMESTAMP": "2023-06-04-11.54.24.830000",
"TITLE": "003 \"Lignes\" du BT N",
"TABLE_TYPE": "T",
"jsTIMESTAMP": 1685872464830
},
"columns": [
{
"FIELD": "NBTR",
"DDS": "A",
"ALIAS": "NBTR",
"DATA_TYPE": "CHAR",
"DFT_VALUE": "' '",
"TITLE": "N° Bordereau transporteur",
"POS": 1,
"LEN": 8,
"DEC": 0,
"DSTYPE": "A",
"NULLABLE": "",
"READONLY": "",
"KEYN": 1
},
{
"FIELD": "NLBT",
"DDS": "S",
"ALIAS": "NLBT",
"DATA_TYPE": "NUMERIC",
"DFT_VALUE": "0",
"TITLE": "N° ligne du B.T.",
"POS": 2,
"LEN": 5,
"DEC": 2,
"DSTYPE": "N",
"NULLABLE": "",
"READONLY": "",
"KEYN": 2
},
{
"FIELD": "TRFD",
"DDS": "A",
"ALIAS": "TRFD",
"DATA_TYPE": "CHAR",
"DFT_VALUE": "' '",
"TITLE": "Type de référence document",
"POS": 3,
"LEN": 3,
"DEC": 0,
"DSTYPE": "A",
"NULLABLE": "",
"READONLY": ""
},
{
"FIELD": "REFD",
"DDS": "A",
"ALIAS": "REFD",
"DATA_TYPE": "CHAR",
"DFT_VALUE": "' '",
"TITLE": "Référence document",
"POS": 4,
"LEN": 13,
"DEC": 0,
"DSTYPE": "A",
"NULLABLE": "",
"READONLY": ""
},
{
"FIELD": "LIGN",
"DDS": "S",
"ALIAS": "LIGN",
"DATA_TYPE": "NUMERIC",
"DFT_VALUE": "0",
"TITLE": "N° ligne",
"POS": 5,
"LEN": 7,
"DEC": 0,
"DSTYPE": "I",
"NULLABLE": "",
"READONLY": ""
},
{
"FIELD": "NDOC",
"DDS": "A",
"ALIAS": "NDOC",
"DATA_TYPE": "CHAR",
"DFT_VALUE": "' '",
"TITLE": "N° Document",
"POS": 6,
"LEN": 8,
"DEC": 0,
"DSTYPE": "A",
"NULLABLE": "",
"READONLY": ""
},
{
"FIELD": "NLIC",
"DDS": "S",
"ALIAS": "NLIC",
"DATA_TYPE": "NUMERIC",
"DFT_VALUE": "0",
"TITLE": "N° ligne",
"POS": 7,
"LEN": 7,
"DEC": 3,
"DSTYPE": "N",
"NULLABLE": "",
"READONLY": ""
},
{
"FIELD": "LILT",
"DDS": "A",
"ALIAS": "LILT",
"DATA_TYPE": "CHAR",
"DFT_VALUE": "' '",
"TITLE": "Libellé de livraison Tournée",
"POS": 8,
"LEN": 200,
"DEC": 0,
"DSTYPE": "A",
"NULLABLE": "",
"READONLY": ""
},
{
"FIELD": "HHAC",
"DDS": "S",
"ALIAS": "HHAC",
"DATA_TYPE": "NUMERIC",
"DFT_VALUE": "0",
"TITLE": "Heure d'arrivée chez le client",
"POS": 9,
"LEN": 4,
"DEC": 0,
"DSTYPE": "I",
"NULLABLE": "",
"READONLY": ""
},
{
"FIELD": "HACD",
"DDS": "S",
"ALIAS": "HACD",
"DATA_TYPE": "NUMERIC",
"DFT_VALUE": "0",
"TITLE": "Heure d'arrivée chez le client De",
"POS": 10,
"LEN": 4,
"DEC": 0,
"DSTYPE": "I",
"NULLABLE": "",
"READONLY": ""
},
{
"FIELD": "HACF",
"DDS": "S",
"ALIAS": "HACF",
"DATA_TYPE": "NUMERIC",
"DFT_VALUE": "0",
"TITLE": "Heure d'arrivée chez le client A",
"POS": 11,
"LEN": 4,
"DEC": 0,
"DSTYPE": "I",
"NULLABLE": "",
"READONLY": ""
},
{
"FIELD": "GPSX",
"DDS": "S",
"ALIAS": "GPSX",
"DATA_TYPE": "NUMERIC",
"DFT_VALUE": "0",
"TITLE": "Longitude (GPS)",
"POS": 12,
"LEN": 10,
"DEC": 6,
"DSTYPE": "N",
"NULLABLE": "",
"READONLY": ""
},
{
"FIELD": "GPSY",
"DDS": "S",
"ALIAS": "GPSY",
"DATA_TYPE": "NUMERIC",
"DFT_VALUE": "0",
"TITLE": "Latitude (GPS)",
"POS": 13,
"LEN": 10,
"DEC": 6,
"DSTYPE": "N",
"NULLABLE": "",
"READONLY": ""
},
{
"FIELD": "GEOK",
"DDS": "A",
"ALIAS": "GEOK",
"DATA_TYPE": "CHAR",
"DFT_VALUE": "' '",
"TITLE": "Flag Geolocalisation OK",
"POS": 14,
"LEN": 1,
"DEC": 0,
"DSTYPE": "A",
"NULLABLE": "",
"READONLY": ""
},
{
"FIELD": "NSEQ",
"DDS": "S",
"ALIAS": "NSEQ",
"DATA_TYPE": "NUMERIC",
"DFT_VALUE": "0",
"TITLE": "N° séquence",
"POS": 15,
"LEN": 5,
"DEC": 2,
"DSTYPE": "N",
"NULLABLE": "",
"READONLY": ""
},
{
"FIELD": "FARS",
"DDS": "A",
"ALIAS": "FARS",
"DATA_TYPE": "CHAR",
"DFT_VALUE": "' '",
"TITLE": "Flag Avec Réserve",
"POS": 16,
"LEN": 1,
"DEC": 0,
"DSTYPE": "A",
"NULLABLE": "",
"READONLY": ""
},
{
"FIELD": "RMRQ",
"DDS": "A",
"ALIAS": "RMRQ",
"DATA_TYPE": "CHAR",
"DFT_VALUE": "' '",
"TITLE": "Remarque",
"POS": 17,
"LEN": 250,
"DEC": 0,
"DSTYPE": "A",
"NULLABLE": "",
"READONLY": ""
},
{
"FIELD": "HARC",
"DDS": "S",
"ALIAS": "HARC",
"DATA_TYPE": "NUMERIC",
"DFT_VALUE": "0",
"TITLE": "Heure Arrivée Réelle",
"POS": 18,
"LEN": 4,
"DEC": 0,
"DSTYPE": "I",
"NULLABLE": "",
"READONLY": ""
},
{
"FIELD": "HDRC",
"DDS": "S",
"ALIAS": "HDRC",
"DATA_TYPE": "NUMERIC",
"DFT_VALUE": "0",
"TITLE": "Heure Départ Réelle",
"POS": 19,
"LEN": 4,
"DEC": 0,
"DSTYPE": "I",
"NULLABLE": "",
"READONLY": ""
},
{
"FIELD": "HACC",
"DDS": "S",
"ALIAS": "HACC",
"DATA_TYPE": "NUMERIC",
"DFT_VALUE": "0",
"TITLE": "Heure Arrivée Calculée",
"POS": 20,
"LEN": 4,
"DEC": 0,
"DSTYPE": "I",
"NULLABLE": "",
"READONLY": ""
},
{
"FIELD": "HDCC",
"DDS": "S",
"ALIAS": "HDCC",
"DATA_TYPE": "NUMERIC",
"DFT_VALUE": "0",
"TITLE": "Heure Départ Calculée",
"POS": 21,
"LEN": 4,
"DEC": 0,
"DSTYPE": "I",
"NULLABLE": "",
"READONLY": ""
},
{
"FIELD": "HHDT",
"DDS": "S",
"ALIAS": "HHDT",
"DATA_TYPE": "NUMERIC",
"DFT_VALUE": "0",
"TITLE": "Durée (h) du transit",
"POS": 22,
"LEN": 4,
"DEC": 0,
"DSTYPE": "I",
"NULLABLE": "",
"READONLY": ""
},
{
"FIELD": "HHDD",
"DDS": "S",
"ALIAS": "HHDD",
"DATA_TYPE": "NUMERIC",
"DFT_VALUE": "0",
"TITLE": "Durée (h) du déchargement",
"POS": 23,
"LEN": 4,
"DEC": 0,
"DSTYPE": "I",
"NULLABLE": "",
"READONLY": ""
},
{
"FIELD": "IFOB",
"DDS": "A",
"ALIAS": "IFOB",
"DATA_TYPE": "CHAR",
"DFT_VALUE": "' '",
"TITLE": "Mode Info BL",
"POS": 24,
"LEN": 3,
"DEC": 0,
"DSTYPE": "A",
"NULLABLE": "",
"READONLY": ""
},
{
"FIELD": "NILI",
"DDS": "A",
"ALIAS": "NILI",
"DATA_TYPE": "CHAR",
"DFT_VALUE": "' '",
"TITLE": "N° Interlocuteur Livraison",
"POS": 25,
"LEN": 8,
"DEC": 0,
"DSTYPE": "A",
"NULLABLE": "",
"READONLY": ""
},
{
"FIELD": "ELIV",
"DDS": "A",
"ALIAS": "ELIV",
"DATA_TYPE": "CHAR",
"DFT_VALUE": "' '",
"TITLE": "Code état livraison",
"POS": 26,
"LEN": 10,
"DEC": 0,
"DSTYPE": "A",
"NULLABLE": "",
"READONLY": ""
},
{
"FIELD": "FLIF",
"DDS": "A",
"ALIAS": "FLIF",
"DATA_TYPE": "CHAR",
"DFT_VALUE": "' '",
"TITLE": "Flag Livraison Faite",
"POS": 27,
"LEN": 1,
"DEC": 0,
"DSTYPE": "A",
"NULLABLE": "",
"READONLY": ""
},
{
"FIELD": "HMIN",
"DDS": "S",
"ALIAS": "HMIN",
"DATA_TYPE": "NUMERIC",
"DFT_VALUE": "0",
"TITLE": "Heure Mini",
"POS": 28,
"LEN": 4,
"DEC": 0,
"DSTYPE": "I",
"NULLABLE": "",
"READONLY": ""
},
{
"FIELD": "HMAX",
"DDS": "S",
"ALIAS": "HMAX",
"DATA_TYPE": "NUMERIC",
"DFT_VALUE": "0",
"TITLE": "Heure Maxi",
"POS": 29,
"LEN": 4,
"DEC": 0,
"DSTYPE": "I",
"NULLABLE": "",
"READONLY": ""
},
{
"FIELD": "TCTR",
"DDS": "A",
"ALIAS": "TCTR",
"DATA_TYPE": "CHAR",
"DFT_VALUE": "' '",
"TITLE": "Texte Contrainte",
"POS": 30,
"LEN": 200,
"DEC": 0,
"DSTYPE": "A",
"NULLABLE": "",
"READONLY": ""
},
{
"FIELD": "STRN",
"DDS": "S",
"ALIAS": "STRN",
"DATA_TYPE": "NUMERIC",
"DFT_VALUE": "0",
"TITLE": "Séquence tournée",
"POS": 31,
"LEN": 5,
"DEC": 2,
"DSTYPE": "N",
"NULLABLE": "",
"READONLY": ""
},
{
"FIELD": "FVDF",
"DDS": "A",
"ALIAS": "FVDF",
"DATA_TYPE": "CHAR",
"DFT_VALUE": "' '",
"TITLE": "Flag Signature",
"POS": 32,
"LEN": 1,
"DEC": 0,
"DSTYPE": "A",
"NULLABLE": "",
"READONLY": ""
},
{
"FIELD": "NLBC",
"DDS": "S",
"ALIAS": "NLBC",
"DATA_TYPE": "NUMERIC",
"DFT_VALUE": "0",
"TITLE": "N° de container du B.T.",
"POS": 33,
"LEN": 3,
"DEC": 0,
"DSTYPE": "I",
"NULLABLE": "",
"READONLY": ""
},
{
"FIELD": "UTIC",
"DDS": "A",
"ALIAS": "UTIC",
"DATA_TYPE": "CHAR",
"DFT_VALUE": "' '",
"TITLE": "Utilisateur création",
"POS": 34,
"LEN": 10,
"DEC": 0,
"DSTYPE": "A",
"NULLABLE": "",
"READONLY": ""
},
{
"FIELD": "DTC8",
"DDS": "S",
"ALIAS": "DTC8",
"DATA_TYPE": "NUMERIC",
"DFT_VALUE": "0",
"TITLE": "Date création",
"POS": 35,
"LEN": 8,
"DEC": 0,
"DSTYPE": "I",
"NULLABLE": "",
"READONLY": ""
},
{
"FIELD": "HHC6",
"DDS": "S",
"ALIAS": "HHC6",
"DATA_TYPE": "NUMERIC",
"DFT_VALUE": "0",
"TITLE": "Heure création",
"POS": 36,
"LEN": 6,
"DEC": 0,
"DSTYPE": "I",
"NULLABLE": "",
"READONLY": ""
},
{
"FIELD": "UTIM",
"DDS": "A",
"ALIAS": "UTIM",
"DATA_TYPE": "CHAR",
"DFT_VALUE": "' '",
"TITLE": "Utilisateur ayant fait la dernière màj",
"POS": 37,
"LEN": 10,
"DEC": 0,
"DSTYPE": "A",
"NULLABLE": "",
"READONLY": ""
},
{
"FIELD": "DMA8",
"DDS": "S",
"ALIAS": "DMA8",
"DATA_TYPE": "NUMERIC",
"DFT_VALUE": "0",
"TITLE": "Date de dernière mise à jour",
"POS": 38,
"LEN": 8,
"DEC": 0,
"DSTYPE": "I",
"NULLABLE": "",
"READONLY": ""
},
{
"FIELD": "HHM6",
"DDS": "S",
"ALIAS": "HHM6",
"DATA_TYPE": "NUMERIC",
"DFT_VALUE": "0",
"TITLE": "Heure de modification",
"POS": 39,
"LEN": 6,
"DEC": 0,
"DSTYPE": "I",
"NULLABLE": "",
"READONLY": ""
},
{
"FIELD": "IDUNIQ",
"DDS": "A",
"ALIAS": "IDUNIQ",
"DATA_TYPE": "CHAR",
"DFT_VALUE": "' '",
"TITLE": "Identifiant unique fichier/enregistrement",
"POS": 40,
"LEN": 32,
"DEC": 0,
"DSTYPE": "A",
"NULLABLE": "",
"READONLY": ""
},
{
"FIELD": "ENRV",
"DDS": "A",
"ALIAS": "ENRV",
"DATA_TYPE": "CHAR",
"DFT_VALUE": "' '",
"TITLE": "Enregistrement valide",
"POS": 41,
"LEN": 1,
"DEC": 0,
"DSTYPE": "A",
"NULLABLE": "",
"READONLY": ""
},
{
"FIELD": "DISM",
"DDS": "S",
"ALIAS": "DISM",
"DATA_TYPE": "NUMERIC",
"DFT_VALUE": "0",
"TITLE": "Distance en mètre",
"POS": 42,
"LEN": 10,
"DEC": 0,
"DSTYPE": "I",
"NULLABLE": "",
"READONLY": ""
},
{
"FIELD": "DRTS",
"DDS": "S",
"ALIAS": "DRTS",
"DATA_TYPE": "NUMERIC",
"DFT_VALUE": "0",
"TITLE": "Durée en seconde",
"POS": 43,
"LEN": 10,
"DEC": 0,
"DSTYPE": "I",
"NULLABLE": "",
"READONLY": ""
},
{
"FIELD": "GPSX2",
"DDS": "S",
"ALIAS": "GPSX2",
"DATA_TYPE": "NUMERIC",
"DFT_VALUE": "0",
"TITLE": "Longitude (GPS)",
"POS": 44,
"LEN": 10,
"DEC": 6,
"DSTYPE": "N",
"NULLABLE": "",
"READONLY": ""
},
{
"FIELD": "GPSY2",
"DDS": "S",
"ALIAS": "GPSY2",
"DATA_TYPE": "NUMERIC",
"DFT_VALUE": "0",
"TITLE": "Latitude (GPS)",
"POS": 45,
"LEN": 10,
"DEC": 6,
"DSTYPE": "N",
"NULLABLE": "",
"READONLY": ""
},
{
"FIELD": "PARCOURS",
"DDS": "1",
"ALIAS": "PARCOURS",
"DATA_TYPE": "CLOB",
"DFT_VALUE": null,
"TITLE": "Parcours",
"POS": 46,
"LEN": 99999,
"DEC": 0,
"DSTYPE": "A",
"NULLABLE": "1",
"READONLY": ""
}
],
"iColumns": {
"NBTR": {
"FIELD": "NBTR",
"DDS": "A",
"ALIAS": "NBTR",
"DATA_TYPE": "CHAR",
"DFT_VALUE": "' '",
"TITLE": "N° Bordereau transporteur",
"POS": 1,
"LEN": 8,
"DEC": 0,
"DSTYPE": "A",
"NULLABLE": "",
"READONLY": "",
"KEYN": 1
},
"NLBT": {
"FIELD": "NLBT",
"DDS": "S",
"ALIAS": "NLBT",
"DATA_TYPE": "NUMERIC",
"DFT_VALUE": "0",
"TITLE": "N° ligne du B.T.",
"POS": 2,
"LEN": 5,
"DEC": 2,
"DSTYPE": "N",
"NULLABLE": "",
"READONLY": "",
"KEYN": 2
},
"TRFD": {
"FIELD": "TRFD",
"DDS": "A",
"ALIAS": "TRFD",
"DATA_TYPE": "CHAR",
"DFT_VALUE": "' '",
"TITLE": "Type de référence document",
"POS": 3,
"LEN": 3,
"DEC": 0,
"DSTYPE": "A",
"NULLABLE": "",
"READONLY": ""
},
"REFD": {
"FIELD": "REFD",
"DDS": "A",
"ALIAS": "REFD",
"DATA_TYPE": "CHAR",
"DFT_VALUE": "' '",
"TITLE": "Référence document",
"POS": 4,
"LEN": 13,
"DEC": 0,
"DSTYPE": "A",
"NULLABLE": "",
"READONLY": ""
},
"LIGN": {
"FIELD": "LIGN",
"DDS": "S",
"ALIAS": "LIGN",
"DATA_TYPE": "NUMERIC",
"DFT_VALUE": "0",
"TITLE": "N° ligne",
"POS": 5,
"LEN": 7,
"DEC": 0,
"DSTYPE": "I",
"NULLABLE": "",
"READONLY": ""
},
"NDOC": {
"FIELD": "NDOC",
"DDS": "A",
"ALIAS": "NDOC",
"DATA_TYPE": "CHAR",
"DFT_VALUE": "' '",
"TITLE": "N° Document",
"POS": 6,
"LEN": 8,
"DEC": 0,
"DSTYPE": "A",
"NULLABLE": "",
"READONLY": ""
},
"NLIC": {
"FIELD": "NLIC",
"DDS": "S",
"ALIAS": "NLIC",
"DATA_TYPE": "NUMERIC",
"DFT_VALUE": "0",
"TITLE": "N° ligne",
"POS": 7,
"LEN": 7,
"DEC": 3,
"DSTYPE": "N",
"NULLABLE": "",
"READONLY": ""
},
"LILT": {
"FIELD": "LILT",
"DDS": "A",
"ALIAS": "LILT",
"DATA_TYPE": "CHAR",
"DFT_VALUE": "' '",
"TITLE": "Libellé de livraison Tournée",
"POS": 8,
"LEN": 200,
"DEC": 0,
"DSTYPE": "A",
"NULLABLE": "",
"READONLY": ""
},
"HHAC": {
"FIELD": "HHAC",
"DDS": "S",
"ALIAS": "HHAC",
"DATA_TYPE": "NUMERIC",
"DFT_VALUE": "0",
"TITLE": "Heure d'arrivée chez le client",
"POS": 9,
"LEN": 4,
"DEC": 0,
"DSTYPE": "I",
"NULLABLE": "",
"READONLY": ""
},
"HACD": {
"FIELD": "HACD",
"DDS": "S",
"ALIAS": "HACD",
"DATA_TYPE": "NUMERIC",
"DFT_VALUE": "0",
"TITLE": "Heure d'arrivée chez le client De",
"POS": 10,
"LEN": 4,
"DEC": 0,
"DSTYPE": "I",
"NULLABLE": "",
"READONLY": ""
},
"HACF": {
"FIELD": "HACF",
"DDS": "S",
"ALIAS": "HACF",
"DATA_TYPE": "NUMERIC",
"DFT_VALUE": "0",
"TITLE": "Heure d'arrivée chez le client A",
"POS": 11,
"LEN": 4,
"DEC": 0,
"DSTYPE": "I",
"NULLABLE": "",
"READONLY": ""
},
"GPSX": {
"FIELD": "GPSX",
"DDS": "S",
"ALIAS": "GPSX",
"DATA_TYPE": "NUMERIC",
"DFT_VALUE": "0",
"TITLE": "Longitude (GPS)",
"POS": 12,
"LEN": 10,
"DEC": 6,
"DSTYPE": "N",
"NULLABLE": "",
"READONLY": ""
},
"GPSY": {
"FIELD": "GPSY",
"DDS": "S",
"ALIAS": "GPSY",
"DATA_TYPE": "NUMERIC",
"DFT_VALUE": "0",
"TITLE": "Latitude (GPS)",
"POS": 13,
"LEN": 10,
"DEC": 6,
"DSTYPE": "N",
"NULLABLE": "",
"READONLY": ""
},
"GEOK": {
"FIELD": "GEOK",
"DDS": "A",
"ALIAS": "GEOK",
"DATA_TYPE": "CHAR",
"DFT_VALUE": "' '",
"TITLE": "Flag Geolocalisation OK",
"POS": 14,
"LEN": 1,
"DEC": 0,
"DSTYPE": "A",
"NULLABLE": "",
"READONLY": ""
},
"NSEQ": {
"FIELD": "NSEQ",
"DDS": "S",
"ALIAS": "NSEQ",
"DATA_TYPE": "NUMERIC",
"DFT_VALUE": "0",
"TITLE": "N° séquence",
"POS": 15,
"LEN": 5,
"DEC": 2,
"DSTYPE": "N",
"NULLABLE": "",
"READONLY": ""
},
"FARS": {
"FIELD": "FARS",
"DDS": "A",
"ALIAS": "FARS",
"DATA_TYPE": "CHAR",
"DFT_VALUE": "' '",
"TITLE": "Flag Avec Réserve",
"POS": 16,
"LEN": 1,
"DEC": 0,
"DSTYPE": "A",
"NULLABLE": "",
"READONLY": ""
},
"RMRQ": {
"FIELD": "RMRQ",
"DDS": "A",
"ALIAS": "RMRQ",
"DATA_TYPE": "CHAR",
"DFT_VALUE": "' '",
"TITLE": "Remarque",
"POS": 17,
"LEN": 250,
"DEC": 0,
"DSTYPE": "A",
"NULLABLE": "",
"READONLY": ""
},
"HARC": {
"FIELD": "HARC",
"DDS": "S",
"ALIAS": "HARC",
"DATA_TYPE": "NUMERIC",
"DFT_VALUE": "0",
"TITLE": "Heure Arrivée Réelle",
"POS": 18,
"LEN": 4,
"DEC": 0,
"DSTYPE": "I",
"NULLABLE": "",
"READONLY": ""
},
"HDRC": {
"FIELD": "HDRC",
"DDS": "S",
"ALIAS": "HDRC",
"DATA_TYPE": "NUMERIC",
"DFT_VALUE": "0",
"TITLE": "Heure Départ Réelle",
"POS": 19,
"LEN": 4,
"DEC": 0,
"DSTYPE": "I",
"NULLABLE": "",
"READONLY": ""
},
"HACC": {
"FIELD": "HACC",
"DDS": "S",
"ALIAS": "HACC",
"DATA_TYPE": "NUMERIC",
"DFT_VALUE": "0",
"TITLE": "Heure Arrivée Calculée",
"POS": 20,
"LEN": 4,
"DEC": 0,
"DSTYPE": "I",
"NULLABLE": "",
"READONLY": ""
},
"HDCC": {
"FIELD": "HDCC",
"DDS": "S",
"ALIAS": "HDCC",
"DATA_TYPE": "NUMERIC",
"DFT_VALUE": "0",
"TITLE": "Heure Départ Calculée",
"POS": 21,
"LEN": 4,
"DEC": 0,
"DSTYPE": "I",
"NULLABLE": "",
"READONLY": ""
},
"HHDT": {
"FIELD": "HHDT",
"DDS": "S",
"ALIAS": "HHDT",
"DATA_TYPE": "NUMERIC",
"DFT_VALUE": "0",
"TITLE": "Durée (h) du transit",
"POS": 22,
"LEN": 4,
"DEC": 0,
"DSTYPE": "I",
"NULLABLE": "",
"READONLY": ""
},
"HHDD": {
"FIELD": "HHDD",
"DDS": "S",
"ALIAS": "HHDD",
"DATA_TYPE": "NUMERIC",
"DFT_VALUE": "0",
"TITLE": "Durée (h) du déchargement",
"POS": 23,
"LEN": 4,
"DEC": 0,
"DSTYPE": "I",
"NULLABLE": "",
"READONLY": ""
},
"IFOB": {
"FIELD": "IFOB",
"DDS": "A",
"ALIAS": "IFOB",
"DATA_TYPE": "CHAR",
"DFT_VALUE": "' '",
"TITLE": "Mode Info BL",
"POS": 24,
"LEN": 3,
"DEC": 0,
"DSTYPE": "A",
"NULLABLE": "",
"READONLY": ""
},
"NILI": {
"FIELD": "NILI",
"DDS": "A",
"ALIAS": "NILI",
"DATA_TYPE": "CHAR",
"DFT_VALUE": "' '",
"TITLE": "N° Interlocuteur Livraison",
"POS": 25,
"LEN": 8,
"DEC": 0,
"DSTYPE": "A",
"NULLABLE": "",
"READONLY": ""
},
"ELIV": {
"FIELD": "ELIV",
"DDS": "A",
"ALIAS": "ELIV",
"DATA_TYPE": "CHAR",
"DFT_VALUE": "' '",
"TITLE": "Code état livraison",
"POS": 26,
"LEN": 10,
"DEC": 0,
"DSTYPE": "A",
"NULLABLE": "",
"READONLY": ""
},
"FLIF": {
"FIELD": "FLIF",
"DDS": "A",
"ALIAS": "FLIF",
"DATA_TYPE": "CHAR",
"DFT_VALUE": "' '",
"TITLE": "Flag Livraison Faite",
"POS": 27,
"LEN": 1,
"DEC": 0,
"DSTYPE": "A",
"NULLABLE": "",
"READONLY": ""
},
"HMIN": {
"FIELD": "HMIN",
"DDS": "S",
"ALIAS": "HMIN",
"DATA_TYPE": "NUMERIC",
"DFT_VALUE": "0",
"TITLE": "Heure Mini",
"POS": 28,
"LEN": 4,
"DEC": 0,
"DSTYPE": "I",
"NULLABLE": "",
"READONLY": ""
},
"HMAX": {
"FIELD": "HMAX",
"DDS": "S",
"ALIAS": "HMAX",
"DATA_TYPE": "NUMERIC",
"DFT_VALUE": "0",
"TITLE": "Heure Maxi",
"POS": 29,
"LEN": 4,
"DEC": 0,
"DSTYPE": "I",
"NULLABLE": "",
"READONLY": ""
},
"TCTR": {
"FIELD": "TCTR",
"DDS": "A",
"ALIAS": "TCTR",
"DATA_TYPE": "CHAR",
"DFT_VALUE": "' '",
"TITLE": "Texte Contrainte",
"POS": 30,
"LEN": 200,
"DEC": 0,
"DSTYPE": "A",
"NULLABLE": "",
"READONLY": ""
},
"STRN": {
"FIELD": "STRN",
"DDS": "S",
"ALIAS": "STRN",
"DATA_TYPE": "NUMERIC",
"DFT_VALUE": "0",
"TITLE": "Séquence tournée",
"POS": 31,
"LEN": 5,
"DEC": 2,
"DSTYPE": "N",
"NULLABLE": "",
"READONLY": ""
},
"FVDF": {
"FIELD": "FVDF",
"DDS": "A",
"ALIAS": "FVDF",
"DATA_TYPE": "CHAR",
"DFT_VALUE": "' '",
"TITLE": "Flag Signature",
"POS": 32,
"LEN": 1,
"DEC": 0,
"DSTYPE": "A",
"NULLABLE": "",
"READONLY": ""
},
"NLBC": {
"FIELD": "NLBC",
"DDS": "S",
"ALIAS": "NLBC",
"DATA_TYPE": "NUMERIC",
"DFT_VALUE": "0",
"TITLE": "N° de container du B.T.",
"POS": 33,
"LEN": 3,
"DEC": 0,
"DSTYPE": "I",
"NULLABLE": "",
"READONLY": ""
},
"UTIC": {
"FIELD": "UTIC",
"DDS": "A",
"ALIAS": "UTIC",
"DATA_TYPE": "CHAR",
"DFT_VALUE": "' '",
"TITLE": "Utilisateur création",
"POS": 34,
"LEN": 10,
"DEC": 0,
"DSTYPE": "A",
"NULLABLE": "",
"READONLY": ""
},
"DTC8": {
"FIELD": "DTC8",
"DDS": "S",
"ALIAS": "DTC8",
"DATA_TYPE": "NUMERIC",
"DFT_VALUE": "0",
"TITLE": "Date création",
"POS": 35,
"LEN": 8,
"DEC": 0,
"DSTYPE": "I",
"NULLABLE": "",
"READONLY": ""
},
"HHC6": {
"FIELD": "HHC6",
"DDS": "S",
"ALIAS": "HHC6",
"DATA_TYPE": "NUMERIC",
"DFT_VALUE": "0",
"TITLE": "Heure création",
"POS": 36,
"LEN": 6,
"DEC": 0,
"DSTYPE": "I",
"NULLABLE": "",
"READONLY": ""
},
"UTIM": {
"FIELD": "UTIM",
"DDS": "A",
"ALIAS": "UTIM",
"DATA_TYPE": "CHAR",
"DFT_VALUE": "' '",
"TITLE": "Utilisateur ayant fait la dernière màj",
"POS": 37,
"LEN": 10,
"DEC": 0,
"DSTYPE": "A",
"NULLABLE": "",
"READONLY": ""
},
"DMA8": {
"FIELD": "DMA8",
"DDS": "S",
"ALIAS": "DMA8",
"DATA_TYPE": "NUMERIC",
"DFT_VALUE": "0",
"TITLE": "Date de dernière mise à jour",
"POS": 38,
"LEN": 8,
"DEC": 0,
"DSTYPE": "I",
"NULLABLE": "",
"READONLY": ""
},
"HHM6": {
"FIELD": "HHM6",
"DDS": "S",
"ALIAS": "HHM6",
"DATA_TYPE": "NUMERIC",
"DFT_VALUE": "0",
"TITLE": "Heure de modification",
"POS": 39,
"LEN": 6,
"DEC": 0,
"DSTYPE": "I",
"NULLABLE": "",
"READONLY": ""
},
"IDUNIQ": {
"FIELD": "IDUNIQ",
"DDS": "A",
"ALIAS": "IDUNIQ",
"DATA_TYPE": "CHAR",
"DFT_VALUE": "' '",
"TITLE": "Identifiant unique fichier/enregistrement",
"POS": 40,
"LEN": 32,
"DEC": 0,
"DSTYPE": "A",
"NULLABLE": "",
"READONLY": ""
},
"ENRV": {
"FIELD": "ENRV",
"DDS": "A",
"ALIAS": "ENRV",
"DATA_TYPE": "CHAR",
"DFT_VALUE": "' '",
"TITLE": "Enregistrement valide",
"POS": 41,
"LEN": 1,
"DEC": 0,
"DSTYPE": "A",
"NULLABLE": "",
"READONLY": ""
},
"DISM": {
"FIELD": "DISM",
"DDS": "S",
"ALIAS": "DISM",
"DATA_TYPE": "NUMERIC",
"DFT_VALUE": "0",
"TITLE": "Distance en mètre",
"POS": 42,
"LEN": 10,
"DEC": 0,
"DSTYPE": "I",
"NULLABLE": "",
"READONLY": ""
},
"DRTS": {
"FIELD": "DRTS",
"DDS": "S",
"ALIAS": "DRTS",
"DATA_TYPE": "NUMERIC",
"DFT_VALUE": "0",
"TITLE": "Durée en seconde",
"POS": 43,
"LEN": 10,
"DEC": 0,
"DSTYPE": "I",
"NULLABLE": "",
"READONLY": ""
},
"GPSX2": {
"FIELD": "GPSX2",
"DDS": "S",
"ALIAS": "GPSX2",
"DATA_TYPE": "NUMERIC",
"DFT_VALUE": "0",
"TITLE": "Longitude (GPS)",
"POS": 44,
"LEN": 10,
"DEC": 6,
"DSTYPE": "N",
"NULLABLE": "",
"READONLY": ""
},
"GPSY2": {
"FIELD": "GPSY2",
"DDS": "S",
"ALIAS": "GPSY2",
"DATA_TYPE": "NUMERIC",
"DFT_VALUE": "0",
"TITLE": "Latitude (GPS)",
"POS": 45,
"LEN": 10,
"DEC": 6,
"DSTYPE": "N",
"NULLABLE": "",
"READONLY": ""
},
"PARCOURS": {
"FIELD": "PARCOURS",
"DDS": "1",
"ALIAS": "PARCOURS",
"DATA_TYPE": "CLOB",
"DFT_VALUE": null,
"TITLE": "Parcours",
"POS": 46,
"LEN": 99999,
"DEC": 0,
"DSTYPE": "A",
"NULLABLE": "1",
"READONLY": ""
}
},
"i0": [
"NBTR",
"NLBT"
]
} |
|
👋 Hi! This issue has been marked stale due to inactivity. If no further activity occurs, it will automatically be closed. |
|
Hi, this problem is still active, and for the moment, the only workaround technique is to add space characters in the query with a "CONCAT" (tested with version 1.2.19 ). To workaround:
|
|
Hi @Didier68 👋🏿 Per out last discussion see #173 (comment), #173 (comment) were you able to create a script that reproduces the error? Thanks! |
Node.js version: v14.21.3
idb-connector version: 1.2.18
IBM i version: V7 R3
I have a table with a column "PARCOURS", defined in CLOB, where I store "route" fragments in JSON format.
It run well for every data, except for 1 specific row, for the value
{"via_waypoints":[],"admins":[{"iso_3166_1_alpha3":"FRA","iso_3166_1":"FR"}],"weight":1078.218,"duration":866.839,"steps":[],"distance":8118.946,"summary":"Rue du Gers, Rue de Bâle"}
For all others data of this table, there is no read problem...
The text was updated successfully, but these errors were encountered: