Over the last few weeks, Elkie Holland from Prospectus IT
(http://www.prospectus.co.uk/blog) created a series of video interviews with
David Cooper, Lead Developer at BlueFinity International, on a variety of
topics relevant to the MultiValue community.
Please feel free to browse the video
And to add even further to the mix ... bear in mind my advice is about
operating systems not U2, and my knowledge is UV not UD ...
Are you SURE it's not needed if the source is Linux? Or do you actually
mean Linux/x86? Certainly with UV, the OS is irrelevant, what matters is
the endian-ness of
and you want to make sure that the originating UNIX system does not
have files named in both upper and lower case e.g. EMPLOYEES and
employees. That causes some fun.
Correct these on the UNIX side before an attempt is made. There are
standard utilities e.g. NT_SCOUT for checking issues prior
Why not
tar -cvzf MDB.tgz ACCOUNTNAME
which will have the same effect as tar/compress.
And depending on the nix system, if it's running samba and on the same
net as the NT system, you should just be able to connect in Windows and
do a drag-n-drop copy rather than faffing about with
Good morning,
I should know this, but as the gray gets thicker, some of the old
knowledge seeps away.
If you have indexes on multiple attributes on a file in UniData AND you
include both of those indexed attributes in the same Select statement,
how does UniData know which index to use? Does it
Our environment here is changing considerably and the focus is more and
more inclusive of Sql database(s). My knowledge of Sql extends slightly past
the ability to spell it. If I could get some suggestions on some good venues
to learn the query language for this new database, it
I would advise that you learn about joins firste.g.
http://www.codinghorror.com/blog/2007/10/a-visual-explanation-of-sql-joins.h
tml
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Barry Rogen
Sent: 07
If your just interested in an easy paced method, and not something you need to
master tomorrow.
Look into www.ed2go.com They work with many of the community colleges and offer
many 6 week
Mini-classes. They are not college credit classes, but they are fairly
inexpensive apx $95.00
A class.
I
I would love for someone to come out with a book that really does JOINS justice.
Packed full of real examples that actually make sense
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen
Sent:
It will never use both.
Usually the first index command possible will be used.
Although I believe an EQ will override an index with GE.
David A. Green
(480) 813-1725
DAG Consulting
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
Barry:
My foray with ColdFusion has led to doing some UniVerse SQL things.
As I struggle to get the machine to do what I think I want... I have found that
it is less about the backend database and more about the middleware.
Even though I tend to buy quite a lot of books... I have found the
Barry:
Also... check out Lynda.com
--Bill
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
Thank you all for places to get my foundation built. I think from there, I can
build my own house
Barry Rogen
Senior Programmer/Analyst
PNY Technologies, Inc.
(973) 560-5327
bro...@pny.com
I often use www.w3schools.com for learning the many facets of SQL and
integration of SQL with different products. This site though is not just
limited to SQL, it is useful with other areas such as jquery, xml, asp.net,
and php to name a few. If working in working with Unix and Windows
environment
While the given link is key... a bit of frustration that I have had with SQL is
that... often I have data in more than two tables... following the first select
list... there could be data in six or more tables.
The joins that I have tried seem to max out at like... three tables.
In UniBasic...
Hi Barry
The first question with sql is - which sql? There are lots of variants, all
offering very different capabilities and features (like U2 vs R83). SQL*Plus
for Oracle is very different from TSQL for SQL Server: SQLite is a very
'standard' SQL but almost nobody uses the ANSI syntax to that
From the Using UniData manual:
Alternate Indexes in UniQuery Statement
Prior to UniData 5.2, only one index was used in the selection criteria of a
UniQuery statement, even if the selection criteria contained more than one
indexed attribute. UniQuery now uses all available indexes when
Am not sure why you would be getting the last hashed dictionary item passed.
However, I think you would need to pass something other than @ID to your
subroutine - a multivalue of files via another I descriptor with subroutine.
Don't know about in UniData but in UniVerse VOC4 has M and 7 an mv
Excellent news.
However, is there a way to utilize two indexes with the SELECTINDEX
command in Unibasic?
Sincerely,
David Laansma
IT Manager
Hubbard Supply Co.
Direct: 810-342-7143
Office: 810-234-8681
Fax: 810-234-6142
www.hubbardsupply.com
Delivering Products, Services and Innovative Solutions
Thanks Wally.
I was waiting for the official word.
John Israel
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wally Terhune
Sent: Wednesday, November 07, 2012 11:47 AM
To: U2 Users List
Subject: Re: [U2] Multiple
No on UniBasic SELECTINDEX statement.
Not sure I'd call a change made at UniData 5.2 in June of 2000 as 'news'. :-)
Wally Terhune
Technical Support Engineer
Rocket Software
4600 South Ulster Street, Suite 1100 **Denver, CO 80237 **USA
t: +1 720 475 8055 **e: wterh...@rocketsoftware.com **w:
The first one
-Original Message-
From: Doug Farmer dfar...@epicor.com
To: U2 Users List u2-users@listserver.u2ug.org
Sent: Wed, Nov 7, 2012 6:35 am
Subject: [U2] Multiple UniData Indexes in same select
Good morning,
I should know this, but as the gray gets thicker, some of the
What about Universe?
-Original Message-
From: Wally Terhune wterh...@rocketsoftware.com
To: U2 Users List u2-users@listserver.u2ug.org
Sent: Wed, Nov 7, 2012 9:05 am
Subject: Re: [U2] Multiple UniData Indexes in same select
No on UniBasic SELECTINDEX statement.
Not sure I'd
Appreciate the answer! I was going to guess it only used the first one.
Doug
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wally Terhune
Sent: Wednesday, November 07, 2012 11:05 AM
To: U2 Users List
Subject:
Thanks Brett.
It turns out that UD works this way. The solution was to also pass in
@RECORD. Even though @ID passed in the wrong ID, @RECORD passed in the
correct VOC item. So, I was able to read attribute #2 (the data file
path) then proceed from there. In addition, if this was an LF
On 07/11/12 16:31, Bill Brutzman wrote:
While the given link is key... a bit of frustration that I have had with SQL
is that... often I have data in more than two tables... following the first
select list... there could be data in six or more tables.
The joins that I have tried seem to max
On 07/11/12 17:18, Wjhonson wrote:
What about Universe?
imho, it just doesn't make logical sense in BASIC!
just do SELECTINDEX, READLIST, SELECTINDEX, READLIST and then manipulate
it yourself.
Okay, that's more hassle, but IME the results of reading the index file
always give me a sorted
Wol:
The idea to do views is a big help and much appreciated.
In UniVerse... to do views appears to require a schema. Thus, I need to get
up-to-speed on SQL Schemas in UniVerse.
--Bill
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
Very good. Thank you for the responses. I will try those things out.
Robert Norman
On 11/6/2012 1:03 PM, Wally Terhune wrote:
Fnuxi is UniVerse - not UniData.
UDTBIN\convdata will convert the byte order of hashed files.
If the source machine is Linux, this will not be necessary.
You will need
On 07/11/12 16:31, Bill Brutzman wrote:
The joins that I have tried seem to max out at like... three tables.
in UV have a look at SET.SQL to tweak the workspace memory used for the current
session.
___
U2-Users mailing list
In Universe I have used the EXPLAIN keyword in the past to understand how the
query will be processed.
You just add the keyword EXPLAIN to the end of your query statement.
The documentation says it for SQL statements but it seems to work on Universe
SELECT statements.
Showing How a Query
We have a customer who has a system that was rebooted a couple days ago.
Since then, and only in one certain subroutine, when doing an MCU
conversion on a multivalued list, the ASCII 253 value marks are replaced
with ASCII 221. Understanding that the difference between an lower and
upper case A
Kevin:
Many releases ago on Unidata we noticed that this particular code was not
working. The code would work when we had it in another program. The
program would fail even when we added CRT statements around the code. So,
we moved the offending code to another area of the program and the
Once again (I'm a fan of these) the answer is to create a file of composite
keys (FldA * FldB etc) and index that...
The bummer is that the xref file will always be out unless one adds a
'trigger' to each 'to be indexed' file
Itypes can then be created to XLATE the data from the specific files.
Kevin:
You might try to re-compile the code. Ever since I went to UniData on
Windows I have an occasional burp in programs. Last week one of our
clients reported an index not working properly. A thorough review showed
no problems. We had their IT people in and still were having problems.
From memory...
The difference may depend on the UNIX LANG setting for different users.
LANG=C may be required. You don't say what platform you are on.
We may also have fixed something since 6.1.15. My memory isn't what it used to
be. You can certainly scan the readmes for MCU and/or UPCASE.
36 matches
Mail list logo