[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference rocks::dec_edi

Title:DEC/EDI
Notice:DEC/EDI V2.1 - see note 2002
Moderator:METSYS::BABER
Created:Wed Jun 06 1990
Last Modified:Fri Jun 06 1997
Last Successful Update:Fri Jun 06 1997
Number of topics:3150
Total number of notes:13466

3115.0. "Numeric Field" by NNTPD::"[email protected]" (nicolas) Tue Apr 29 1997 17:36

hi

Customer with DEC/EDI 3.1A, Oracle 7 DB

Get's different EDIFACT Document from differen
Partners.

In the quantity and Price DE we can have decimal separators or not.

I want to produce a file (application File) with the file format for these 
two value = 15(3), these mean a 15 digit numeric field
where the last tree digit are decimal place.

I tried in differen ways:

	UNSIGNED NUMERIC, SIZE 15 SCALE 3 
	For an EDIFACT DE = 1000 these give --> 000000000000001

	UNSIGNED NUMERIC, SIZE 12 SCALE 3 
	For anEDIFACT DE = 1000 these give  --> 000000000001

	UNSIGNED NUMERIC SIZE 15
	For an EDIFACT DE = 1000 these give --> 000000000001000 

	For an EDIFACT DE = 5.500 these give --> 000000000000006 

What I would like is:

	DE = 1000 ---->    000000001000000
	DE = 5.500 ---->   000000000005500

So how can I do it ???

[Posted by WWW Notes gateway]
T.RTitleUserPersonal
Name		DateLines
3115.1EDIBUS::newdial_p13.reo.dec.com::JOHNSONRichard Johnson , http://samedi.reo.dec.comTue Apr 29 1997 18:079
The field data type definition you need is:

        UNSIGNED NUMERIC, SIZE 15 SCALE -3 

The -3 will move the decimal point three positions 
to the right

Richard
EDI Engineering
3115.2NNTPD::"[email protected]"Wed Apr 30 1997 14:178
Richard

many thanks for your quick replay, I will tried.

Is these somewere described on a manual ?? I couldn't find it in EDI-BOOK.

Nicolas
[Posted by WWW Notes gateway]