Skip to Content
avatar image
Former Member

DataSources on O db: Packed numbers should have an odd number of digits:

Good day again.

Thanks for all your assistance so far, but here is another question.

I am creating a DB Connect Datasource in the Workbench. My problem lies with a data type field DEC with field length = 10 and decimal = 2. When I check the datasource, the following message is displayed:

Field RETAIL_PRICE (Position 4) has 10 characters. This could cause conversion problems. Packed numbers should have an odd number of digits

The proposal is to * increase the lenth with 1 digit*. The db programmer said that he do not want to change the digits to 11.

Is there anything that I can do in BW to rectify this? (Accepting the 10 digit?)

Thanks again

Cj

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Oct 16, 2008 at 06:54 PM

    To be honest - I'd tell the db programmer to change the field! "I don't want to" doesn't cut it. What's his justification? What will be the impact on other applications if he does?

    Chances are, it'll be fine, but if it isn't, then he's going to have to make the change.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 17, 2008 at 06:23 AM

    Thanks for the reply, my feeling exactly!

    Have a good weekend

    Cj

    Add comment
    10|10000 characters needed characters exceeded