# Update Database Table (Detection Datatype)

**URL:** <https://community.easymorph.com/t/update-database-table-detection-datatype/5193>\
**Category:** Support\
**Created:** [March 1, 2024, 12:39pm UTC](https://community.easymorph.com/t/update-database-table-detection-datatype/5193 "2024-03-01T12:39:07Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![csofonio](https://community.easymorph.com/letter_avatar_proxy/v4/letter/c/c6cbf5/32.png) [@csofonio](https://community.easymorph.com/u/csofonio)\
**Post date:** [March 1, 2024, 12:39pm UTC](https://community.easymorph.com/t/update-database-table-detection-datatype/5193/1 "2024-03-01T12:39:07Z")

</div>

Hi guys,  
I'm writing a new topic, because I don't find a solution about my problem in others topics.

I must update an As400/JDE database table and my primary key is composed by 4 fields:

 ![image](https://community.easymorph.com/uploads/default/original/2X/c/c97280c1249ff518c4575bc9e776e75c43ef146e.png)

The fields PDDOCO and PDLNID are "Document Number" and "Document Line Number", both the fields are numeric.

EasyMorph doesn't detect the type of columns and when I try to run the update,  
EM shows this error:

 ![image](https://community.easymorph.com/uploads/default/original/2X/e/e27b53471ca855417fa58fb651269a5df39c0a74.png)

How can I fix it?

Thank you

---

<div class="post-metadata">

**Author:** ![andrew.rybka](https://community.easymorph.com/user_avatar/community.easymorph.com/andrew.rybka/32/13_2.png) [@andrew.rybka](https://community.easymorph.com/u/andrew.rybka)\
**Post date:** [March 1, 2024, 12:52pm UTC](https://community.easymorph.com/t/update-database-table-detection-datatype/5193/2 "2024-03-01T12:52:02Z")

</div>

Hi @csofonio,

There is no workaround for this issue. However, we may be able to update EasyMorph to support such columns.

Please create and run a "Database command action" with the "List table fields" command and the table in question selected and post the results of that action execution (or send it to our support email).

---

<div class="post-metadata">

**Author:** ![csofonio](https://community.easymorph.com/letter_avatar_proxy/v4/letter/c/c6cbf5/32.png) [@csofonio](https://community.easymorph.com/u/csofonio)\
**Post date:** [March 1, 2024, 1:11pm UTC](https://community.easymorph.com/t/update-database-table-detection-datatype/5193/3 "2024-03-01T13:11:19Z")

</div>

Thank you Andrew,  
Below the export required.

| Column name | Column data type | Column annotation |
| --- | --- | --- |
| PDKCOO | CHARACTER | |
| PDDOCO | NUMERIC | |
| PDDCTO | CHARACTER | |
| PDSFXO | CHARACTER | |
| PDLNID | DECIMAL | |
| PDMCU | CHARACTER | |
| PDCO | CHARACTER | |
| PDOKCO | CHARACTER | |
| PDOORN | CHARACTER | |
| PDOCTO | CHARACTER | |
| PDOGNO | DECIMAL | |
| PDRKCO | CHARACTER | |
| PDRORN | CHARACTER | |
| PDRCTO | CHARACTER | |
| PDRLLN | DECIMAL | |
| PDDMCT | CHARACTER | |
| PDDMCS | NUMERIC | |
| PDBALU | CHARACTER | |
| PDAN8 | NUMERIC | |
| PDSHAN | NUMERIC | |
| PDDRQJ | NUMERIC | |
| PDTRDJ | NUMERIC | |
| PDPDDJ | NUMERIC | |
| PDOPDJ | NUMERIC | |
| PDADDJ | NUMERIC | |
| PDCNDJ | NUMERIC | |
| PDPEFJ | NUMERIC | |
| PDPPDJ | NUMERIC | |
| PDPSDJ | NUMERIC | |
| PDDSVJ | NUMERIC | |
| PDDGL | NUMERIC | |
| PDPN | NUMERIC | |
| PDVR01 | CHARACTER | |
| PDVR02 | CHARACTER | |
| PDITM | NUMERIC | |
| PDLITM | CHARACTER | |
| PDAITM | CHARACTER | |
| PDLOCN | CHARACTER | |
| PDLOTN | CHARACTER | |
| PDFRGD | CHARACTER | |
| PDTHGD | CHARACTER | |
| PDFRMP | DECIMAL | |
| PDTHRP | DECIMAL | |
| PDDSC1 | CHARACTER | |
| PDDSC2 | CHARACTER | |
| PDLNTY | CHARACTER | |
| PDNXTR | CHARACTER | |
| PDLTTR | CHARACTER | |
| PDRLIT | CHARACTER | |
| PDPDS1 | CHARACTER | |
| PDPDS2 | CHARACTER | |
| PDPDS3 | CHARACTER | |
| PDPDS4 | CHARACTER | |
| PDPDS5 | CHARACTER | |
| PDPDP1 | CHARACTER | |
| PDPDP2 | CHARACTER | |
| PDPDP3 | CHARACTER | |
| PDPDP4 | CHARACTER | |
| PDPDP5 | CHARACTER | |
| PDUOM | CHARACTER | |
| PDUORG | DECIMAL | |
| PDUCHG | DECIMAL | |
| PDUOPN | DECIMAL | |
| PDUREC | DECIMAL | |
| PDCREC | DECIMAL | |
| PDURLV | DECIMAL | |
| PDOTQY | CHARACTER | |
| PDPRRC | DECIMAL | |
| PDAEXP | DECIMAL | |
| PDACHG | DECIMAL | |
| PDAOPN | DECIMAL | |
| PDAREC | DECIMAL | |
| PDARLV | DECIMAL | |
| PDFTN1 | DECIMAL | |
| PDTRLV | DECIMAL | |
| PDPROV | CHARACTER | |
| PDAMC3 | DECIMAL | |
| PDECST | DECIMAL | |
| PDCSTO | CHARACTER | |
| PDCSMP | CHARACTER | |
| PDINMG | CHARACTER | |
| PDASN | CHARACTER | |
| PDPRGR | CHARACTER | |
| PDCLVL | CHARACTER | |
| PDCATN | CHARACTER | |
| PDDSPR | DECIMAL | |
| PDPTC | CHARACTER | |
| PDTX | CHARACTER | |
| PDEXR1 | CHARACTER | |
| PDTXA1 | CHARACTER | |
| PDATXT | CHARACTER | |
| PDCNID | CHARACTER | |
| PDCDCD | CHARACTER | |
| PDNTR | CHARACTER | |
| PDFRTH | CHARACTER | |
| PDFRTC | CHARACTER | |
| PDZON | CHARACTER | |
| PDFRAT | CHARACTER | |
| PDRATT | CHARACTER | |
| PDANBY | NUMERIC | |
| PDANCR | NUMERIC | |
| PDMOT | CHARACTER | |
| PDCOT | CHARACTER | |
| PDSHCM | CHARACTER | |
| PDSHCN | CHARACTER | |
| PDUOM1 | CHARACTER | |
| PDPQOR | DECIMAL | |
| PDUOM2 | CHARACTER | |
| PDSQOR | DECIMAL | |
| PDUOM3 | CHARACTER | |
| PDITWT | DECIMAL | |
| PDWTUM | CHARACTER | |
| PDITVL | DECIMAL | |
| PDVLUM | CHARACTER | |
| PDGLC | CHARACTER | |
| PDCTRY | NUMERIC | |
| PDFY | NUMERIC | |
| PDSTTS | CHARACTER | |
| PDRCD | CHARACTER | |
| PDFUF1 | CHARACTER | |
| PDFUF2 | CHARACTER | |
| PDGRWT | DECIMAL | |
| PDGWUM | CHARACTER | |
| PDLT | CHARACTER | |
| PDANI | CHARACTER | |
| PDAID | CHARACTER | |
| PDOMCU | CHARACTER | |
| PDOBJ | CHARACTER | |
| PDSUB | CHARACTER | |
| PDSBLT | CHARACTER | |
| PDSBL | CHARACTER | |
| PDASID | CHARACTER | |
| PDCCMP | NUMERIC | |
| PDTAG | CHARACTER | |
| PDWR01 | CHARACTER | |
| PDPL | CHARACTER | |
| PDELEV | CHARACTER | |
| PDR001 | CHARACTER | |
| PDRTNR | CHARACTER | |
| PDLCOD | CHARACTER | |
| PDPURG | CHARACTER | |
| PDPROM | CHARACTER | |
| PDFNLP | CHARACTER | |
| PDAVCH | CHARACTER | |
| PDPRPY | CHARACTER | |
| PDUNCD | CHARACTER | |
| PDMATY | CHARACTER | |
| PDRTGC | CHARACTER | |
| PDRCPF | CHARACTER | |
| PDPS01 | CHARACTER | |
| PDPS02 | CHARACTER | |
| PDPS03 | CHARACTER | |
| PDPS04 | CHARACTER | |
| PDPS05 | CHARACTER | |
| PDPS06 | CHARACTER | |
| PDPS07 | CHARACTER | |
| PDPS08 | CHARACTER | |
| PDPS09 | CHARACTER | |
| PDPS10 | CHARACTER | |
| PDCRMD | CHARACTER | |
| PDARTG | CHARACTER | |
| PDCORD | NUMERIC | |
| PDCHDT | CHARACTER | |
| PDDOCC | NUMERIC | |
| PDCHLN | DECIMAL | |
| PDCRCD | CHARACTER | |
| PDCRR | DECIMAL | |
| PDFRRC | DECIMAL | |
| PDFEA | DECIMAL | |
| PDFUC | DECIMAL | |
| PDFEC | DECIMAL | |
| PDFCHG | DECIMAL | |
| PDFAP | DECIMAL | |
| PDFREC | DECIMAL | |
| PDURCD | CHARACTER | |
| PDURDT | NUMERIC | |
| PDURAT | DECIMAL | |
| PDURAB | NUMERIC | |
| PDURRF | CHARACTER | |
| PDTORG | CHARACTER | |
| PDUSER | CHARACTER | |
| PDPID | CHARACTER | |
| PDJOBN | CHARACTER | |
| PDUPMJ | NUMERIC | |
| PDTDAY | DECIMAL | |

Thank You

---

<div class="post-metadata">

**Author:** ![andrew.rybka](https://community.easymorph.com/user_avatar/community.easymorph.com/andrew.rybka/32/13_2.png) [@andrew.rybka](https://community.easymorph.com/u/andrew.rybka)\
**Post date:** [March 4, 2024, 10:02am UTC](https://community.easymorph.com/t/update-database-table-detection-datatype/5193/4 "2024-03-04T10:02:02Z")

</div>

Hi @csofonio,

Thank you for the data. Looks like data types are correct, but I noticed that the data type in the error message has a trailing space: `(NUMERIC )`. This is most likely why the column type is not detected correctly.

We will make some adjustments which will take such cases into account. The modified version will be available shortly. I'll let you know when it's ready.

---

<div class="post-metadata">

**Author:** ![csofonio](https://community.easymorph.com/letter_avatar_proxy/v4/letter/c/c6cbf5/32.png) [@csofonio](https://community.easymorph.com/u/csofonio)\
**Post date:** [March 4, 2024, 11:42am UTC](https://community.easymorph.com/t/update-database-table-detection-datatype/5193/5 "2024-03-04T11:42:22Z")

</div>

Thank you Andrew!  
I really appreciate your availability and your work!

I will wait for your news.  
Thank you.

---

<div class="post-metadata">

**Author:** ![andrew.rybka](https://community.easymorph.com/user_avatar/community.easymorph.com/andrew.rybka/32/13_2.png) [@andrew.rybka](https://community.easymorph.com/u/andrew.rybka)\
**Post date:** [March 6, 2024, 11:48am UTC](https://community.easymorph.com/t/update-database-table-detection-datatype/5193/6 "2024-03-06T11:48:32Z")

</div>

Hi @csofonio,

You are welcome!

Can you please download and install the latest EasyMorph version from our website and try to run the "Update DB table" action again? Will it work?

---

<div class="post-metadata">

**Author:** ![csofonio](https://community.easymorph.com/letter_avatar_proxy/v4/letter/c/c6cbf5/32.png) [@csofonio](https://community.easymorph.com/u/csofonio)\
**Post date:** [March 6, 2024, 4:38pm UTC](https://community.easymorph.com/t/update-database-table-detection-datatype/5193/7 "2024-03-06T16:38:01Z")

</div>

Hi Andrew,  
Great! Now everything works correctly.  
The fields are detected like numbers.

Thank you!  
BR

---

<div class="post-metadata">

**Author:** ![andrew.rybka](https://community.easymorph.com/user_avatar/community.easymorph.com/andrew.rybka/32/13_2.png) [@andrew.rybka](https://community.easymorph.com/u/andrew.rybka)\
**Post date:** [March 6, 2024, 9:39pm UTC](https://community.easymorph.com/t/update-database-table-detection-datatype/5193/8 "2024-03-06T21:39:32Z")

</div>

Hi @csofonio,

Thank you for the update.