I'm trying to use the proutil bulkload option to import the data, but in the .d files a comma is used, the new databse uses a dot. so after the import all decimals are suddenly multiplied by 100 (since there were 2 decimal numbers)

the file says 9,55

after import in the new DB it says 955

or is this possible in the proutil command to specify this numdec parameter?

Message was edited by:

Steven Post

Edit: Sorry for misunderstanding, I got it right now, thanks to your hint

Message was edited by:

Steven Post

You have posted to a forum that requires a moderator to approve posts before they are publicly available.

thanks for the advice, both cpinternal and cpstream are the same in both installations (so are cpcoll and cpbase), so I don't expect problems there.

I already had a similar issue with the dates being in different formats, mdy instead of dmy, or vice versa. But I had no clue on how to fix the numdec.

Thanks for that.

numsec and numdec are, as far as I know, new features introduced in version 9 or 10 (not sure), so those aren't in the old startup.pf file.

Anyhow, I solved it by using the -numdec 44 parameter in conjunction with proutil -C bulkload, thanks to your advice.

Does it make a difference if I use both the numdec and numsec parameters there (as proutil parameters in proenv) or only numdec, given that all decimals are under 1000? or should I use them both anyhow?

You don't happen to have an answer on my other thread?

No seriously, thanks for saving me from a huge headache

You have posted to a forum that requires a moderator to approve posts before they are publicly available.