on the br wiki maximum page it states:
Longest key field length is 128 adjacent or non-adjacent characters.
Is that accurate? It just seems on the small side.
-john
From: br_forum-bounces@maillist.ads.net [mailto:br_forum-bounces@maillist.ads.net] On Behalf Of Luis I. Gomez
Sent: Tuesday, September 02, 2008 8:25 PM
To: 'Business Rules Forum'
Subject: RE: [BR_forum] attn: Charlie Kent - hurricane
Looks like you need LuisGomez.net solar generation services!
http://www.luisgomez.net/solar
Luis
From: br_forum-bounces@maillist.ads.net [mailto:br_forum-bounces@maillist.ads.net] On Behalf Of Percy J. Comeaux
Sent: Tuesday, September 02, 2008 2:32 PM
To: 'Business Rules Forum'
Subject: RE: [BR_forum] attn: Charlie Kent - hurricane
Thanks for concern, we are ALL ok, except NO electrical and could be LONG!!!!!!!!!!!!
Percy
From: br_forum-bounces@maillist.ads.net [mailto:br_forum-bounces@maillist.ads.net] On Behalf Of Susan Smith
Sent: Monday, September 01, 2008 6:32 PM
To: Business Rules Forum
Subject: Re: [BR_forum] attn: Charlie Kent - hurricane
Percy,
Are you out of danger? Or are you in the path of the hurricane?
-- Susan
Susan Smith wrote:
Charlie,
Are you okay? I'm watching the news and ABC says that the hurricane is heading west toward you (well, they didn't mention you specifically <g>). If you have power, internet access and you happen to check messages, please post a reply so we know you're okay.
-- Susan
Post generated using Mail2Forum (http://www.mail2forum.com)
[BR_forum] KLN
Moderators: Susan Smith, admin, Gabriel
[BR_forum] KLN
This is indeed true.
Do keep in mind that an index record looks something like this
MASTER_RECORD BH 4
INDEX_KEY C ### (From 1-128).
These index records are stored on “Leaves” on the “B-Tree”.
The actual data is stored in the index file. If the key was longer than 128 characters, they wouldn’t fit on the Tree, and it might very well be slower to index the file than to just randomly hunt & peck.
Luis I. Gomez
GomezL@CollectionSoftware.com (GomezL@CollectionSoftware.com)
1-800-435-7257
Commercial Legal Software, Inc.
http://www.CollectionSoftware.com
From: br_forum-bounces@maillist.ads.net [mailto:br_forum-bounces@maillist.ads.net] On Behalf Of John Bowman
Sent: Friday, September 05, 2008 10:45 AM
To: 'Business Rules Forum'
Subject: [BR_forum] KLN
on the br wiki maximum page it states:
Longest key field length is 128 adjacent or non-adjacent characters.
Is that accurate? It just seems on the small side.
-john
From: br_forum-bounces@maillist.ads.net [mailto:br_forum-bounces@maillist.ads.net] On Behalf Of Luis I. Gomez
Sent: Tuesday, September 02, 2008 8:25 PM
To: 'Business Rules Forum'
Subject: RE: [BR_forum] attn: Charlie Kent - hurricane
Looks like you need LuisGomez.net solar generation services!
http://www.luisgomez.net/solar
Luis
From: br_forum-bounces@maillist.ads.net [mailto:br_forum-bounces@maillist.ads.net] On Behalf Of Percy J. Comeaux
Sent: Tuesday, September 02, 2008 2:32 PM
To: 'Business Rules Forum'
Subject: RE: [BR_forum] attn: Charlie Kent - hurricane
Thanks for concern, we are ALL ok, except NO electrical and could be LONG!!!!!!!!!!!!
Percy
From: br_forum-bounces@maillist.ads.net [mailto:br_forum-bounces@maillist.ads.net] On Behalf Of Susan Smith
Sent: Monday, September 01, 2008 6:32 PM
To: Business Rules Forum
Subject: Re: [BR_forum] attn: Charlie Kent - hurricane
Percy,
Are you out of danger? Or are you in the path of the hurricane?
-- Susan
Susan Smith wrote:
Charlie,
Are you okay? I'm watching the news and ABC says that the hurricane is heading west toward you (well, they didn't mention you specifically <g>). If you have power, internet access and you happen to check messages, please post a reply so we know you're okay.
-- Susan
Post generated using Mail2Forum (http://www.mail2forum.com)
Do keep in mind that an index record looks something like this
MASTER_RECORD BH 4
INDEX_KEY C ### (From 1-128).
These index records are stored on “Leaves” on the “B-Tree”.
The actual data is stored in the index file. If the key was longer than 128 characters, they wouldn’t fit on the Tree, and it might very well be slower to index the file than to just randomly hunt & peck.
Luis I. Gomez
GomezL@CollectionSoftware.com (GomezL@CollectionSoftware.com)
1-800-435-7257
Commercial Legal Software, Inc.
http://www.CollectionSoftware.com
From: br_forum-bounces@maillist.ads.net [mailto:br_forum-bounces@maillist.ads.net] On Behalf Of John Bowman
Sent: Friday, September 05, 2008 10:45 AM
To: 'Business Rules Forum'
Subject: [BR_forum] KLN
on the br wiki maximum page it states:
Longest key field length is 128 adjacent or non-adjacent characters.
Is that accurate? It just seems on the small side.
-john
From: br_forum-bounces@maillist.ads.net [mailto:br_forum-bounces@maillist.ads.net] On Behalf Of Luis I. Gomez
Sent: Tuesday, September 02, 2008 8:25 PM
To: 'Business Rules Forum'
Subject: RE: [BR_forum] attn: Charlie Kent - hurricane
Looks like you need LuisGomez.net solar generation services!
http://www.luisgomez.net/solar
Luis
From: br_forum-bounces@maillist.ads.net [mailto:br_forum-bounces@maillist.ads.net] On Behalf Of Percy J. Comeaux
Sent: Tuesday, September 02, 2008 2:32 PM
To: 'Business Rules Forum'
Subject: RE: [BR_forum] attn: Charlie Kent - hurricane
Thanks for concern, we are ALL ok, except NO electrical and could be LONG!!!!!!!!!!!!
Percy
From: br_forum-bounces@maillist.ads.net [mailto:br_forum-bounces@maillist.ads.net] On Behalf Of Susan Smith
Sent: Monday, September 01, 2008 6:32 PM
To: Business Rules Forum
Subject: Re: [BR_forum] attn: Charlie Kent - hurricane
Percy,
Are you out of danger? Or are you in the path of the hurricane?
-- Susan
Susan Smith wrote:
Charlie,
Are you okay? I'm watching the news and ABC says that the hurricane is heading west toward you (well, they didn't mention you specifically <g>). If you have power, internet access and you happen to check messages, please post a reply so we know you're okay.
-- Susan
Post generated using Mail2Forum (http://www.mail2forum.com)
[BR_forum] KLN
John,
I see a trend for us towards shorter KLN's within our application design. This is due to adopting a lot of the data normalization principles. In essence they lead to having file relationships using an Auto ID number as a primary key instead of longer descriptive fields as we used at one time.
--Richard Forrester
John Bowman wrote:
I see a trend for us towards shorter KLN's within our application design. This is due to adopting a lot of the data normalization principles. In essence they lead to having file relationships using an Auto ID number as a primary key instead of longer descriptive fields as we used at one time.
--Richard Forrester
John Bowman wrote:
Post generated using Mail2Forum (http://www.mail2forum.com)on the br wiki maximum page it states:
Longest key field length is 128 adjacent or non-adjacent characters.
Is that accurate? It just seems on the small side.
-john
From: br_forum-bounces@maillist.ads.net (br_forum-bounces@maillist.ads.net) [mailto:br_forum-bounces@maillist.ads.net (br_forum-bounces@maillist.ads.net)] On Behalf Of Luis I. Gomez
Sent: Tuesday, September 02, 2008 8:25 PM
To: 'Business Rules Forum'
Subject: RE: [BR_forum] attn: Charlie Kent - hurricane
Looks like you need LuisGomez.net solar generation services!
http://www.luisgomez.net/solar
Luis
From: br_forum-bounces@maillist.ads.net (br_forum-bounces@maillist.ads.net) [mailto:br_forum-bounces@maillist.ads.net (br_forum-bounces@maillist.ads.net)] On Behalf Of Percy J. Comeaux
Sent: Tuesday, September 02, 2008 2:32 PM
To: 'Business Rules Forum'
Subject: RE: [BR_forum] attn: Charlie Kent - hurricane
Thanks for concern, we are ALL ok, except NO electrical and could be LONG!!!!!!!!!!!!
Percy
From: br_forum-bounces@maillist.ads.net (br_forum-bounces@maillist.ads.net) [mailto:br_forum-bounces@maillist.ads.net (br_forum-bounces@maillist.ads.net)] On Behalf Of Susan Smith
Sent: Monday, September 01, 2008 6:32 PM
To: Business Rules Forum
Subject: Re: [BR_forum] attn: Charlie Kent - hurricane
Percy,
Are you out of danger? Or are you in the path of the hurricane?
-- Susan
Susan Smith wrote:
Charlie,
Are you okay? I'm watching the news and ABC says that the hurricane is heading west toward you (well, they didn't mention you specifically <g>). If you have power, internet access and you happen to check messages, please post a reply so we know you're okay.
-- Susan
_______________________________________________
BR_forum mailing list
BR_forum@maillist.ads.net (BR_forum@maillist.ads.net)
http://maillist.ads.net/mailman/listinfo/br_forum
[BR_forum] KLN
okay, thanks guys!
-john
From: br_forum-bounces@maillist.ads.net [mailto:br_forum-bounces@maillist.ads.net] On Behalf Of SysCorp Tech Support
Sent: Friday, September 05, 2008 11:32 AM
To: Business Rules Forum
Subject: Re: [BR_forum] KLN
John,
I see a trend for us towards shorter KLN's within our application design. This is due to adopting a lot of the data normalization principles. In essence they lead to having file relationships using an Auto ID number as a primary key instead of longer descriptive fields as we used at one time.
--Richard Forrester
John Bowman wrote:
-john
From: br_forum-bounces@maillist.ads.net [mailto:br_forum-bounces@maillist.ads.net] On Behalf Of SysCorp Tech Support
Sent: Friday, September 05, 2008 11:32 AM
To: Business Rules Forum
Subject: Re: [BR_forum] KLN
John,
I see a trend for us towards shorter KLN's within our application design. This is due to adopting a lot of the data normalization principles. In essence they lead to having file relationships using an Auto ID number as a primary key instead of longer descriptive fields as we used at one time.
--Richard Forrester
John Bowman wrote:
Post generated using Mail2Forum (http://www.mail2forum.com)on the br wiki maximum page it states:
Longest key field length is 128 adjacent or non-adjacent characters.
Is that accurate? It just seems on the small side.
-john
From: br_forum-bounces@maillist.ads.net (br_forum-bounces@maillist.ads.net) [mailto:br_forum-bounces@maillist.ads.net (br_forum-bounces@maillist.ads.net)] On Behalf Of Luis I. Gomez
Sent: Tuesday, September 02, 2008 8:25 PM
To: 'Business Rules Forum'
Subject: RE: [BR_forum] attn: Charlie Kent - hurricane
Looks like you need LuisGomez.net solar generation services!
http://www.luisgomez.net/solar
Luis
From: br_forum-bounces@maillist.ads.net (br_forum-bounces@maillist.ads.net) [mailto:br_forum-bounces@maillist.ads.net (br_forum-bounces@maillist.ads.net)] On Behalf Of Percy J. Comeaux
Sent: Tuesday, September 02, 2008 2:32 PM
To: 'Business Rules Forum'
Subject: RE: [BR_forum] attn: Charlie Kent - hurricane
Thanks for concern, we are ALL ok, except NO electrical and could be LONG!!!!!!!!!!!!
Percy
From: br_forum-bounces@maillist.ads.net (br_forum-bounces@maillist.ads.net) [mailto:br_forum-bounces@maillist.ads.net (br_forum-bounces@maillist.ads.net)] On Behalf Of Susan Smith
Sent: Monday, September 01, 2008 6:32 PM
To: Business Rules Forum
Subject: Re: [BR_forum] attn: Charlie Kent - hurricane
Percy,
Are you out of danger? Or are you in the path of the hurricane?
-- Susan
Susan Smith wrote:
Charlie,
Are you okay? I'm watching the news and ABC says that the hurricane is heading west toward you (well, they didn't mention you specifically <g>). If you have power, internet access and you happen to check messages, please post a reply so we know you're okay.
-- Susan
_______________________________________________
BR_forum mailing list
BR_forum@maillist.ads.net (BR_forum@maillist.ads.net)
http://maillist.ads.net/mailman/listinfo/br_forum
[BR_forum] KLN
You might be interested in the Sort Command:
Technical Considerations
1.) The following field lengths are required for the D, S & L format specs: D is 8; S is 4; & L is 9.
2.) The total sort key length may not exceed 32,767 bytes.
3.) Up to ten fields may be specified with the MASK specification.
4.) MASK must always be the last specification in a sort group.
5.) The existence of MASK flags the end of the current sort group. Business Rules will automatically treat any specifications that follow as part of the next sort group.
Luis I. Gomez
GomezL@CollectionSoftware.com (GomezL@CollectionSoftware.com)
1-800-435-7257
Commercial Legal Software, Inc.
http://www.CollectionSoftware.com
From: br_forum-bounces@maillist.ads.net [mailto:br_forum-bounces@maillist.ads.net] On Behalf Of Luis I. Gomez
Sent: Friday, September 05, 2008 11:13 AM
To: Business Rules Forum
Subject: RE: [BR_forum] KLN
This is indeed true.
Do keep in mind that an index record looks something like this
MASTER_RECORD BH 4
INDEX_KEY C ### (From 1-128).
These index records are stored on “Leaves” on the “B-Tree”.
The actual data is stored in the index file. If the key was longer than 128 characters, they wouldn’t fit on the Tree, and it might very well be slower to index the file than to just randomly hunt & peck.
Luis I. Gomez
GomezL@CollectionSoftware.com (GomezL@CollectionSoftware.com)
1-800-435-7257
Commercial Legal Software, Inc.
http://www.CollectionSoftware.com
From: br_forum-bounces@maillist.ads.net [mailto:br_forum-bounces@maillist.ads.net] On Behalf Of John Bowman
Sent: Friday, September 05, 2008 10:45 AM
To: 'Business Rules Forum'
Subject: [BR_forum] KLN
on the br wiki maximum page it states:
Longest key field length is 128 adjacent or non-adjacent characters.
Is that accurate? It just seems on the small side.
-john
From: br_forum-bounces@maillist.ads.net [mailto:br_forum-bounces@maillist.ads.net] On Behalf Of Luis I. Gomez
Sent: Tuesday, September 02, 2008 8:25 PM
To: 'Business Rules Forum'
Subject: RE: [BR_forum] attn: Charlie Kent - hurricane
Looks like you need LuisGomez.net solar generation services!
http://www.luisgomez.net/solar
Luis
From: br_forum-bounces@maillist.ads.net [mailto:br_forum-bounces@maillist.ads.net] On Behalf Of Percy J. Comeaux
Sent: Tuesday, September 02, 2008 2:32 PM
To: 'Business Rules Forum'
Subject: RE: [BR_forum] attn: Charlie Kent - hurricane
Thanks for concern, we are ALL ok, except NO electrical and could be LONG!!!!!!!!!!!!
Percy
From: br_forum-bounces@maillist.ads.net [mailto:br_forum-bounces@maillist.ads.net] On Behalf Of Susan Smith
Sent: Monday, September 01, 2008 6:32 PM
To: Business Rules Forum
Subject: Re: [BR_forum] attn: Charlie Kent - hurricane
Percy,
Are you out of danger? Or are you in the path of the hurricane?
-- Susan
Susan Smith wrote:
Charlie,
Are you okay? I'm watching the news and ABC says that the hurricane is heading west toward you (well, they didn't mention you specifically <g>). If you have power, internet access and you happen to check messages, please post a reply so we know you're okay.
-- Susan
Post generated using Mail2Forum (http://www.mail2forum.com)
Technical Considerations
1.) The following field lengths are required for the D, S & L format specs: D is 8; S is 4; & L is 9.
2.) The total sort key length may not exceed 32,767 bytes.
3.) Up to ten fields may be specified with the MASK specification.
4.) MASK must always be the last specification in a sort group.
5.) The existence of MASK flags the end of the current sort group. Business Rules will automatically treat any specifications that follow as part of the next sort group.
Luis I. Gomez
GomezL@CollectionSoftware.com (GomezL@CollectionSoftware.com)
1-800-435-7257
Commercial Legal Software, Inc.
http://www.CollectionSoftware.com
From: br_forum-bounces@maillist.ads.net [mailto:br_forum-bounces@maillist.ads.net] On Behalf Of Luis I. Gomez
Sent: Friday, September 05, 2008 11:13 AM
To: Business Rules Forum
Subject: RE: [BR_forum] KLN
This is indeed true.
Do keep in mind that an index record looks something like this
MASTER_RECORD BH 4
INDEX_KEY C ### (From 1-128).
These index records are stored on “Leaves” on the “B-Tree”.
The actual data is stored in the index file. If the key was longer than 128 characters, they wouldn’t fit on the Tree, and it might very well be slower to index the file than to just randomly hunt & peck.
Luis I. Gomez
GomezL@CollectionSoftware.com (GomezL@CollectionSoftware.com)
1-800-435-7257
Commercial Legal Software, Inc.
http://www.CollectionSoftware.com
From: br_forum-bounces@maillist.ads.net [mailto:br_forum-bounces@maillist.ads.net] On Behalf Of John Bowman
Sent: Friday, September 05, 2008 10:45 AM
To: 'Business Rules Forum'
Subject: [BR_forum] KLN
on the br wiki maximum page it states:
Longest key field length is 128 adjacent or non-adjacent characters.
Is that accurate? It just seems on the small side.
-john
From: br_forum-bounces@maillist.ads.net [mailto:br_forum-bounces@maillist.ads.net] On Behalf Of Luis I. Gomez
Sent: Tuesday, September 02, 2008 8:25 PM
To: 'Business Rules Forum'
Subject: RE: [BR_forum] attn: Charlie Kent - hurricane
Looks like you need LuisGomez.net solar generation services!
http://www.luisgomez.net/solar
Luis
From: br_forum-bounces@maillist.ads.net [mailto:br_forum-bounces@maillist.ads.net] On Behalf Of Percy J. Comeaux
Sent: Tuesday, September 02, 2008 2:32 PM
To: 'Business Rules Forum'
Subject: RE: [BR_forum] attn: Charlie Kent - hurricane
Thanks for concern, we are ALL ok, except NO electrical and could be LONG!!!!!!!!!!!!
Percy
From: br_forum-bounces@maillist.ads.net [mailto:br_forum-bounces@maillist.ads.net] On Behalf Of Susan Smith
Sent: Monday, September 01, 2008 6:32 PM
To: Business Rules Forum
Subject: Re: [BR_forum] attn: Charlie Kent - hurricane
Percy,
Are you out of danger? Or are you in the path of the hurricane?
-- Susan
Susan Smith wrote:
Charlie,
Are you okay? I'm watching the news and ABC says that the hurricane is heading west toward you (well, they didn't mention you specifically <g>). If you have power, internet access and you happen to check messages, please post a reply so we know you're okay.
-- Susan
Post generated using Mail2Forum (http://www.mail2forum.com)