Numeric value scale 2 in Universe DB

Archive of postings to DataStageUsers@Oliver.com. This forum intended only as a reference and cannot be posted to.

Moderators: chulett, rschirm

Locked
admin
Posts: 8720
Joined: Sun Jan 12, 2003 11:26 pm

Numeric value scale 2 in Universe DB

Post by admin »

For to define tables in Universe you have three fields to fill, length,
scale and display.

display=length+2 (decimal seperator and +/- Prefix)

and metasata in datastage have to be the same as metadata of Universetable.

with LIST DICT you can check the metadata in a telnet-session of
the project.

Wolfgang

-----Original Message-----
From: Dommelen van W. (Wim) [mailto:Wim.van.Dommelen@NL.Fortis.com]
Sent: Friday, February 27, 2004 12:40 PM
To: 'DataStage Users Discussion List'
Subject: Numeric value scale 2 in Universe DB


Hi All,

I want to put a numeric value like 847373.72 into a field in a universe
database but when I define the target field as a numeric field with length
15 and scale 2 I get this error: 'MetaData mismatch on COLUMN.SCALE Expected
= 2 Actual = 0'

Anyone knows what I might do wrong?

Thanks!

Wim van Dommelen.



****************************DISCLAIMER***********************************
Deze e-mail is uitsluitend bestemd voor de geadresseerde(n). Verstrekking
aan en gebruik door anderen is niet toegestaan. Fortis sluit iedere
aansprakelijkheid uit die voortvloeit uit electronische verzending.

This e-mail is intended exclusively for the addressee(s), and may not be
passed on to, or made available for use by any person other than the
addressee(s). Fortis rules out any and every liability resulting from
any electronic transmission.
****************************************************************************
***

_______________________________________________
datastage-users mailing list
datastage-users@oliver.com
http://www.oliver.com/mailman/listinfo/datastage-users
_______________________________________________
datastage-users mailing list
datastage-users@oliver.com
http://www.oliver.com/mailman/listinfo/datastage-users
<b>PLEASE READ</b>
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
Locked