Hi all,

We are in b40c4/in3/nt/sql 7.0

My query is :

What about the "hash" fields in baan tables?

These fields are found in tdpur302, tiitm001, tdinv700, tdinv100 etc.,

thro GTM these are not visible
Thro enterprise manager and design tables, these show values

Can anyone pls. help

sriram

Dear Sriram,

The hash fields are present in every BaanERP tables under SQL Server. They contain the content of the index fields in binary. If there are multiple indices for the table, then there are one hash field for each index

Rgds,
Paul

thanx paul

How can I decipher the content of this field? i.e. If the field is containing a value 25166825, what does this mean? On what logic the value in this field is built up?

Basically, we are in the process of developing a custom solution as a third party tool. While storing the transactions in tdinv100, we need this data.

And also how to find out the no. of indices for each table in SQL Server?



sriram

If you look at the hash colums and compare them with the index, then you can tell how it is transformed: numbers are stored as number, string values are stored with the numerical representation of the character value (given the ASCII character set).

The hash colums are needed for databasedrivers that run in level 1 mode. The database driver computes and stores the hash column.

If you store data in sql to be used within Baan... I am not sure, but I think it is better to install the latest portingset (to be released this week) and run the database in level 2 mode... in that mode no hash columns are needed.

Dear Sriram,

Say we're talking about the index 1 of customer table tccom010, and that index only contains one field; customer code. In this case, for a customer with code KAO1, the hash1 field of this row will contain 0x20204B414F31 for " KAO1"

The table definition session (ttadv4120m000 in BaanIV or ttadv4520m000 in BaanERP) will state how many indices each table uses

Rgds,
Paul

Thanks Paul,

I will try to do my best to understand this sequence in each table. Basically I am interested in tdinv100, tdinv700 etc.,

If I need any more help, I will come back to u.

Originally posted by OmeLuuk
[
If you store data in sql to be used within Baan... I am not sure, but I think it is better to install the latest portingset (to be released this week) and run the database in level 2 mode... in that mode no hash columns are needed. [/B]

Baan are informing me that Level 2 driver for Baan IV is not being released, despite previous documentation that suggested it would. I (and some other users have raised this as a serious issue and are waiting for a reply)

OmeLuuk - Do you know any different?

Ome Luuk,

i agree with EdHubbard.
When you ask baan for a level 2 driver for sql2000 and baan cIV they are so kind to call you and mail you saying that there will never be a level 2 driver for baan iv c4.

There is for baan erp and it is the standard.
Are we feeling there a little pressure to move to baan erp ?

I launched on this board a call to put a call on the support off baan for a level 2 driver

Perhaps when there are 20 customers asking for it they will do something

For sriram

I tried a work around creating vieuws on the baantables and creating indexes on that vieuws.
But no luck when inserting deleting updating a record with baan the indexen in sql2000 are not updated.
so you must always drop and recreate indexes.
not very good indeed.

Alas!EdHubbard: OmeLuuk - Do you know any different?Verified it, apperently I missed also the point. There seems to be a solution 131609 that describes this.sweetie: When you ask baan for a level 2 driver for sql2000 and baan cIV they are so kind to call you and mail you saying that there [i]will never be[i] a level 2 driver for baan iv c4.This is the statement from that solution.There is for baan erp and it is the standard.
Are we feeling there a little pressure to move to baan erp ?

I launched on this board a call to put a call on the support off baan for a level 2 driver

Perhaps when there are 20 customers asking for it they will do somethingI was told that the defects are going to be closed with reference to the above solution. There is no feedback mechanism from PEG to the department that decides on this matter...

I suggest you open a thread on the level 2 SQL driver in the Enhancements forum. This forum is monitored by some good Baan folks, though there is no guarantee that your wishes will come true of course.

As suggested, I have added a new thread into the "Enhancements" section.

Crossing my fingers and hoping that somebody from Baan will pick it up.


Thanks for the suggestion.

Guys, I'd have to correct myself a little bit here. The explanation I gave above seems to work fine for BaanERP running level 1 database driver over SQL Server. I just bumped into one running on Informix, and indeed the hash algorithm becomes very complicated. Please refer to the SQL Server with Level 1 indexing also for more information

Rgds,
Paul

See my reply in this thread for info on how to calculate hash column values: http://www.baanboard.com/baanboard/showthread.php?p=101900#post101900