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

[Nox Lee]

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,

[Sarah Buccellato]

Nox, I recommend opening a support case.