SQL Commands for creating Binary Links from Legacy Link values?

[Bart Pietercil]

Hi Barry,

I think you are looking for this
<http://www.valentina-db.com/dokuwiki/doku.php? 
id=paradigma:public:en:documentation:vkernel:vlink:fk_to_binarylink>

hth

Bart


On 13-jul-07, at 21:02, Barry G. Sumpter wrote:

> 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
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina