Re: [U2] Unidata 6.1 Replication

2009-12-17 Thread John Hester
My accuracy may be technically off on the minute details there, but regardless, UV dynamic files are not compatible with OS-level replication. This is from an email sent to me by Stephen O'Neal of IBM U2 Lab Services on 3-18-09: --- At the exact instance that a Dynamic File expands or

Re: [U2] UniData Guide Command

2009-12-17 Thread Wally Terhune
Odd. Guide_ndx uses almost the same logic as BUILD.INDEX - but does not lock the primary file and does not apply the TMP data to the index. What's different about this one file/index? BUILD.INDEX will handle TMP files 2GB. Not sure about guide_ndx. How big did the TMP file get? I recommend

Re: [U2] [UV] UPS + ODBC + BCI

2009-12-17 Thread Brutzman, Bill
I created a UV tech support case leading to a discussion with Bill Collier and Brian Carroll [sp?] yesterday. Of course, John Hester's comments are correct but a few insights are worth mention. Although ODBC is something of an industry standard, ODBC is mainly a Microsoft thing. My problem is

Re: [U2] UniData Guide Command

2009-12-17 Thread Israel, John R.
I believe I have the solution. 1) The field in question, ALT.BILL.TO, is not being used on our system. 2) It is indexed to speed up SELECT statements that came from the vendor (ex: SELECT filename WITH BILL.TO = X OR WITH SHIP.TO = X OR WITH ALT.BILL.TO = X). All three fields must be indexed

Re: [U2] [UV] UPS + ODBC + BCI

2009-12-17 Thread Holt, Jake
Just a personal experience with what you're trying to do: I've actually tried to integrate the Fedex software with our UniVerse database through ODBC a couple times and every time I've scrapped it because it's takes way too long to access the shipment record. I've asked fedex a couple times now

Re: [U2] UniData Guide Command

2009-12-17 Thread Charlie Rubeor
Just a thought, what if you change the NO.NULLS index setting? Israel, John R. johnisr...@daytonsuperior.com 12/17/2009 10:39 AM I believe I have the solution. 1) The field in question, ALT.BILL.TO, is not being used on our system. 2) It is indexed to speed up SELECT statements that came from

Re: [U2] UniData Guide Command

2009-12-17 Thread Wally Terhune
Good work! Sounds like a good 'consumablity' issue to fix for guide_ndx, though seems like this situation would be rare, indeed. Wally Terhune U2 Support Architect Rocket Software 4700 S. Syracuse Street, Suite 400 ..Denver, CO 80237 ..USA Tel: +1.720.475.8055 Email: wterh...@rs.com Web:

Re: [U2] UniData Guide Command

2009-12-17 Thread Israel, John R.
Good point. I did not set these indexes up. We will investigate further. Even so, IMHO, the guide_ndx should not give errors even if our data does appear a bit goofy at first glance. John Israel Senior Programmer/Analyst Dayton Superior Corporation 721 Richard St. Miamisburg, OH  45342

Re: [U2] [UV] UPS + ODBC + BCI

2009-12-17 Thread Brutzman, Bill
We have been able to READ data from UniVerse 10.1 via ODBC+UCI.Editor into FedEx.Ship.Manager. A trick here that I came up with a few weeks ago is that when a pack.slip is cut, it writes the data to both file account PACKSLIPS LIVE PACKSLIPS.X.

[U2] Haydon Bishop is out of the office.

2009-12-17 Thread Haydon Bishop
I will be out of the office starting 17/12/2009 and will not return until 21/12/2009. I will respond to your message when I return. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users

[U2] Any Ideas

2009-12-17 Thread Dave R
I am looking for a command in Windows that will launch a UniVerse Basic Command. Dave R. eFax (815)4259364 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Any Ideas

2009-12-17 Thread Bruce Gauthier
You can certainly launch VOC commands, which can call Basic code...is that what you want? Building your own .cmd file (such as test.cmd - may work as a .bat, too), we shell out to Universe, from DOS, using the UV.exe located in: drive:\IBM\UV\bin. We actually call these .cmd DOS scripts from

Re: [U2] Any Ideas

2009-12-17 Thread Henry Unger
uvsh followed by the (cataloged) program works well for us. e.g.: C:\uvsh ZUSERS Input editing enabled for ALL input, starting in INSERT mode. UniVerse users: 1 (maximum: 2) Other processes: 1 No User | No User | No User | No User 488 NT AUTHO

Re: [U2] Any Ideas [freeware solution and ad]

2009-12-17 Thread 3xk547o02
From: dave.raven I am looking for a command in Windows that will launch a UniVerse Basic Command. MVExec is freeware and does exactly what you want, which is to launch any command in any MV system (Unix, Windows, and across a network) from any Windows system. The results can be returned and