JDE Decimal value

JDE_Amol

Member
Hi All,
I am fetching data from JD Edwards World database but it is returning me wrong value for decimal field. I did some investigation on that and I came to know that it stores that value in JDE tables in different format and we will have to convert it into proper format.Can anybody tell me what data type JDE uses for storing this value and how to convert it?

Thanks
Amol
 
JD Edwards stores character data in character format and most numeric
fields in either signed decimal or packed decimal format. I have to
assume from your very vague message that you really mean that the
decimal field was returned without the correct number of decimal
positions. JD Edwards stores the definition of the decimal positions in
the Data Dictionary. In an RPG program the program X9800E returns the
dictionary values for the data item (notice I did not say data field)
that the subroutine C00161 uses to apply and format a field for display
or use within the program. This is a really simplified explanation but
it is at the heart of functionality for JD Edwards.



Of course you could mean that you pulled the fields through an ODBC or
iSeries Access Data Transfer and you got hex characters. That would mean
that in the properties that you don't have the "Convert CCSID 65535" box
selected and that would cause numeric data to be extracted in a funny
looking character stream.



Give us more to work with and we can be a lot more helpful.
 
Re: RE: JDE Decimal value

Hi ,
Thanks for your reply. Afetr doing some research what I understood is that JDE stores decimal value in decimal datatype and you do not need do any casting for that because CCSID property is not set for decimal datatype. For character field it is ok you will have to do casting otherwise you will get hex value, that I did.But for decimal field I am facing some problem. could you please tell what I am supposed to do to get correct value for decimal field.
 
RE: RE: JDE Decimal value

I forget what you are originally doing, but if you are trying to do a query
or a client access file transfer, I assume what you want is to turn the JDE
numeric, no decimal value into the
 
Re: RE: JDE Decimal value

You are not help us, help you!!!

You are not defining what you are doing or how you are doing it.
You are using terms of fetch and cast. I would guess you are using SQL.

Also I am assuming that you are using a non-jde tool (jde or 3rd party with
jde support) to retrieve data from jde.
If so, you will need to do some extra work.
JDE stores most date values in a Julian format (actually an abbreviated
format)
JDE stores most numeric values without any decimal places. You need to
either create your own function/procedure to do this or define each "fetch"
to with the correct decimal places. (if you are not using a non-jde tool)

It would be really, really helpful if you would define the tools you are
using.


The more detailed the question, the more detailed the answer!!!!








JDE_Amol
<amol.ghatge@gmail To: [email protected]
.com> cc:
Sent by: Subject: Re: RE: JDE Decimal value
jdeworld-bounces@j
delist.com


02/22/2006 09:06
AM
Please respond to
JD Edwards® World






Hi ,
Thanks for your reply. Afetr doing some research what I understood is that
JDE stores decimal value in decimal datatype and you do not need do any
casting for that because CCSID property is not set for decimal datatype.
For character field it is ok you will have to do casting otherwise you will
get hex value, that I did.But for decimal field I am facing some problem.
could you please tell what I am supposed to do to get correct value for
decimal field.
 
Re: RE: JDE Decimal value

IIRC correctly fetch and cast are from C++ or C#. I have never seen them in
SQL.

You will have to use the JDE Data Dictionary to recast the data from
integer with an implied decimal to a
 
Re: RE: JDE Decimal value

Hi,

I am fetching data from JDE database using non JDE tool. I have written my own program which executes SQL query at JDE side and returns data. As per your saying JDE does not store decimal place with its value then where it stores this information. Do you have any idea which data dictionary's tables does it use for doing this. Julian and character data conversion have been done only that problem is remaining. Please provide me required details.

Regards
Amol
 
Re: RE: JDE Decimal value

Hi JDE Amol
What platform are you using to launch your NON JDE tool ???



Cheers!
___________________
Marsh R Narewec
STC Computer Services



JDE_Amol
<amol.ghatge@gmai To: [email protected]
l.com> cc:
Sent by: Subject: Re: RE: JDE Decimal value
jdeworld-bounces@
jdelist.com


23/02/06 15:21
Please respond to
JD Edwards® World






Hi,

I am fetching data from JDE database using non JDE tool. I have written my
own program which executes SQL query at JDE side and returns data. As per
your saying JDE does not store decimal place with its value then where it
stores this information. Do you have any idea which data dictionary's
tables does it use for doing this. Julian and character data conversion
have been done only that problem is remaining. Please provide me required
details.

Regards
Amol
 
Re: RE: JDE Decimal value

Hi,

I am using CLI APIs to get data from JDE database. My program is running on windows machine and fetching data from JDE database. I want convert that value because it is not in correct format.Please tell me how to convert this value.It must be storing decimal position some where in data dictionary please tell me name of that tables.

Regards
Amol
 
RE: RE: JDE Decimal value

We use world writer to output to file first and then download the resulting
file. WW handles the date and decimal conversions.

S. E. Tuthill
A73 C11 V5R3
 
Re: RE: JDE Decimal value

The Data Dictionary that defines the decimal values is in F9201. ALL JDE programs have sections that do the Data Dictionary retrieval of information for proper presentation so obviously you haven't looked at any of them.
 
Re: RE: JDE Decimal value

Ouch, details please!!!!!!!

If you give us the SQL statement as an example & your ODBC connection
string (without system name, user id, password).
I am sure someone could provide better help. Although I think the question
would probably be better for OneWorld group

FYI:
The data dictionary (DD for short). The table name is F9201, the library
may not be the same as the data library.
Without knowledge of the DD how do you know what field names (columns to
you SQL people) mean.

Another thing you need to know is that JDE uses a 2 character prefix for
all there field names. I am 99% sure that all field names are 6 characters
of less in length. So the DD only has position (3~6) ie IMITM, IMLITM,
IMCRDJ would be ITM, LITM, CRDJ in the DD
 
Back
Top