Jump to content
The ibi Community has moved to a new platform: Please Sign In and choose Forgot Password to continue

Hi, I have field with following description on Oracle .mas f...


Nox Lee

Recommended Posts

Hi,

I have field with following description on Oracle .mas file:

FIELDNAME=INV_NUM, ALIAS=INV_NUM, USAGE=P9.2, ACTUAL=P9.2,

 

and my objective is to modify the length of this field to be P11.2 to MS SQL server so that I can have decimal(11.2) in MS SQL server. So the first thing I do is simply modify Oracle .mas file to:

FIELDNAME=INV_NUM, ALIAS=INV_NUM, USAGE=P11.2, ACTUAL=P11.2,

 

but as I done a transformation to MS SQL server via Iway and end up with decimal(9.2) in MS SQL server. But sometime I modify other field within Oracle .mas it work as expected and sometime dont, So how can I can set exact length for Packed Decimal

NOTE: I check the target MS SQL servers .mas file of that field was:

FIELDNAME=INV_NUM, ALIAS=INV_NUM, USAGE=P11.2, ACTUAL=P5,

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
  • Create New...