[U2] Unidata Index question
I have two question about how indicies affect queries: 1) If I have an index built for a given field FOO, and perform a query with like such as FOO LIKE 'ABC...' does it benefit from the index? Or is it only queries with equality conditions that benefit from the index (eg: FOO EQ 'ABC' )? 2) If I have an index built with Empties=NO and then query with that indexed field =, how does it handle the query? Does it not use the index at all? TIA, Jeff -- Jeffrey Butera, PhD Associate Director for Application and Web Services Information Technology Hampshire College 413-559-5556 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unidata Index question
Hi Jeff, 1) If I have an index built for a given field FOO, and perform a query with like such as FOO LIKE 'ABC...' does it benefit from the index? Or is it only queries with equality conditions that benefit from the index (eg: FOO EQ 'ABC' )? An index can be used for a LIKE comparison with a literal element at the start but not if the ... is at the start. 2) If I have an index built with Empties=NO and then query with that indexed field =, how does it handle the query? Does it not use the index at all? Because the condition would be met by a null field and you have disabled indexing of null items, the index will not be used. Beware of queries like WITH FLD 4 when using NO.NULLS as again the condition is met by a null item, preventing use of an index, whereas WITH FLD 4 could use an index. Martin Phillips Ladybridge Systems Ltd 17b Coldstream Lane, Hardingstone, Northampton NN4 6DB, England +44 (0)1604-709200 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unidata Index question
For UniData - FOO LIKE 'ABC'... I think so - because the first part is literal. FOO LIKE ABC... I don't think so - because you aren't explicitly saying the first part is a literal. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeffrey Butera Sent: Thursday, May 23, 2013 6:50 AM To: U2 Users List Subject: [U2] Unidata Index question I have two question about how indicies affect queries: 1) If I have an index built for a given field FOO, and perform a query with like such as FOO LIKE 'ABC...' does it benefit from the index? Or is it only queries with equality conditions that benefit from the index (eg: FOO EQ 'ABC' )? 2) If I have an index built with Empties=NO and then query with that indexed field =, how does it handle the query? Does it not use the index at all? TIA, Jeff -- Jeffrey Butera, PhD Associate Director for Application and Web Services Information Technology Hampshire College 413-559-5556 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Dave Davis Team Lead, RD P: 614-875-4910 x108 F: 614-875-4088 E: dda...@harriscomputer.com [http://www.harriscomputer.com/images/signatures/HarrisSchools.jpg] [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif]http://www.harriscomputer.com/ 6110 Enterprise Parkway Grove City, OH 43123 www.harris-schoolsolutions.comhttp://www.harris-schoolsolutions.com This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Unidata BCI error
Unidata 7.2 on Redhat 6.2 64. I got our Sysadmin to install ODBC on our UD server today so I can try to use BCI to access data on SQL Server 2008 R2 directly. After some experimenting we finally got the ODBC part going and can connect to the right database from the command line. He relinked the shared library as stated in the documentation and CONNECT now seems to establish a connection to the server. But then it falls over with this message: In /usr/ud72/sys/CTLG/c/CONNECT at line 441 insufficient memory, requested size = -2074363. and drops back to a Linux prompt. The number is always different but always a negative one. Any clues what may be wrong? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unidata BCI error
I've checked our system and have no previous reports of this error. Since our Linux versions are 32-bit and it seems you are running 64-bit Linux, combined with the negative number, I would hazard a guess this is some 32-bit on a 64-bit machine related problem. Regards, Dan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann Sent: Thursday, May 23, 2013 9:56 AM To: U2 Users List Subject: [U2] Unidata BCI error Unidata 7.2 on Redhat 6.2 64. I got our Sysadmin to install ODBC on our UD server today so I can try to use BCI to access data on SQL Server 2008 R2 directly. After some experimenting we finally got the ODBC part going and can connect to the right database from the command line. He relinked the shared library as stated in the documentation and CONNECT now seems to establish a connection to the server. But then it falls over with this message: In /usr/ud72/sys/CTLG/c/CONNECT at line 441 insufficient memory, requested size = -2074363. and drops back to a Linux prompt. The number is always different but always a negative one. Any clues what may be wrong? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] How to create WCF oData Service using Visual Studio 2012, Code First Entity Model and U2 Toolkit for .NET?
That's some great info but I think the Stack Overflow people would object to their site being used as a blog/wiki by a commercial entity. I recommend putting nice articles like that on CodeProject.com, the company website, or PickWiki.com. T From: rkumar http://stackoverflow.com/questions/16642223/how-to-create-wcf- odata-service-using-visual-studio-2012-code-first-entity-mode ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] U2 demos and sample code now on Github
For anyone near the Denver area, I'll be doing a hands on demo/tutorial at the upcoming CMUG meeting - June 11, 5:30pm for a 6pm start at Rocket's Denver office. http://www.eventbrite.com/event/6793013085 Cheers, Dan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Wednesday, May 22, 2013 9:45 AM To: wjhon...@aol.com; u2-users@listserver.u2ug.org Subject: Re: [U2] U2 demos and sample code now on Github -Original Message- From: Daniel McGrath dmcgr...@rocketsoftware.com To: Wjhonson wjhon...@aol.com Sent: Tue, May 21, 2013 8:58 pm Subject: RE: [U2] U2 demos and sample code now on Github Hi, You cannot directly edit our repositories, but this is a 'Fork' button that will create a copy of it in Github under your account name. You can then edit anything there. You can have the system submit patches back by doing a 'Pull Request', which will automatically create an issue on our repositories issue page, along with a request that contains all your changes to us. From this we can review it and choose to accept it back into the Rocket repository. If you are logged into your Github account, each file you view will have an edit button. This allows you to edit the file directly in the browser. If you click this edit button on our repository, it will automatically do the fork for you and save your edits in your forked copy. This is the sort of information I'm planning to explain in the webinar. It is much easier to convey by showing it in action. Regards, Dan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] U2 demos and sample code now on Github
Dan: Easy for me to say... Perhaps a video stream is possible from there... --Bill On Thu, May 23, 2013 at 2:25 PM, Daniel McGrath dmcgr...@rocketsoftware.com wrote: For anyone near the Denver area, I'll be doing a hands on demo/tutorial at the upcoming CMUG meeting - June 11, 5:30pm for a 6pm start at Rocket's Denver office. http://www.eventbrite.com/event/6793013085 Cheers, Dan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Wednesday, May 22, 2013 9:45 AM To: wjhon...@aol.com; u2-users@listserver.u2ug.org Subject: Re: [U2] U2 demos and sample code now on Github -Original Message- From: Daniel McGrath dmcgr...@rocketsoftware.com To: Wjhonson wjhon...@aol.com Sent: Tue, May 21, 2013 8:58 pm Subject: RE: [U2] U2 demos and sample code now on Github Hi, You cannot directly edit our repositories, but this is a 'Fork' button that will create a copy of it in Github under your account name. You can then edit anything there. You can have the system submit patches back by doing a 'Pull Request', which will automatically create an issue on our repositories issue page, along with a request that contains all your changes to us. From this we can review it and choose to accept it back into the Rocket repository. If you are logged into your Github account, each file you view will have an edit button. This allows you to edit the file directly in the browser. If you click this edit button on our repository, it will automatically do the fork for you and save your edits in your forked copy. This is the sort of information I'm planning to explain in the webinar. It is much easier to convey by showing it in action. Regards, Dan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- William J. Brutzman Manager, IT HK MetalCraft Mfg Corp 35 Industrial Road Lodi NJ 07644-2607 973.471.7770 x145 bi...@hkmetalcraft.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] U2 demos and sample code now on Github
The Colorado Multivalue Users Group usually has a GotoMeeting available; check with Dan Schmitt for connection details. On Thu, May 23, 2013 at 4:48 PM, William Brutzman bi...@hkmetalcraft.comwrote: Dan: Easy for me to say... Perhaps a video stream is possible from there... --Bill On Thu, May 23, 2013 at 2:25 PM, Daniel McGrath dmcgr...@rocketsoftware.com wrote: For anyone near the Denver area, I'll be doing a hands on demo/tutorial at the upcoming CMUG meeting - June 11, 5:30pm for a 6pm start at Rocket's Denver office. http://www.eventbrite.com/event/6793013085 Cheers, Dan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Wednesday, May 22, 2013 9:45 AM To: wjhon...@aol.com; u2-users@listserver.u2ug.org Subject: Re: [U2] U2 demos and sample code now on Github -Original Message- From: Daniel McGrath dmcgr...@rocketsoftware.com To: Wjhonson wjhon...@aol.com Sent: Tue, May 21, 2013 8:58 pm Subject: RE: [U2] U2 demos and sample code now on Github Hi, You cannot directly edit our repositories, but this is a 'Fork' button that will create a copy of it in Github under your account name. You can then edit anything there. You can have the system submit patches back by doing a 'Pull Request', which will automatically create an issue on our repositories issue page, along with a request that contains all your changes to us. From this we can review it and choose to accept it back into the Rocket repository. If you are logged into your Github account, each file you view will have an edit button. This allows you to edit the file directly in the browser. If you click this edit button on our repository, it will automatically do the fork for you and save your edits in your forked copy. This is the sort of information I'm planning to explain in the webinar. It is much easier to convey by showing it in action. Regards, Dan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- William J. Brutzman Manager, IT HK MetalCraft Mfg Corp 35 Industrial Road Lodi NJ 07644-2607 973.471.7770 x145 bi...@hkmetalcraft.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
