search

IBM / nodejs-idb-connector

A JavaScript (Node.js) library for communicating with Db2 for IBM i, with support for queries, procedures, and much more. Uses traditional callback-style syntax
MIT License
37 stars 23 forks source link

CLOB: truncation of the last char ! #173

Open Didier68 opened 1 year ago

Didier68 commented 1 year ago

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"}

abmusse commented 1 year ago

Hello @Didier68

I think the next step is to create a script that reproduces the bug.

The recreate script should:

1) Create the Table 2) Insert the offending data 3) Select from the Table 4) Show the error message run into

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'
Didier68 commented 1 year ago

Hello @abmusse , I will prepare the script...

The result of the query on SYSCOLUMNS2:

{"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"}

Didier68 commented 1 year ago

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"]}

abmusse commented 1 year ago

I will prepare the script...

Thank you!

abmusse commented 1 year ago

I've formatted JSON from https://github.com/IBM/nodejs-idb-connector/issues/173#issuecomment-1637502311 and https://github.com/IBM/nodejs-idb-connector/issues/173#issuecomment-1637504547 for readability

https://github.com/IBM/nodejs-idb-connector/issues/173#issuecomment-1637502311

{
   "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"
}

https://github.com/IBM/nodejs-idb-connector/issues/173#issuecomment-1637504547

{
   "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"
   ]
}
github-actions[bot] commented 1 year ago

:wave: Hi! This issue has been marked stale due to inactivity. If no further activity occurs, it will automatically be closed.

Didier68 commented 2 months ago

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:

select concat(XML_DATA, ' '), XML_DATA from TABLEX...

abmusse commented 2 months ago

Hi @Didier68 👋🏿

Per out last discussion see https://github.com/IBM/nodejs-idb-connector/issues/173#issuecomment-1635033531, https://github.com/IBM/nodejs-idb-connector/issues/173#issuecomment-1637502311 were you able to create a script that reproduces the error? If so, please paste the script in a comment below. That would help move forward finding the root cause of the issue.

Thanks!