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:
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:
How can I fix it?
Thank you
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).
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
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.
Thank you Andrew!
I really appreciate your availability and your work!
I will wait for your news.
Thank you.
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?
Hi Andrew,
Great! Now everything works correctly.
The fields are detected like numbers.
Thank you!
BR