How can Insert records in database directly from sql .

How to take care of hash columns.

Have any one already done this.

Please share the sql query for taking care of hash column inserts.



Thanks

Surinder

Hi,
Although i am very new to baaN......but still as much as i know u cannot insert records through sql directly ...u will have to write maintain session for that.....

if u want to directly write records using your database then for informix u can use dbaccess ...........

correct me if i am wrong.

it is poosible see the thread below but don't recommend it.
other options

1.use a custom session to read in your data from a text file and then update the table.
2. exchange, you can do some pretty complicated solutions using it with conditional scripts.
3.AFS
4.BCK/openworld



http://www.baanboard.com/baanboard/showthread.php?s=&threadid=1525