SQL Commands for creating Binary Links from Legacy Link values?

[Barry G. Sumpter]

Hi Bart and any who care to comment,

I did read that page but felt it need more explanation as to it purpose.

As originally mentioned there are only the logical field values that match.

There is NO current Valentina key created.  Other than the RecIDs.

Where the "COPY LINKS FROM src_link_name TO dest_link_name" 

I believe valentina expect src_link_name to be some sort of pre built
Valentina key.




So I looking for the procedure to get these tables into a Many to One Binary
Link.

CREATE BINARY LINK 
     Binary_Link_T1_M_1_T2 
         ON TABLES (T1, T2) AS MANY TO ONE             ???

COPY LINKS FROM T1.ShopNo to Binary_Link_T1_M_1_T2     ???

COPY LINKS FROM T2.ShopNo to Binary_Link_T1_M_1_T2     ???


Or am I jumping to far ahead in the procedure where I would need
To create Valentina forein keys first?


Thanks,
     Barry G. Sumpter





-----Original Message-----
From: valentina-bounces at lists.macserve.net
[mailto:valentina-bounces at lists.macserve.net] On Behalf Of Bart Pietercil
Sent: Saturday, 14 July 2007 8:02 AM
To: Valentina Developers
Subject: Re: SQL Commands for creating Binary Links from Legacy Link values?

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