Login
Enter your username and password to login. If you do not have a username you can register one.

Username: 
Password: 
Remember Me



Forgotten Password?

Online
4 members and 30 guests have been online with in the last 10 minutes.

Hot Topic
No posts have caught fire as of yet.

JD Edwards® World™ Discussions >> JD Edwards® World™

Pages: 1
JDE_Amol
member


Reged: 01/12/06
Last on: 02/23/06
Posts: 14
Loc: India
JDE Decimal value
      #103496 - 02/21/06 12:08 AM

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


Post Extras: Print Post   Remind Me!   Notify Moderator  
G_Smith
member


Reged: 10/16/00
Last on: 03/04/14
Posts: 177
Loc: North Central Texas
RE: JDE Decimal value
new [Re: JDE_Amol]       #103510 - 02/21/06 09:53 AM

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.












--------------------
George Smith,
World A9.2 - V7R1,
Fruit of the Earth
Fort Worth, TX


Post Extras: Print Post   Remind Me!   Notify Moderator  
JDE_Amol
member


Reged: 01/12/06
Last on: 02/23/06
Posts: 14
Loc: India
Re: RE: JDE Decimal value
new [Re: G_Smith]       #103546 - 02/22/06 12:08 AM

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.


Post Extras: Print Post   Remind Me!   Notify Moderator  
John_Dickey
member


Reged: 01/04/01
Last on: 10/29/08
Posts: 416
Loc: St. Louis, Missouri
RE: RE: JDE Decimal value
new [Re: JDE_Amol]       #103561 - 02/22/06 09:31 AM

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


Post Extras: Print Post   Remind Me!   Notify Moderator  
DVerner
member


Reged: 12/19/00
Last on: 07/24/06
Posts: 19
Re: RE: JDE Decimal value
new [Re: JDE_Amol]       #103565 - 02/22/06 10:24 AM


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
.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.





Post Extras: Print Post   Remind Me!   Notify Moderator  
Hal_McGee
member


Reged: 11/09/00
Last on: 01/02/13
Posts: 54
Re: RE: JDE Decimal value
new [Re: JDE_Amol]       #103576 - 02/22/06 12:13 PM

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


Post Extras: Print Post   Remind Me!   Notify Moderator  
JDE_Amol
member


Reged: 01/12/06
Last on: 02/23/06
Posts: 14
Loc: India
Re: RE: JDE Decimal value
new [Re: DVerner]       #103596 - 02/22/06 11:18 PM

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


Post Extras: Print Post   Remind Me!   Notify Moderator  
mnarewec
member


Reged: 03/17/03
Last on: 03/26/07
Posts: 228
Re: RE: JDE Decimal value
new [Re: JDE_Amol]       #103597 - 02/22/06 11:30 PM


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



Cheers!
___________________
Marsh R Narewec
STC Computer Services



JDE_Amol
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





--------------------
------------------
JDE/400 7.3 00009
Papua New Guinea
Opinions or Post I express are not necessary from my employer


Post Extras: Print Post   Remind Me!   Notify Moderator  
JDE_Amol
member


Reged: 01/12/06
Last on: 02/23/06
Posts: 14
Loc: India
Re: RE: JDE Decimal value
new [Re: mnarewec]       #103601 - 02/23/06 02:35 AM

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


Post Extras: Print Post   Remind Me!   Notify Moderator  
setuthill
member


Reged: 10/26/00
Last on: 12/15/10
Posts: 88
RE: RE: JDE Decimal value
new [Re: JDE_Amol]       #103608 - 02/23/06 05:43 AM

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



Post Extras: Print Post   Remind Me!   Notify Moderator  
Pages: 1


Extra information
0 registered and 2 anonymous users are browsing this forum.

Moderator:  ekempter, Christian Audet, jdecnc, Sef 

Print Thread

Forum Permissions
      You cannot start new topics
      You cannot reply to topics
      HTML is disabled
      UBBCode is enabled

Rating:
Thread views: 6089

Rate this thread

Jump to

JDELIST Support | Privacy statement JDELIST.com

*
UBB.threads™ 6.4.1

 .: IIP 5.4.5 by David Lozier ©2003 :. 
Distributed by ThreadsDev.com

The legal restrictions and terms of use applicable to this site are available here.
Use of this site signifies your agreement to the terms of use.
JDELIST is NOT affiliated with JD Edwards® & Company, Oracle or Peoplesoft. Contents of this site are neither
endorsed nor approved by JD Edwards® & Company, Oracle or Peoplesoft.

This page best viewed with Netscape 4 or Microsoft Explorer 4 or above in 800 x 600 resolution.