UVFIXFILE is a good command for this.
If the file is 32bit it works (maybe just trace group 1).
If the file is 64bit it does not work, but emits an error message and sets
@SYSTEM.RETURN.CODE to -1.
___
U2-Users mailing list
Ah, there we're getting in to PRIMOS architecture (and, by implication, that of
most UNIX variants).
Ring 0 was the innermost ring, effectively the kernel, where you had to be
extremely privileged to do anything at all.
Most users executed in Ring 3.
Ring 1 consisted mostly of interludes to
In DataStage I have used the indirect all method to implement late binding
(referred to in the OOP post) to create a rules engine. The actual rules to
be applied/tested could not be known until the data actually arrived. So the
test routine itself was effectively little more than a dispatcher,
With you on that!
Bring back RUNOFF!
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
Hi Jeff,
You need to byte-swap data as part of the migration process. For example,
what's stored as (hex) 004E on the Solaris machine (unless it uses Intel chips)
is stored as (hex) 4E00 on the Intel-chipped Linux machine. UniVerse, as
someone else noted has a utility called fnuxi (also
I haven't been following this thread but it occurs to me to point out that
Linux machine is probably running Intel chips with a different byte order to
that used on the Solaris machine. If that point's already been made then
please ignore this observation.
Recently spotted music compilation: WORLDSHITS
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
Sounds like you need a tool developed on the sub-continent! =8^D
- Original Message -
I am attempting to make a QA virtual universe system and I
think I am going to have a big Indian/little Indian issue
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe
DataStage (from IBM) talks natively to UniData.
- Original Message -
From: Jeff Butera [EMAIL PROTECTED]
To: u2-users@listserver.u2ug.org
Subject: [U2] Pentaho/ETL Tools
Date: Fri, 14 Nov 2008 22:44:59 -0500 (EST)
We're in the midst of creating a data warehouse from our UniData
You can even write to the VOC if you don't have write permission to the file.
Hint: usd runs with superuser privileges.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
I'd like to take issue with that, Brian. As far as I am aware what you say is
right for a LIT equate, but not for a TO equate.
With a TO equate the compiler evaluates the expression, so that the literal
string (in the current example) ABCD~EFGH would be what was substituted
throughout the
Not sure what software package you're referring to here. QualityStage from
IBM is ideal - you get total control over the fuzzy logic, the ability to
standardize forms (such as AV, AVE, AVENUE) and, of course, the ability to
control the probability levels at which the potential duplicates are
Without being able to check at the moment, I'm fairly sure you'd be able to do
it via PORT.STATUS or one of the options to ANALYZE.SHM.
Next time I have access to a UniVerse system I'll check that theory unless
someone else has done it first.
---
u2-users mailing list
There's an UPDATE.RECORD verb (I think the source is in APP.PROGS) that might
serve instead.
- Original Message -
From: Boydell, Stuart [EMAIL PROTECTED]
To: u2-users@listserver.u2ug.org, [EMAIL PROTECTED]
Subject: [U2] [UV] REFORMAT from a distributed file.
Date: Mon, 22 Sep 2008
The slave referred to here is the process that needs to log in to do the work.
When you connect via uvcs (which you do from UniObjects to UniVerse) the
listener is unirpcd (or uvrpcd on older versions), listening on port #31438 (by
default).
A request to connect has unirpcd consult its services
It's not going to happen. UniVerse SELECT often doesn't select at all
(particularly with Type 30 files, for which there is a count of active SELECTs
kept in shared memory), but merely opens a cursor at the beginning of the file.
It's the READNEXT that moves the cursor through the file (unless
I think it's time to verify this file with fixtool or uvfixfile.
Your LIST may have been lucky and not encountered the problem (corrupted?)
group buffer.
SSELECT, of course, must perforce attempt to process the entire file.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To
Enhancement request?
In the case where SELECT does not select (see my earlier mail) a message to
this effect might be emitted.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
Maybe you need to check first that no-one is using transaction logging (someone
has changed the TXMODE setting to 1 - why?).
Perhaps the someone is no longer there, which is why everyone assumes.
Assuming is dangerous in the IT world.
Regards,
Ray
- Original Message -
From:
The obvious response is yes, because everything is possible if you have
knowledge of the structure and use READBLK/WRITEBLK.
But out of the box? I doubt it.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
Yes the problem is with transaction logging, but don't switch it off
completely. Find out why things can't be logged. For example are the logs all
in a FULL state? Is the system-wide state of transaction logging preventing
logging?
---
u2-users mailing list
u2-users@listserver.u2ug.org
UV indexes are B-trees too. BSCAN allows you to traverse the leaf nodes,
rather than go up and down the tree to get to the next leaf node.
But you are right that, within that structure, the dynamic array of primary
keys associated with a particular index key value is stored as, well, a dynamic
The limit is 1000. This results from the actual index files following the
naming convention INDEX.nnn starting from 000.
Every index degrades update performance, so you should still be selective.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit
The uv command takes an optional command line argument, the command to be
executed.
Make sure you're attached to an account directory, and that the UniVerse bin
directory is in your PATH.
uv PHANTOM PROGNAME VAR1 VAR2
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe
There is no field #2. Therefore A2 is . Therefore any value in it must be
.
- Original Message -
From: Jef Lee [EMAIL PROTECTED]
To: u2-users@listserver.u2ug.org u2-users@listserver.u2ug.org
Subject: RE: [U2] UniBasic Oddities
Date: Wed, 20 Aug 2008 09:20:09 +0800
Our 10.1.11
VLIST it. All flavors of UniVerse should support it.
- Original Message -
From: David A. Green [EMAIL PROTECTED]
To: u2-users@listserver.u2ug.org
Subject: [U2] UniBasic Oddities
Date: Tue, 19 Aug 2008 16:18:57 -0700
Since we're on the subject of UniBasic Oddities, I was
You need UV/Net. There are two solutions.
1. Wherever you want to run the application, set up VOC entries to point to the
remote part files, using hostname!pathname syntax in the DATA.FILE (field #2)
entry. This will be picked up by UV/Net software and afford remote access to
the part files.
defcs is default client/server - one of uvcs or udcs
Look in your unirpcservices file for more information.
Some of these may be fixtool (UniVerse), others may be other UniObjects
connection such as UniAdmin or your own application.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To
C/^^253^^253/^^253/
- Original Message -
From: Brutzman, Bill [EMAIL PROTECTED]
To: 'u2-users@listserver.u2ug.org' u2-users@listserver.u2ug.org
Subject: [U2] [UV] Editing Subsequent Value Marks
Date: Wed, 13 Aug 2008 11:19:36 -0400
I have what looks like ^253^253 that needs to
David,
Don't forget to invoice IBM when they use this! ;)
Regards,
Ray
(presently in Japan,therefore missing U2 University)
- Original Message -
From: David Jordan [EMAIL PROTECTED]
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Why Buy (or develop in) UniVerse?
Date: Wed, 13
- Original Message -
From: Dan Fitzgerald [EMAIL PROTECTED]
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] fixtool
Date: Mon, 4 Aug 2008 13:59:55 -0400
Wide and shallow shall be your files.
That was Dan channeling Yoda (though the verb should have been at the end: wide
and
The answer is very simple. When they were looking for a name, they chose the
name of the largest structure in this particular shared memory segment
(apparently user shared memory segment would have been confused with private
memory segments). The largest structure in the printer shared memory
Mike beat me to it. The reason that the call is case sensitive is because
that's how it's cataloged in VOC. No problem making a copy of the verb in VOC
with an all upper-case name.
And, yes, FOUR arguments.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit
This is the first time I have encountered a restriction on using CONCURRENT on
Type 30 files.
It comes as quite a surprise, because 24x7 sites like the Ambulance Service
need it.
I suspect that the error on USING is a subsequent error from the first one.
You should always be able to specify
Try upper case -64BIT at the end.
- Original Message -
From: Hennessey, Mark F. [EMAIL PROTECTED]
To: u2-users@listserver.u2ug.org
Subject: [U2] uv - mkdbfile [not-secure]
Date: Thu, 24 Jul 2008 12:02:21 -0400
UV 10.2.2, Solaris 10:
Friends, I'm having a braincramp. I can not
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
09:48:50 +1000
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
LEFT JOIN and LEFT OUTER JOIN are the same animal.
A left outer join must yield every row from the left input and (a) any matching
rows from the right input and (b) nulls for any row that does not exist in the
right input. To achieve this from the right input, the optimizer has chosen to
use
UniVerse/SQL is quite limited in its range of data types.
Use VARCHAR(65535), which I believe is the largest size you can have in DDL,
but it seems not to be enforced as an upper limit in most cases.
- Original Message -
From: Barry Rogen [EMAIL PROTECTED]
To:
Unfortunately I'll be in the wrong part of the planet for all four sessions. I
note that the fourth session (in England) clashes directly with Information on
Demand 2008 (which is where I will be that particular week).
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe
They are not the same query. The second one specifies LEFT OUTER JOIN. The
first does not.
A left outer join must capture rows that may not be in the right table.
An index on @ID in each of the tables may help.
- Original Message -
From: Anthony Youngman [EMAIL PROTECTED]
To:
In BASIC use EXECUTE to execute the DOS verb and capture its output.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
They are dynamic files, but with a special read-only bit in the header (I am
an SQL CATALOG table; you can only edit me using DDL or VERIFY.SQL).
Does fixtool (a) report any problems or (b) repair them? (Don't forget to have
backups.)
- Original Message -
From: Mac Bhyat [EMAIL
Try RESIZE filename * * * 64BIT
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
Can you do a SELECT to select the ones WITH EVERY FIELD LIKE SF... SH...
and then do NSELECT to select the inverse set?
- Original Message -
From: Jeffrey Butera [EMAIL PROTECTED]
To: u2-users@listserver.u2ug.org
Subject: [U2] Friday query logic
Date: Fri, 20 Jun 2008 11:25:30 -0400
FILEINFO() will fail if the argument is passed in an unassigned state or is
null.
Therefore, when creating routines that programs written by anyone I will
usually test first with UNASSIGNED and ISNULL before going on to other checks
such as FILEINFO or NUM.
---
u2-users mailing list
OPENCHK is also a parameter in uvconfig. It allows you to configure the system
to bypass integrity checks when the file is opened with OPEN - but not when the
file is opened with OPENCHK. Thus your understanding is conditionally correct,
depending on the setting of OPENCHK in uvconfig. This
All I can offer is that it used to work in version 9.6. I haven't touched it
since. Sounds like something to take up with IBM through your support provider.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
UniVerse itself attempts to do this, through the unohist (user number history)
file.
UniVerse will attempt to assign the same port number that a user (identified by
tty) most recently used. Nothing is guaranteed, however; another user may have
to be granted that port number, in which case the
I forgot to mention in my previous post is that a WRITE of a new record into a
UniVerse/SQL table is regarded as an INSERT.
So the new key generation will occur.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
Here is a UniVerse/SQL answer.
Create the primary key with a default value of NEXT AVAILABLE.
CREATE TABLE MyTable (
MyKey INTEGER NOT NULL PRIMARY KEY DEFAULT NEXT AVAILABLE,
Column1 VARCHAR,
Column2 VARCHAR,
Column3 VARCHAR NOT NULL MULTIVALUED,
Column4 VARCHAR MULTIVALUED,
How to write?
I'd probably go for INSERT statements via the pre-defined @HSTMT statement
handle and the BCI function SQLExecDirect.
That's because the WRITE statement requires a key value.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit
There's the JOBS command.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
The subject DID specify UniVerse.
Given that phantoms are background processes, you should nevertheless be able
to use the UNIX command jobs, which has the same effect.
- Original Message -
From: Bill Haskett [EMAIL PROTECTED]
To: u2-users@listserver.u2ug.org
Subject: RE: [U2]
A little niggle in the back of my brain reminds me - how reliably might be a
problem - that ON ERROR is not supported for Distributed files. Perhaps the
BASIC manual (WRITE statement) is the place to look?
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit
The size of the READU lock table is given by GSEMNUM and RLTABSZ.
But a simple product is not necessarily the maximum number of locks you can
get. It may be smaller.
Imagine that GSEMNUM is the number of columns and RLTABSZ the number of rows in
the lock table.
When a lock needs to be set,
BASIC Programming and Introduction classes are scheduled in Australia and New
Zealand over the next three months or so. Get in touch with IBM Learning
Services or visit their website to get a copy of the schedule (and to enrol).
---
u2-users mailing list
u2-users@listserver.u2ug.org
To
The first biggest difference (in my opinion) is in the internal storage of
data. UniData stores all the keys for a group of records together, with
pointers to the data records within each group. UniVerse stores key+record
key+record key+record... in a linked list.
The second biggest
Don't forget that it was a (genuinely) steam-powered torpedo that sank the
Belgrano when all the high-tech ones had failed.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
Quick checks can be done with the INDICES() function, which can report (like
LIST.INDEX) whether there are deferred updates and whether the index needs
rebuilding.
As for record-level integrity this should be easy to do with a combination of
the SELECTINDEX formats and READV filevar,id,0
Not seen it, but I'm not up to date with releases. Can you map the user IDs
through UV.LOGINS ?
- Original Message -
From: David Jordan [EMAIL PROTECTED]
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] problem with SQL Users
Date: Thu, 3 Apr 2008 15:05:42 +1100
I just
There are some examples in the IBM training class (I think it's called UniVerse
Theory and Practice - anyway, the old internals class).
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
Sounds like a good one to fire at U2AskUs also!
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
Just out of curiosity, because EXECUTE is (may be) handled differently, what is
the account flavor in each case? And have you set any compiler options such as
EXEC.EQ.PERFORM ?
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
That the Select List returned from SELECTINDEX is sorted is only an artifact
resulting from the fact that keys are stored in sorted order in a B-tree index.
Don't forget that you can send the result to any Select List (not just the
default one) and, if desired/necessary, convert it to a dynamic
The sections in the manual and HELP on the A and F conversion codes covers
most of them.
Try HELP CONV A and HELP CONV F to get you started.
The ProVerb manual is still extant, can be downloaded from the IBM web site.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe
Ya left out LIST.INTER, LIST.UNION and LIST.DIFF commands!
These, admittedly, work with saved - rather than active, in-memory - Select
Lists.
- Original Message -
From: Tom Dodds [EMAIL PROTECTED]
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Indexes
Date: Fri, 14 Mar 2008
OCONV(@DATE, DZ) can give you the time zone, at least in UniVerse, and you
can get GMT from the SYSTEM() function. Don't know if that helps a great deal,
but at least you can build someting within U2 and not need a script.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To
The freechain is a pointer in the header of a hashed file that begins a
linked list of free blocks (buffers) that can be used for secondary group
buffers (overflowed groups, oversized record data, etc.) as required.
Each of the buffers on the freechain *should* be marked as free. Somehow a
If all the files are in the same directory, use OPENPATH to open the directory
into a common variable (if it's not already open), then use READV with 0 as the
field number.
FUNCTION DOODLE(DIRPATH,FILENAME)
COMMON /DOODLE/FILEVAR
IF FILEINFO(FILEVAR,0)
ELSE
OPENPATH (DIRPATH)
Do you have a VOC entry for SNIPPETS ?
Is SNIPPETS a Type 1/19 file?
Is there a record called GIVE.FEEDBACK in SNIPPETS ?
Does the compiler time out after a while (say five minutes) or hang
interminably ?
- Original Message -
From: Dennis Bartlett [EMAIL PROTECTED]
To:
The best, and most accurate, answer is it depends.
For B-trees the answer is, indeed, 8kb. For hashed files it's governed by
separation (= group size). For directory-type files (Type 1 or 19) it's
governed by the operating system. And all of that can be confounded by clever
disk controllers
I created a dynamic hashed file. It contains only keys, made up of two
integers (with @TM between).
I then populated this file with lots of keys.
I expected ANALYZE.FILE to show key space and unused space, but it's showing
lots of space for data, even though there is none.
Is what's being
Large Select Lists in UniVerse are saved using multiple files in SAVEDLISTS.
Try doing a large save to learn the naming convention. What you tried explored
- indeed, found - the upper limit on the size of one of those files.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To
Essentially an incomplete install - you need to find the code for LISTFILES (in
BP.O or APP.PROGS.O in the UV account) and globally catalog it.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
We did get it to work during the original UV/SQL training run by Ted Hatch.
I have not tried it since. I do recall that it's quite fiddly to set up.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
There is, of course, the UV.PROMPT command itself, that no-one seems to have
mentioned. However I believe that this restricts you to a single-character
prompt. Unable to verify at the moment.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit
If a file has a trigger then the file has a SICA, which is just an ordinary
secondary buffer in the file structure. There is, of course, a pointer to the
SICA in the file header in this case, but I am not aware that there is anything
in the trigger definition about the schema. Indeed, I doubt
If the schema was created after the account (that is, the CREATE SCHEMA was
executed in an existing account or the HOME option pointed to an existing
account) then the UniVerse account (non-schema) will continue to exist after
the DROP SCHEMA command has been executed. Any UniVerse files (not
UniVerse does not have a timestamp data type. This is at the heart of your
problem.
Find some Microsoft documentation that mentions that MS Query now generates a
timestamp instead of the date it used to generate, and bleat long and loud to
Microsoft about it.
Meanwhile, since that will be
Printer memory segment removed occurs when you attempt to attach to a printer
shared memory segment that was formerly owned by a now logged-out process but
insufficient time has gone by for it to be cleaned up. It's an alert, and may
be safely ignored.
---
u2-users mailing list
The only legal way is DROP SCHEMA followed by CREATE SCHEMA.
- Original Message -
From: David Jordan [EMAIL PROTECTED]
To: u2-users@listserver.u2ug.org
Subject: [U2] Change SCHEMA name in UniVerse SQL
Date: Sun, 3 Feb 2008 10:45:47 +1100
Does anyone know how to change the SQL
INSERT INTO UV.ACCESS_USERS (@ID, USERS) VALUES ('UVRESTORE', 'CHRIS');
- Original Message -
From: LuckY07 [EMAIL PROTECTED]
To: u2-users@listserver.u2ug.org
Subject: [U2] question..
Date: Thu, 31 Jan 2008 06:56:23 -0800 (PST)
Manu,
I appreciate the quick response. I was
You could always hack VMUVADMSUB (or whatever it's called) on the back end so
that unauthorized users of any option just get a disappointing message returned.
- Original Message -
From: Gabriel Green [EMAIL PROTECTED]
To: u2-users@listserver.u2ug.org
Subject: [U2] Restricting
How about using SQL?
SELECT DISTINCT CODE TO SLIST 0 FROM UNNEST filename ON CODE;
(Sorry, don't have the original post open, can't remember the file name.)
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
Are you saying that this technique won't work till version 20.1 is released?
=8^D
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
I don't have access to a real UniVerse site this week, but uv -admin -help
should show you what options are available.
Here's samples from DataStage, which began life as a UniVerse application.
Unfortunately your mail reader is going to foul up the display by line-wrapping
- I leave it to you
OK, looks like us DataStage users are spoiled.
However, the fact that you can invoke uv -admin without getting the errors
reported at the beginning of this thread is some progress. Try it with the -R
option (which is harmless).
- Original Message -
From: Doug Chanco [EMAIL
The great thing about the Pacific Islander languages is their simplicity.
They developed first as spoken language, so when a written alphabet was
attached, it basically follows the every letter is spoken rule. Even better,
they are not tonal languages.
So there are only a few special cases,
What do you get back from uv -admin -info and uv -admin -lic_report
(1) when UniVerse is stopped?
(2) when UniVerse is running?
- Original Message -
From: Doug Chanco [EMAIL PROTECTED]
To: u2-users@listserver.u2ug.org
Subject: [U2] universe errors
Date: Tue, 15 Jan 2008 16:07:45
I have one that is suited to Pacific Islander languages, such as Maori, which
tend to be vowel-heavy.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
Check out the BYTEVAL and BYTETYPE functions.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
This is the collisions count, and it has undergone arithmetic overflow - that
it, it has reached the largest possible integer that can be represented in 31
bits, then been incremented again which causes the sign bit to toggle, now
showing large negative numbers. These, too, will continue to
Not really. And you couldn't call it WHERE because that's a keyword for
UniVerse/SQL.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
Since AD takes the accusative case, it's AD NAUSEAM
(I don't really want to argue JMP instructions, which is all there is once you
get to the compiled code.)
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
IBM has posted the schedule for first half 2008 training on their web sites for
Australia New Zealand.
Last year they did not schedule any U2 training; we made appropriate noises at
U2 University in Sydney, and now they've scheduled some. Please, some of you,
enrol and make it a success.
If you were to convert the file into an SQL table, then you can grant SELECT
privilege (or not) at the individual column level. And/or you can restrict the
table entirely to a single SQL user (at least in UniVerse) and only access it
via programs compiled with the AUTHORIZATION statement.
My
I believe that MASTER OFF sends kill -15 on UNIX.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
A third possibility is to allow GOTO ERROREXIT (single exit point) - or even
RETURN TO ERROREXIT - in error handling code. This substantially reduces the
number of levels of indentation required.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit
Keith, the FOR EACH ROW wording is part of the SQL standard; this clause
identifies/separates this kind of trigger (a row based trigger) from one that
is implemented only once per SQL statement (a statement based trigger)
irrespective of how many rows are processed. Statement based triggers
1 - 100 of 467 matches
Mail list logo