Groups | Search | Server Info | Login | Register

Groups > comp.databases.pick > #2354

Re: best way to link Universe and D3

Show all headers | View raw

On Monday, April 20, 2015 at 1:17:30 PM UTC-7, kpo...@gmail.com wrote:
> On Monday, 20 April 2015 13:17:08 UTC-4, folance  wrote:
> > Hi all, 
> > 
> > I work for a company that uses 2 separate databases for 2 separate parts of that company. One side call it Company A and the other Company B. Company A uses Pick/D3 and Company B uses Universe, both running on Linux. 
> > 
> > When Company A transfers accounts into Company B, Company A needs a flag on the accounts that are in Company B. When Company B closed the account, then Company A also needs to know the status 
> > 
> > Currently I have to FTD data from Company A and Company B into a MS-SQL database via txt files. In Universe I select out the accounts that have a balance gt 20.00. If the accounts closes, the account will not be included in this selection. I run quarries with accounts that have the same contract number and Fname and Lname with the same first 4 digits of their account number.  
> > 
> > I then copy the accounts numbers (only) from the MS-SQL side and paste into a list on the Company A's side. I then Copy them into a file to remove the duplicates and do a P-restore command in Pick to create the flag. If the account is closed in Company B, then the account will no longer have a flag in Company A.
> > 
> > I hope I explained it, but needles to say I need something better then this. any thoughts on how I can have better more efficient way to accomplish this? 
> > 
> > thanks
> > 
> > -Joe
> 
> I've attempted to forward your message to the google group "Pick and MultiValue Databases", as I believe your question will receive more views/answers there. 
> 
> https://groups.google.com/forum/#!forum/mvdbms
> 
> If it doesn't get show-up there, you should repost it in that group yourself.
> 
> 
> --
> Kevin Powick

Thanks Kevin I will re-post. 

Back to comp.databases.pick | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

best way to link Universe and D3 folance <tinasguy@gmail.com> - 2015-04-20 10:17 -0700
  Re: best way to link Universe and D3 kpowick@gmail.com - 2015-04-20 13:17 -0700
    Re: best way to link Universe and D3 folance <tinasguy@gmail.com> - 2015-04-20 14:43 -0700
  Re: best way to link Universe and D3 wjhonson <wjhonson@aol.com> - 2015-04-21 08:38 -0700

csiph-web