RE: [U2] SQL a possibility?

George NowHow can I put that data into a saved-list? (Using either TCL or SQL?) for that matter, how do you save a list using SQL on Universe? I tried creating a view, but was told I had to create a schema in order to create tables...that's no fun... SQL - SELECT SWITCHIT TO SLIST 0 FROM

RE: [U2] Host Access on Vista

Using 7.3e on vista here, seems to run the same as it did on XP... Ed -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of John Kent Sent: 02 April 2009 03:42 To: u2-users@listserver.u2ug.org Subject: [U2] Host Access on

Re: [U2] Question about indexing

Hi Mark, Doing selects in a loop is never a good idea especially on large files and definitely not a sorted one like you are trying to do. But if you really have no other option, then you should at least create an index on ItmID on TABLE2. I don't know about Universe, but don't you have to do

Re: [U2] Host Access on Vista

I'm running 7.2 with no issues. -Dianne John Kent wrote: Hi all are there any HostAccess users out there running the above emulator on Vista prior to release 7.4. If so did you have any problems. Any feedback appreciated jak --- u2-users mailing list u2-users@listserver.u2ug.org To

RE: [U2] Question About Indexing

While I am not entirely clear on the top-down business-logic requirements-analysis thing...I presume that we want to subtract Table2 from Table1. Perhaps the following is helpful. The index and the record contents are created at the same time as Table3 is generated. Open Table1 to F.Table1

[U2] Unidata limits - Where are they documented?

I have a vague recollection that I've seen something in the Unidata manuals - years ago - documenting the maximums for a TCL statement, record size, number of IDs that can be specified in a SELECT statement, that sort of thing. I've searched the manual set but I can't seem to locate that

[U2] files selected by guide

Does anybody know what the selection criteria is for the guide command? When we run guide, it aborts with a memory fault error. I am writing a program to run guide on each file individually. I am capturing the output so I can identify which file it is processing when it aborts. Steve Kunzman

Re: [U2] files selected by guide

I believe it selects the F-pointers in the VOC in the current count. On Thu, Apr 2, 2009 at 8:27 AM, stevekunz...@asidatamyte.com wrote: Does anybody know what the selection criteria is for the guide command? When we run guide, it aborts with a memory fault error. I am writing a program to

Re: [U2] files selected by guide

account, that is. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/

[U2] UVRPC API question

Hey all, on aix 5.2/ uv 10.2.x is it possible to directly talk to the uvrpc without using uniobjects (ie. via a direct socket call). If this is possible can anyone share how they did it (ie what did you send/receive) or any special things you had to do to get it to work. thanks in

RE: [U2] Unidata limits - Where are they documented?

From TCL: LIMIT? -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Thursday, April 02, 2009 10:34 AM To: u2-users@listserver.u2ug.org Subject: [U2] Unidata limits - Where are they documented? I have a

RE: [U2] Unidata limits - Where are they documented?

I saw them in the Using UniQuery Manual under the Basic of Uniquery Here are the main limitations: n Cannot exceed 9247 characters. n Cannot contain more than 20 sort fields (BY...). n Cannot contain more than 120 WITH statements. n Cannot contain more than 60 WHEN statements. n A WHEN

Re: [U2] Unidata limits - Where are they documented?

Okay, I didn't know about LIMIT. Too cool. Thanks! --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Question About Indexing

Quoting Brutzman, Bill bi...@hkmetalcraft.com: Thanks Bill Mecki for your quick response First, Mecki thats for your suggestion about not using for/next look on my cicle. And about BUILD.INDEX, yes... I did run BUILD.INDEX i just typed wrong the command that I used, on my email..:).

[U2] uniobjects/web services

Hey all, On aix 5.2/uv 10.2.x has anyone implemented web services with uniobjects? We are getting unknown errors when we use threading but they seem to go away when we serialize the web service. I know the info is a bit shaky (sorry) But I am more interested in shops that have

RE: [U2] SQL a possibility?

I Didn't really want to do that. I opted for the COMO solution, then used the editor to delete out all the TOF's, then saved what was left in SAVEDLISTS. At that point I did a GET.LIST, followed by a SELECT on the file that the ID's were to point to. This weeded out all of the blank lines that the

RE: [U2] SQL a possibility?

-Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2- us...@listserver.u2ug.org] On Behalf Of Brian Leach Sent: Thursday, April 02, 2009 4:21 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] SQL a possibility? George NowHow can I put that data

RE: [U2] UVRPC API question

From: doug chanco on aix 5.2/ uv 10.2.x is it possible to directly talk to the uvrpc without using uniobjects (ie. via a direct socket call). If this is possible can anyone share how they did it (ie what did you send/receive) or any special things you had to do to get it to work. Any

Re: [U2] uniobjects/web services

We are using web services with uniobjects but they are Java service (JAX-WS) running on a glassfish (Sun Application Server) hosted on a Linux VM. HTH Doug Chanco wrote: Hey all, On aix 5.2/uv 10.2.x has anyone implemented web services with uniobjects? We are getting unknown errors

Re: [U2] Question About Indexing

Mark, READNEXT works on any multi-attributed array not just on active select lists. Look up the FROM option or the SELECT command in the Unibasic manual. And of course instead of reading from the SAVEDLISTS file you might rather want to execute 'get-list listname' I gathered that the

Re: [U2] uniobjects/web services

With Java services and servlets thread safety is handled by placing the UniObjects session inside a method. This ensures that each user gets it's own connection and session. Thus it is safe. Example: *Not Safe: * public class MyServlet extends Httpservlet... { public UniJava myUniJava;

[U2] Universe BCI to MS MSQL Null Question

Do I have to change all empty strings ('') to Char(128) within my program to get a Null field in MS SQL or is there a flag somewhere to have the client do this automatically? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] SQL a possibility? [ad]

*gasp!* The pain we see when people try to move data from Excel into MV. Just have a look at this: nospamNebula-RnD.com/blog/tech/2009/03/xchange-intro1.html Screenshots in blog. Beta available soon... BTW, it wouldn't help with this project but if anyone wants to export Excel sheets to CSV,

Re: [U2] uniobjects/web services

Here is a list of applications we're consuming services with. 1. Product Labeler (1) 2. Stainless Tag engraver (1) 3. Saw nesting / programming (1) 4. MTR document processing 5. User authentication 6. Product drop manager (2) 7. Web based pick with custom data fields (1)

RE: [U2] SQL a possibility?

George Did you end up creating one process or did you opt for steps. Laurie Blain Unidata Programmer Analyst Live, Love, Code! Columbus, Ohio laurie_bl...@yahoo.com --- On Thu, 4/2/09, George Gallen ggal...@wyanokegroup.com wrote: From: George Gallen ggal...@wyanokegroup.com Subject: RE: