Re: [U2] CONV MCU on indexed field?

2011-07-27 Thread Wols Lists
On 26/07/11 20:56, Chris Austin wrote: George, I just rebuilt the indices on the CLINE table, then tried the LIKE using the '...' as a wildcard, so I tried: SELECT CLIENT WITH NAME LIKE BRUCE... and unfortunately that worked the exact same way as the [] wildcards, returning 1

[U2] SOAP Header

2011-07-27 Thread Steve Long
Hi All - I am using the Unidata functionality to do SOAP calls and I now need to specify header information to call a SSL page. It is failing because there is not info in the header. The documentation is very sparse on this, as you all know. Anyone have any insight on how to specify header

[U2] Doing Multiple Selects in BASIC and combining the lists

2011-07-27 Thread John Thompson
This may be an easy one, or a hard one, however, I realized I don't recall ever having to do this until today, or I could just be tired... How can you do a SELECT from two different files in a BASIC program and then combine the lists of ID's so that you can do a READNEXT on it? I ask this

Re: [U2] Doing Multiple Selects in BASIC and combining the lists

2011-07-27 Thread Jeff Schasny
try: HELP MERGE.LIST John Thompson wrote: This may be an easy one, or a hard one, however, I realized I don't recall ever having to do this until today, or I could just be tired... How can you do a SELECT from two different files in a BASIC program and then combine the lists of ID's so that

Re: [U2] Doing Multiple Selects in BASIC and combining the lists

2011-07-27 Thread Buffington, Wyatt
In a nutshell SELECT FILE WITH VALUE = 'A' TO 1 SELECT FILE WITH VALUE = 'B' TO 2 MERGE.LIST 1 UNION 2 TO 0 SORT FILE VALUE -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Thompson Sent: Wednesday, July

Re: [U2] Doing Multiple Selects in BASIC and combining the lists

2011-07-27 Thread Dan Fitzgerald
I'm not sure I'd combine them; handle the data once. I'd readext through file1_list, then readnext through file2_list. ...and I'd probably use the basic select, making AMOUNT=112.50 my first filter. Again, then you only read the data once. (Exception: if the field is indexed, I'd go with an

Re: [U2] Doing Multiple Selects in BASIC and combining the lists

2011-07-27 Thread John Thompson
Thanks for the help. You guys are way better than typing in the word LIST in the pdf manuals and hoping to find what you are looking for :) On Wed, Jul 27, 2011 at 1:26 PM, Dan Fitzgerald dangf...@hotmail.comwrote: I'm not sure I'd combine them; handle the data once. I'd readext through

Re: [U2] Joins Vorks

2011-07-27 Thread Brian Leach
Urgh. UniSQL does support the newer join formats, though IIRC not all combinations. SELECT A.FULLNAME,B.ID, B.AUTHOR_ID FROM U2_BOOKS B LEFT JOIN U2_AUTHORS A ON B.AUTHOR_ID = A.ID; Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org

Re: [U2] Doing Multiple Selects in BASIC and combining the lists

2011-07-27 Thread John Thompson
Ok, got stuck again... How would your example play out in BASIC? Its just a bunch of archive info in a file that only has a couple of indexes, but, I would like to look at the active file as well... EXECUTE \SELECT FILE1 WITH VALUE = 'A' TO 1\ EXECUTE \SELECT FILE2 WITH VALUE = 'A' TO 2\

Re: [U2] SOAP Header

2011-07-27 Thread Steve Long
Thanks Larry. They are on 7.2. Currently we are using the SOAPCreateRequest, SOAPSetRequestContent, and SOAPSubmitRequest functions only. I would like to avoid adding the header info to the SOAP body if possible, but if not, how did you do it? Did you surround it by the Header tags or did

Re: [U2] Doing Multiple Selects in BASIC and combining the lists

2011-07-27 Thread Buffington, Wyatt
EXECUTE SELECT FILE WITH VALUE = 'A' TO 1 EXECUTE SELECT FILE WITH VALUE = 'B' TO 2 EXECUTE MERGE.LIST 1 UNION 2 TO 0 TOT.VAL = 0 END.OF.LIST = FALSE LOOP READNEXT KEY FROM 0 ELSE END.OF.LIST = TRUE UNTIL END.OF.LIST = TRUE DO READ RECORD FROM FILE, KEY THEN VALUE=

Re: [U2] SOAP Header

2011-07-27 Thread Larry Hiscock
Here's an example of one we're using to validate mailing addresses (the indentation is just for readability): * Build the SOAP request SoapBody = '?xml version=1.0 encoding=UTF-8?' SoapBody := 'soap:Envelope xmlns:xsi=http://www.w3.org/2001/XMLSchema-instance;' SoapBody := '

Re: [U2] Doing Multiple Selects in BASIC and combining the lists

2011-07-27 Thread Allen E. Elwood
If I understand correctly, you're going to end up with a list that has entities from two files, therefore you're going to need to do a test when you do the read to see which file the ID came from and ergo which file to read So to add to the code below, you'd need READ RECORD FROM FILE1, KEY THEN

Re: [U2] SOAP Header

2011-07-27 Thread Steve Long
Thanks Larry. I think we need to try the secureRequest, but I haven't messed with the setup. I see you are doing loadSecurityContext. How did you create the context? Via the saveSecurityContext? Thanks, Steve Long Spyderweb Technical Services, Inc. (360) 687-8797 Washington (503) 406-8797

Re: [U2] Doing Multiple Selects in BASIC and combining the lists

2011-07-27 Thread John Thompson
Yes it occurred to me some minutes ago that they ID's in the two files are different, so you are correct. So I'll probably end up just doing the two readnext's anyway like a previous poster suggested. However, thanks for all the examples. I started out on an older PICK system that did not have

Re: [U2] SOAP Header

2011-07-27 Thread Larry Hiscock
It's been a while since I've created one, but IIRC, the easiest way is to use UniAdmin to create a CSR, then a self-signed certificate (or you can purchase a cert using the CSR) and the security context. Check out the UniData Security Features guide at

Re: [U2] Doing Multiple Selects in BASIC and combining the lists

2011-07-27 Thread Charles_Shaffer
John Said and sometimes I wish they just stored the lists in a BASIC program as dynamic arrays... There is the READLIST verb. That takes a list and makes a dynamic array with it. P type uses READSELECT. Charles Shaffer Senior Analyst NTN-Bower Corporation

Re: [U2] Doing Multiple Selects in BASIC and combining the lists

2011-07-27 Thread Jeff Schasny
The lists are stored in SAVEDLISTS as a multi-attribute dynamic array John Thompson wrote: Yes it occurred to me some minutes ago that they ID's in the two files are different, so you are correct. So I'll probably end up just doing the two readnext's anyway like a previous poster suggested.

Re: [U2] SOAP Header

2011-07-27 Thread Steve Long
Thanks for your help Larry! Thanks, Steve Long Spyderweb Technical Services, Inc. (360) 687-8797 Washington (503) 406-8797 Oregon (866) 354-5913 Fax -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Larry Hiscock

Re: [U2] HS.ADMIN Scrub Hangs

2011-07-27 Thread Bill Brutzman
When I do a LOGTO HS.ADMIN HS.ADMIN 5. HS.SCRUB Choose Account... Metal Choose File... INVOICE It comes back with... Analyzing: INVOICE * An then Ctrl-Break, A and Q do not work... I have to close the Dynamic Connect session entirely. What gives? --Bill

Re: [U2] Doing Multiple Selects in BASIC and combining the lists

2011-07-27 Thread andy baum
John, I'm guessing you're using a PICK account, to use numbered select lists in these accounts you must have $OPTIONS -S in the code. Also multiple TCL commands can be combined together just as in a PA VOC type avoiding the need for multiple EXECUTE's so the code could look something like

Re: [U2] HS.ADMIN Scrub Hangs

2011-07-27 Thread Mark Eastwood
Try a LIST.READU to see if there are locks ? Mark -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman Sent: Wednesday, July 27, 2011 4:45 PM To: U2 Users List Subject: Re: [U2] HS.ADMIN Scrub Hangs When

Re: [U2] HS.ADMIN Scrub Hangs

2011-07-27 Thread Bill Brutzman
1. I ran LIST.READU... there were no locks. 2. Problem solved... the problem was with... The DICTionary fields (1 thru 8, especially 4 and 8) for the field, in my case PARTNUMBER, have to exist and be specified properly... if not, HS.SCRUB hangs on the file (in my case the INVOICE file)

Re: [U2] SOAP Header

2011-07-27 Thread Kevin King
I'm confused. Exactly what is setting the Host: http header in the SOAP request? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] HS.ADMIN Scrub Hangs

2011-07-27 Thread Wols Lists
On 27/07/11 22:46, Bill Brutzman wrote: 1. I ran LIST.READU... there were no locks. 2. Problem solved... the problem was with... The DICTionary fields (1 thru 8, especially 4 and 8) for the field, in my case PARTNUMBER, have to exist and be specified properly... if not, HS.SCRUB hangs on the

Re: [U2] HS.ADMIN Scrub Hangs

2011-07-27 Thread Bill Brutzman
Wol... UniVerse 10.3..6 on HP Integrity Itanium It is good to know that HS.SCRUB is on PickWiki. --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists Sent: Wednesday, July 27, 2011 7:08 PM To: