Has anyone had any problems implementing mvquery security profiles?
I have set up a security profile to allow access to a specified subset
of files, and attached users to that profile, but it seems as if the
only thing it will look at to get the list of files to display is the
MVQUERY_FILES VOC
wrote it
bob
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Dave Davis
Sent: 12 March 2007 13:02
To: u2-users@listserver.u2ug.org
Subject: [U2] MVQuery Security Profiles issue
Has anyone had any problems implementing mvquery security profiles?
I have set up
We use the My ComputerPropertiesAdvanced TabEnvironment Variables
option.
Do you actually have vi available on your windows server?
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Bill H
Sent: Tuesday, March 13, 2007 1:50 PM
To:
You are talking about unidata here I hope?
guide actually creates files (GUIDE_ADVICE.LIS, GUIDE_ERRORS.LIS,
GUIDE_STATS.LIS). You run it at the system level as opposed to at the
TCL level. If you already had GUIDE*LIS files from a previous run, it
puts a suffix at the end of those.
Also, keep
First, what are the INTERNAL values of the fields when you look at them
in the editor?
Are they 12345, 56789, and 98765? Does the field have a conversion of
MD2 or MR22?
Second, if they are not, are they something weird like 12345.1, 56789.9,
98765.2?
Your conversion code may be hiding
Does anyone have an opinion on the use of the
Output Redir Proc On
and
Output Redir Proc Off
slots in the System Control record?
I am trying to use them, and they seem to work ok for output from
reports and queries, but I would like a comprehensive list of what
options should be passed to
No, I've got that. The documentation doesn't go into enough detail.
I want to mimic what SB+ is doing with output redirection by calling
OUTPUT.SELECT with the same parameters for each case, and then add my
own code for SB+ reports and queries. I don't want untakeable options
for a report type
For example, when a PD.R process is called where output destination is
Ask, SB+ calls OUTPUT.SELECT,SBXDFHB.
When a PD.E process is called, OUTPUT.SELECT,SBXFGE1WB,SQ
When /XP is called, it looks like it's doing its own thing (untraceable)
When you run the print option from a screen definition to
Dangerous if either database is live.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Symeon Breen
Sent: Thursday, March 29, 2007 9:47 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Exporting files
A simple method is to copy the file at os level
I have a related question.
Is there any reason ODBC on UniData would only return a small set of
data to excel when joining two tables? The same SQL returns everything.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Caryl Lange
Sent: Thursday, April 05,
For #2 to work, the current directory must either be in your $PATH, or
/usr/ibm/uv/bin must be in your $PATH.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Brutzman, Bill
Sent: Friday, April 13, 2007 1:01 PM
To: '[EMAIL PROTECTED]'
Subject: [U2]
Look at the REMOVE command.
It doesn't actually delete anything, just advances an internal pointer
to the current attribute, so that it doesn't scan from the beginning
every time.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Jef Lee
Sent: Tuesday, May
Warning: This message has had one or more attachments removed
Warning: (not named).
Warning: Please read the AngelicHost-Attachment-Warning.txt attachment(s)
for more information.
Isn't @LOGNAME the group the user is a member of on Windows servers?
You may have had the users be in their own
In ECLTYPE u
SELECT HRPER WITH EVAL OCONV(HRP.LAST.NAME,'MCU') LIKE SC...
If you are currently in ECLTYPE p, you can put the word SELECT in
lowercase to evaluate using the u parser.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Greg Schraiber
Sent:
You want BY-EXP not BY
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]
Sent: Tuesday, June 05, 2007 1:42 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] Help in creating Retrieve statement for a multivalue field
My retrieve statement
You could wait for another signal file (it can be empty) to exist.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED]
Sent: Thursday, June 07, 2007 9:48 AM
To: u2-Users
Subject: [U2] [UV] Efficient way of determining if item is inuse
Hi
Is there a reason why an ODBC query would only return a limited number
of results for a Join between two tables? Single-table queries return
everything but equi-joins (on the table keys, which are identical) seem
to stop at 59. I've run the same SQL at the sql prompt and it returns
everything
If you were curious about the number of customers queried couldn't you
just do a SELECT CUSTOMER first?
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Moderator
Sent: Friday, June 22, 2007 6:15 PM
To: u2-users@listserver.u2ug.org; [EMAIL PROTECTED]
I've seen this problem (over-zealous group splitting) before using hash
type 0 on dynamic files. Hash Type 1 never had this problem. I would
(and do) reserve hash type 0 for static files. Only 1 in 12 groups
containing actual data is a bad thing though, considering average record
size is around
In unidata:
1. Before image you could just read the record from the file.
2. After image is what's in the record parameter passed into the trigger
subroutine.
3. You need different subroutines for the BEFORE UPDATE trigger and the
BEFORE DELETE trigger, as they take different numbers of
Is it KEYONLY or KEYDATA? Originally only KEYONLY splitting was
available.
If it's KEYONLY, that means when the group is 20% full of KEY data, it
is eligible for splitting. The rest of the group can store the RECORD
part of the data.
KEYDATA means the group is eligible for splitting with the
There are other ways of getting PDF output. SBClient 5.4.1 has a lot of
PDF options, but it still is a bother.
Some of our users set up PDF printers that capture the aux output as
PDF.
You could use the system control Output Redir Proc On and Output
Redir Proc Off to add PDF output options to
You could EXECUTE UDT.OPTIONS CAPTURING output.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Jonathan Leckie
Sent: Wednesday, July 18, 2007 3:09 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] UDT.OPTIONS
Is there a way to tell what a specific
Use hash type 1.
Use KEYONLY splitting.
Choose a reasonable starting modulo
Experiment with SPLIT.LOAD and MERGE.LOAD.
The file will probably be twice as slow as a perfectly sized static file
but who cares.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
case Ans = 'B' in the third set means do nothing when Ans = 'B', and
stop evaluating cases.
Surely you wouldn't wish to break millions of lines of code by changing
the meaning of the case syntax.
The gosubs should go on their own line.
-Original Message-
From: [EMAIL PROTECTED]
Not good if answer is not limited to one character wide.
Isn't ON GOSUB out of style?
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Manu Fernandes
Sent: Wednesday, July 25, 2007 12:44 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] [u2] :
Associations help more with the query side of things. They don't by
themselves do much on the basic coding side. It won't affect what a
writev command does.
Among the benefits:
1. Helps the BY.EXP parameter in query statements to show the
corresponding values from related fields. A BY-EXP
You could probably cobble something together without a subroutine, but
it's easier just to create a basic subroutine that takes locate's inputs
and produces its output.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Baakkonen,
Rodney A (Rod) 46K
Sent:
I've used the Process At End in the report definition to chain reports
together. Everything ends up in the same spool file that way.
One report's process at end calls another process that generates a
report, and so on and so on.
I've used this method to create an empty shell report to run
metersPerSecond instead of metersPersecond perhaps?
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Geoffrey
Mitchell
Sent: Tuesday, August 14, 2007 11:12 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] [UD7.1] [Solaris 9]SOAP calls
So, what's
Place the REQUIRE.INDEX option after select GLPOST and before the
first WITH. You can't place it after the criteria in UniData.
REQUIRE.INDEX works in ecltype U but not ecltype P.
You can also use NO.INDEX to force it NOT to use the index. Try:
select GLPOST NO.INDEX WITH INDEX_2 LIKE 0605...
Demo (0)- select GLPOST REQUIRE.INDEX WITH INDEX_2 LIKE 0605...
Index can not be used processing this query.
2 Demo (0)-
Bill
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Dave Davis
Sent: Wednesday, August 15, 2007 1:13 PM
To: u2-users
Create a new file.
Select and copy from old file.
Delete old data file.
Recreate data file.
Select and copy back in.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of David Wolverton
Sent: Friday, August 17, 2007 5:21 PM
To: u2-users@listserver.u2ug.org
That $ trick is probably specific to pi/open.
I normally convert this kind of file to hex before storing in unidata.
If there's a better way, I would like to know about it.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Oaks, Harold
Sent: Tuesday,
NOCONVERT helps with OSBREADS/WRITES and OSREADS/WRITES, but you would
still have problems reading an entire binary record from a DIR type file
using the standard READ statement in UniData. You are pretty much
limited to just listing Ids if stored in a dir type.
-Original Message-
From:
Create a DIR pointer that looks like this:
:AE VOC TEMPDIR
001: DIR
002: D:\DataShare\Temp
003: D_VOC
That's the unidata way.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Bill Haskett
Sent: Thursday, August 23, 2007 3:23 PM
To:
select FILE WITH EVAL DCOUNT(@ID,@VM) # 1
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of David Wolverton
Sent: Wednesday, September 05, 2007 4:41 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] [UD] Keys with Value Marks
We all swear we've seen it on
We have a customer who has been getting the following error message show
up in single-line files in the _PH_ directory:
Name too long, do you want to change it(Y/N)?
They are on version 6.1 of unidata.
I think it is related to improper savedlists or SAVEDLISTS or
savelist.map VOC entries, but
Use of OR in selection criteria would stop the use of the index, for
example:
SELECT file WITH INDEXED.FIELD = value OR NON.INDEX.FIELD = value
Testing with the actual data appears to be the best way of figuring this
stuff out.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL
So can't you just use SELECT with BY SEQ instead of SSELECT?
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED]
Sent: Wednesday, September 26, 2007 5:12 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] UniSelectList problem
Found two
EQUATE SEMICOLON TO CHAR(59)
Or better yet put this in as a row in the /EXP.EQU list:
EE_SEMICOLONCHAR(59)
Semicolon is an absolute statement separator in SB+.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of David Murray
Sent: Wednesday, October
list EPT.XREF EVAL CONVERT(@FM,@VM,@RECORD)
(unidata)
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of roy
Sent: Tuesday, October 16, 2007 1:50 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] LIST DICT F11
Is F11 in the VOC ?
You may need to
I think that the maximum number of records in a group of 18032 is
really hurting the file performance. I would find that group, and see
what keys are being hashed to it. How many other groups approach this
number of records? How bad are the other partfiles in this regard?
Something about your
What unidata version?
What SELECT .. BY statement were you using.
Are the BY fields actually stored in the file, or are they I-types that
tran to another file?
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Burwell, Ed
Sent: Thursday, November 01,
One approach would be to set up separate accounts for privileged vs.
non-privileged users. That would give you two VOC files, and the paths
to the data could be different for some or all of the files.
Another approach is the following:
In UniData this could be done by using environment
Because there are some that match the first criteria and some that match
the second.
You can LIST these out, like this:
list filename WHEN ASD(QTY = 1000 AND QTY = 2000)
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Russ Watson
Sent: Wednesday,
You wouldn't get all records, just those that contained one or more
quantity = 1000 and also one or more quantity = 2000.
If the phase with qty = 1000 and = 2000 is actually interpreted as
with qty = 1000 OR = 2000 when a multi-valued field is evaluated,
then I would have expected to get all
Are you explicitly including the virtual fields in your select
statement? Are they in the @SELECT dictionary item?
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Larry Chiang
Sent: Tuesday, January 08, 2008 10:59 AM
To: u2-users@listserver.u2ug.org
item, but, they are
definitely are in the LISTDICT.
Dave Davis [EMAIL PROTECTED] wrote:
Are you explicitly including the virtual fields in your select
statement? Are they in the @SELECT dictionary item?
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED
Subtracting 1 means you will get a mathematical result - leading digits
are dropped.
OCONV(OCONV(@DATE,'DM') - 1,'MR%2')
will get you a result consistent with OCONV(@DATE,'DM')
If you want to strip out leading zeros in the month regardless, add 0.
-Original Message-
From: [EMAIL
What if the data fields contain quotes or double-quotes themselves?
Does this handle that situation?
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Dennis Bartlett
Sent: Wednesday, February 13, 2008 4:00 AM
To: u2-users@listserver.u2ug.org
Subject: RE:
PROTECTED] On Behalf Of Dave Davis
Sent: Wednesday, February 13, 2008 7:36 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Excel downloads
What if the data fields contain quotes or double-quotes themselves?
Does this handle that situation?
-Original Message-
From: [EMAIL PROTECTED
If you want to use unidata virtual fields (like you initially tried to)
you need to wrap them in the I() syntax
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Mecki
Foerthmann
Sent: Thursday, March 13, 2008 9:03 AM
To: u2-users@listserver.u2ug.org
What does the process look like? What are the letter options you used?
What fields are displayed?
Sounds like the key works, otherwise it wouldn't call the process.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Paul Parkinson
Sent: Tuesday, March 18,
Yes, but be sure to re-initialize to '' AFTER closing, if you close it,
at least in UniData.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Dennis Bartlett
Sent: Friday, April 04, 2008 8:07 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] COMMON
You could fix this by selecting all records EXCEPT those with keys
containing @AM in the key, copying them to a temporary file, and then
clearing the permanent file and copying from the temporary file back in.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf
That shouldn't be too difficult. I did a test with a free zip code
service.
What tools/components do you need to write a service to send stuff OUT
of unidata?
$ cat ST.BASIC.ZIP.REQ2
SUBROUTINE ST.BASIC.ZIP.REQ2(L.ZIP.CODE, RespHeaders, RespData,
SoapStatus, xmlString)
, Vol 17, Issue 8
***
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
html
body
Dave Davis Team Lead, Ramp;D P: 614-875-4910
x108
/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
html
body
Dave Davis Team Lead, Ramp;D P: 614-875-4910
x108 F: 614-875-4088 E: dda
Of Dave Davis
Sent: Friday, September 10, 2010 1:24 PM
To: U2 Users List
Subject: Re: [U2] Slow READ/WRITE with indexes (Nick Gettino)
Does building the biggest first really matter, or is it more important to just
put the right value in the key size prompt you get asked for on the first
index you
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
html
body
Dave Davis Team Lead, Ramp;D P: 614-875-4910
x108 F: 614-875-4088 E: dda...@harriscomputer.com
[http://www.harriscomputer.com/images/signatures
@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
html
body
Dave Davis Team Lead, Ramp;D P: 614-875-4910
x108 F: 614-875-4088 E: dda...@harriscomputer.com
[http://www.harriscomputer.com/images/signatures/HarrisSchools.gif]
[http
Dave Davis Team Lead, Ramp;D P: 614-875-4910
x108 F: 614-875-4088 E: dda...@harriscomputer.com
[http://www.harriscomputer.com/images/signatures/HarrisSchools.gif]
[http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif]
6110 Enterprise Parkway Grove City, OH 43123
ph:856.848.9005 Ext 220
The Wyanoke Group
http://www.wyanokegroup.com
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
html
body
Dave Davis Team Lead, Ramp;D P
mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
html
body
Dave Davis Team Lead, Ramp;D P: 614-875-4910
x108 F: 614-875-4088 E: dda...@harriscomputer.com
[http://www.harriscomputer.com/images/signatures/HarrisSchools.gif
Group
http://www.wyanokegroup.com
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
html
body
Dave Davis Team Lead, Ramp;D P: 614-875-4910
x108 F: 614-875-4088 E
the data value, what is the best way?
Charles Shaffer
Senior Analyst
NTN-Bower Corporation
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
html
body
Dave Davis
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
html
body
Dave Davis Team Lead, Ramp;D P: 614-875-4910
x108 F: 614-875-4088 E: dda...@harriscomputer.com
[http://www.harriscomputer.com/images/signatures/HarrisSchools.gif]
[http
Dave Davis Team Lead, Ramp;D P: 614-875-4910
x108 F: 614-875-4088 E: dda...@harriscomputer.com
[http://www.harriscomputer.com/images/signatures/HarrisSchools.gif]
[http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif]
6110 Enterprise Parkway Grove City, OH 43123
-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Davis
Sent: Thursday, January 13, 2011 6:25 AM
To: U2 Users List
Subject: Re: [U2] SB+ printer font changes
The printer class setting - the Set and Reset Sequences.
You need to send
body
Dave Davis Team Lead, Ramp;D P: 614-875-4910
x108 F: 614-875-4088 E: dda...@harriscomputer.com
[http://www.harriscomputer.com/images/signatures/HarrisSchools.gif]
[http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif]
6110 Enterprise Parkway
Dave Davis Team Lead, Ramp;D P: 614-875-4910
x108 F: 614-875-4088 E: dda...@harriscomputer.com
[http://www.harriscomputer.com/images/signatures/HarrisSchools.gif]
[http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif]
6110 Enterprise Parkway Grove City, OH 43123 www.harris
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
html
body
Dave
Dave Davis Team Lead, Ramp;D P: 614-875-4910
x108 F: 614-875-4088 E: dda...@harriscomputer.com
[http://www.harriscomputer.com/images/signatures/HarrisSchools.gif]
[http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif]
6110 Enterprise Parkway Grove City, OH
/listinfo/u2-users
html
body
Dave Davis Team Lead, Ramp;D P: 614-875-4910
x108 F: 614-875-4088 E: dda...@harriscomputer.com
[http://www.harriscomputer.com/images/signatures/HarrisSchools.gif]
[http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif
.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
html
body
Dave Davis Team Lead, Ramp;D P: 614-875-4910
x108 F: 614-875-4088 E: dda...@harriscomputer.com
[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
html
body
Dave Davis Team Lead, Ramp;D P: 614-875-4910
x108 F: 614
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
html
body
Dave Davis Team Lead, Ramp;D P: 614-875-4910
x108 F: 614-875-4088 E: dda...@harriscomputer.com
[http://www.harriscomputer.com
is NOT the error I was
actually trying to solve).
John Israel
Senior Programmer/Analyst
Dayton Superior Corporation
1125 Byers Road
Miamisburg, OH 45342
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Davis
Sent
+ records before
blowing up.
John Israel
Senior Programmer/Analyst
Dayton Superior Corporation
1125 Byers Road
Miamisburg, OH 45342
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Davis
Sent: Tuesday, June
: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Davis
Sent: Tuesday, June 07, 2011 11:12 AM
To: U2 Users List
Subject: Re: [U2] SB Error
Does the web side make use of SB+ at all? Through a derived field or indexed
field or trigger? If you can
Services, Inc.
(360) 687-8797 Washington
(503) 406-8797 Oregon
(866) 354-5913 Fax
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
html
body
Dave Davis Team
list archive at Nabble.com.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
html
body
Dave Davis Team Lead, Ramp;D P: 614-875-4910
x108 F: 614-875-4088 E: dda
like this. As it is,
GET.LIST.TOTAL is used in multiple files of different shapes and sizes.
Dave Davis-3 wrote:
Do you do a lot of this query statement within an I-type kind of thing?
The performance must be atrocious.
I would make an index on cust_shipto_cart in the detail file (if you
don't
: M
...and then a subroutine like:
SUBROUTINE GET.KEYS(KEY_LIST,COMMAND)
COMMAND=COMMAND: TO 9
EXECUTE COMMAND RTNLIST 9
READLIST KEY_LIST FROM 9
RETURN
Is this along the right idea?
Dave Davis-3 wrote:
You could create one multi-valued I-type in the master file that gets you
the keys
. But nonetheless, I'm getting 0's
in these double-layered summation fields. *sigh*
Any ideas?
Dave Davis-3 wrote:
Not quite - my GET.KEYS would instead look like this:
1: I
2: SUBR('GET.KEYS','core_cart_detail', 'cust_shipto_cart',
cust_shipto_cart)
Which tells the general purpose GET.KEYS routine
body
Dave Davis Team Lead, Ramp;D P: 614-875-4910
x108 F: 614-875-4088 E: dda...@harriscomputer.com
[http://www.harriscomputer.com/images/signatures/HarrisSchools.gif]
[http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif]
6110 Enterprise Parkway
/listinfo/u2-users
html
body
Dave Davis Team Lead, Ramp;D P: 614-875-4910
x108 F: 614-875-4088 E: dda...@harriscomputer.com
[http://www.harriscomputer.com/images/signatures/HarrisSchools.gif]
[http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif]
6110
in unibasic.
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Steve Romanow
Sent: Thursday, September 08, 2011 11:28 AM
To: U2 Users List
Subject: Re: [U2] Lock Status
On Thu, Sep 8, 2011 at 11:26 AM, Dave Davis dda
/u2-users
--
-Kevin
http://www.PrecisOnline.com
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
html
body
Dave Davis Team Lead, Ramp;D P: 614-875-4910
x108 F
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.gif]
[http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif]http://www.harriscomputer.com/
6110 Enterprise
-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.gif
/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.gif]
[http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif]http
/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.gif]
[http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif
-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.gif]
[http
to stop it from prompting if 'F' was entered but
prompt like normal, otherwise?
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Davis
Sent: Monday, December 12, 2011 11:35 AM
To: U2 Users List
Subject: Re: [U2] SB
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.gif]
[http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif]http://www.harriscomputer.com/
6110 Enterprise
@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.gif]
[http://www.harriscomputer.com
?
Garry L. Smith
Director Info. Systems
Charles McMurray Company
T# 559-292-5782 F# 559-346-6169
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Davis
Sent: Thursday, January 26, 2012 10:17 AM
To: U2 Users List
-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
1 - 100 of 144 matches
Mail list logo