John, you can create one generic routine that can execute any BCI query.
I could probably dig one out given a bit of notice (next week, when I get home
from Japan).
Call is something like:
RESULT = BCI(DSN, USERID, PASSWORD, SQLQUERY)
---
u2-users mailing list
u2-users@listserver.u2ug.org
To
If, on the other hand, your U2 system and processes make up much more
than 1% of your
business IT, which can easily be imagined because SQL and OO
infrastructure is
bloated beyond belief, then realize you can pretty much do anything with
MV. It is a
far, far, far better platform for transaction
Here's a Basic routine I use in UD:
SUBROUTINE QUICKSORT(ARRAY)
*** Quick Sort the elements of a dynamic array
EQU AM TO CHAR(254)
VALUES = DCOUNT(ARRAY,AM)
IF VALUES = 1 THEN RETURN
PIVOT = ARRAY1;** First element
HIGHSTRING = ''; ** list of elements pivot
Baker
Off the top of my head:
FUNCTION SortArray(InArray, AllowDups)
Dc = DCount(InArray,@FM)
OutArray = ''
For I = 1 To Dc
Locate InArrayI In OutArray By AL Setting Pos Then
If AllowDups Then Ins InArrayI Before OutArrayPos
End Else
Ins InArrayI Before OutArrayPos
End
Next
Brenda:
If I understand correctly, your managers know little of IT while your IT know
little
about the business; they just trust each other. As a result, most of your
managers
and IT want that massive 99% of your IT, that is little related to your core
business, to swallow up the 1% of your IT
I have always preferred dynamic files. In the long run, they are easier to
deal with. You should still determine the best block size. Also, if you are
going to bulk load it, you should set the min mod so that it does not start
splitting right off the bat. You still want the basic size to be
Note that if the array is big, you would get much better performance by loading
it into a DIM array, so the sort of sort below, then put the results back into
a dynamic array.
Dynamic arrays are much easier to use, but when used wisely, dimensioned arrays
can be MUCH faster. This is true for
John - me too, when I can. In this case I'm reading in a mv list of other
record ID's. They are likely in order, but its imperative that they are, so
the SORT is a precaution, since 'stuff' happens.
-Baker
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
Thank you Bill, Brian Norman,
If I'm allowed to deploy a separate Function or Sub you've virtually coded it
for me.
-Baker
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
Thanks WOL, A colleague also directed me to PickWiki and the thoughts on SORT
there are a good read, and show the options.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Anthony Youngman
Sent: Tuesday, July 22, 2008 10:53 AM
To:
Baker,
In that case, I do not think there is exactly what you want (or not one I know
of). I would write a simple subroutine to do this, and write it such that you
can just plug it in where ever you need it, including (and maybe most
importantly), into a Dict. Pass it several arguments (like
We use dynamic files no problem - yes I suppose in certain circumstances
there is an overhead, but it would still be faster than a badly sized static
file. The conclusion we have is if you are really on top of your file sizes
and administrating things daily there is probably less need for dynamic
One thing I would say on this is never presume - experiment - I have been
stung in the past when using remove on the dynamic array portion of a
dimensioned array - turned out to be faster to have the whole thing
dynamic..
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL
ESET NOD32 Antivirus, version of virus signature
database 3288 (20080722) __
The message was checked by ESET NOD32 Antivirus.
http://www.eset.com
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
Actually 99% of our business data and logic is contained on the Universe
database but 90% of the fluff that connects to it is in windows. This has
created a problem in that the majority of personnel dedicated to the fluff
far exceeds the number of personnel dedicated to UV, and there's power in
Files that grow at a controlled rate and especially files that could exceed
2G are good candidates for dynamic files. Files that are cleared, or files
that have masses of data loaded or removed from them, are not. Work files,
for example, can be a horrible use of dynamic files. As was stated
Hey, and don't forget to do a speed test. You know, because LOCATE is coded
as part of the OS it just *might* be faster than bubble or speed sort
options.
In fact, this was a topic on this list about 3 or 4 years ago and someone
doing the speed test concluded LOCATE was in fact faster.
And no I
Your doomed.
John Israel
Sr. Programmer/Analyst
Dayton Superior Corporation
721 Richard St.
Dayton, OH 45342
937-866-0711 x44380
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of JPB-U2UG
Sent: Tuesday, July 22, 2008 4:14 PM
To:
Symeon,
In today's world of faster and faster processors with more and more disk
space, we always use dynamic files for transactions based records and static
for code files or files that have little growth. We work in both Unidata
and Universe and find they both have drawback and pluses which
OnGroup.com has a product for this sort of thing. While I have not worked
with OnWare, the concept
reminds me of a thing in the real estate world called a Bridge Loan.
It is like I have a house to sell, I buy another house before I sell the
first house, pay two mortgages and then get a third
Ray,
that would be appreciated
At the moment i am hesitating on going down this path as its seems like a
redundant technology given its verbosity
Also a bit of a learning curve compared to say making Universe accessible to
SQL queries .
2nd problem is actually getting access to SAP table
u2-users@listserver.u2ug.org To unsubscribe please visit
http://listserver.u2ug.org/ __ Information from ESET NOD32
Antivirus, version of virus signature database 3289 (20080722) __
The message was checked by ESET NOD32 Antivirus. http://www.eset.com
__ Information from
We had the same issue back in the 90's. So a clever guy (Ed) that worked
with us wrote a small C program (on Unix) to do the sort. This also
included controlling/dependants fields. Any universe program could call
it, passing in the variables and returned the items sorted.
Speed is incredible. To
John
2nd problem is actually getting access to SAP table names, data
definitions etc.
As I understand it, the SAP Table names are in SAP (German) code, and
the column names are in SAP code. Then there is another set of tables -
also named in SAP code, of course - which provide translations
Ray,
is there any problem to doing this while people are logged in and might
write to the file
Assuming the file is not in common
jak
- Original Message -
From: Ray Wurlod [EMAIL PROTECTED]
To: u2-users@listserver.u2ug.org
Sent: Wednesday, July 23, 2008 9:09 AM
Subject: RE: [U2]
RESIZE filename * * * CONCURRENT USING tempdirpath
will be fine even if the dynamic hashed file is open in COMMON. Make sure that
the combination tempdirpath/filename is less than 128 characters long.
They have put a deal of work into making CONCURRENT safe over the years. Any
bad press you
I'm trying to write some software to send e-mail to a mail server. I
would like to encrypt the connection using SSL or TLS.
Could someone point me in the direction of documentation or example code
that I could look at to get started with this. It's all very new to me,
and I'm not getting
Why re-invent the wheel when there are plenty of commerical SSL/TLS
packages out there already?
Such as SecureBlackBox suite (there are plenty more out there)...they
have downloadable trialware code examples, etc.
http://www.eldos.com/sbb/net-ssl.php
Regards
David
-Original Message-
28 matches
Mail list logo