Hi,

I was trying to create tables from seq. dump using bdbpost.

The command is :

bdbpost6.2 -A -m -n -t "|" -p b50cprod -D /temp -C 901

The /temp has the following file:

ttccom000670.S

But instead of creating the row in company 901 bdbpost6.2 has created in 670.

Any inputs?

Thanks in advance.

I just tested it and it works -


comd = "bdbpost" & bse.release$() & " -c" & comp & " -t""|""" & " -A -D " & path
e = shell(comd, 0)


I just exported the table data from company-52 to 010.

the file name was ppmmmttt052 and it loaded well into the table in company-10.

try to change your command as -

bdbpost6.2 -c 901 -t"|" -A -D /temp

no it ain't working!!!

It is again trying to insert in company 901 and now since there is already a row with company 901 (table tccom000) it is coming out with the error Can not commit transaction (error 520)

Any inputs ???

From the help manual -


520 EBUFUPD This occurs when flushing of buffered updates fails. The flushing can fails due to a lock or to a referential integrity constraint.

© 1998 Baan Development B.V. All rights reserved


you might have to use this option for the bdbpost

-n
Ignore referential integrity constraints.

It works !!!

I guess the -c option must be given immediately after bdbpost6.2 (as opposed to bdbpre6.2 where one MUST give in the last !!!)

Thanks for your help!!