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,
> return
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
i
Hi Steve,
What version of UD and on what platform?
The reason I ask is that we have a client that is stuck on UD v6.1 for the
time being (because they're on SCO OpenServer). At that rev and on that
platform, we ran into issues using some of the SOAP functions. We were able
to work around it,
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 because
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 yo
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 27
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 a
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 wrote:
>
> I'm not sure I'd combine them; handle the data once.
>
> I'd readext through file1_list, then r
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
[mailto:u2-users-boun...@listserver.u2
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\
EXECUTE
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 tags or
did you just
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= OCONV(
Here's an example of one we're using to validate mailing addresses (the
indentation is just for readability):
* Build the SOAP request
SoapBody = ''
SoapBody := 'http://www.w3.org/2001/XMLSchema-instance";'
SoapBody := ' xmlns:xsd="http://www.w3.org/2001/XMLSchema";'
SoapBody := ' xmlns:soap="ht
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
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 Oreg
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 m
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
http://www.rocketsoftware.com/u2/products/uni
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
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.
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
Sen
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, and do not work...
I have to close the Dynamic Connect session entirely.
What gives?
--Bill
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 this
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
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) altoget
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
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
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: u2-user
27 matches
Mail list logo