SQL Commands for creating Binary Links from Legacy Link values?

[Barry G. Sumpter]

Hi All,

I've loaded T1 table with legacy data
T1.ShopNo, T1.ShopName, T1.ShopState, T1.RecID (Created by Valentina)

I've ALSO loaded T2 table with legacy data
T2.ShopNo, T2.ReceiptNo, T2.ReceiptItemNo, T2.RecID (Created by Valentina)

There are currently NO Valentina Key links as yet.

There is only the (logical) relationship via the ShopNo Text/String Value.  
i.e.  "0001", "0002" etc

There are 10,000 Shops(T1) and 100,000,000(T2) Receipts
i.e. too large to update by hand

Is there a methodology to get the Valentina SQL engine, 
i.e. via SQL statements,
to do all the Binary Link work for me?

So far I can index both ShopNo fields and Build a Left out Join Select
statement.

But how do I turn this into a Binary Link via SQL Statements?
i.e. Not just create a physical link using the "CREATE BINARY LINK" command.
     But actually filling the Link records with RecID link values.
     I'm hoping I don't have to write code to loop thru 100,000,000 records.



Thanks,
     Barry G. Sumpter






-----Original Message-----
From: valentina-bounces at lists.macserve.net
[mailto:valentina-bounces at lists.macserve.net] On Behalf Of Barry G. Sumpter
Sent: Friday, 13 July 2007 8:59 PM
To: 'Valentina Developers'
Subject: RE: Left Join on Binary Links

Excellent!

Thanks for taking the time to reply.



-----Original Message-----
From: valentina-bounces at lists.macserve.net
[mailto:valentina-bounces at lists.macserve.net] On Behalf Of Ivan Smahin
Sent: Friday, 13 July 2007 7:23 PM
To: Valentina Developers
Subject: Re: Left Join on Binary Links

Hello Barry,

Friday, July 13, 2007, 11:58:42 AM, you wrote:

BGS> Hi all,

BGS> I've just setup my first many to one Binary Link.

BGS> I'd like to return a left join result set from my many to one Binary
Link.

BGS> Is it possible?

BGS> If so, then how?

Assume you have two tables T1 and T2.
And binary link T1_T2 as M::1.

So
SELECT * FROM T1 LEFT OUTER JOIN T2



-- 
Best regards,
Ivan Smahin 
Senior Software Engineer
Paradigma Software, Inc
Valentina - The Ultra-Fast Database
http://www.valentina-db.com

_______________________________________________
Valentina mailing list
Valentina at lists.macserve.net
http://lists.macserve.net/mailman/listinfo/valentina

_______________________________________________
Valentina mailing list
Valentina at lists.macserve.net
http://lists.macserve.net/mailman/listinfo/valentina