Re: [U2] [UV] SQL DELETE on type 19 file

Interesting. A LIST.SICA before and after an SQL DELETE on a type 18 file both report not an SQL file. So are you saying a DELETE or an INSERT will build a temporary SICA for the file and then remove it at the end of the operation? On Apr 6, 2005, at 21:32, Ray Wurlod wrote: True, but there IS

[U2] UDT SYSTEM(49) = UV ???

Is there an equivalent function to the Unidata SYSTEM(49) [return the current call stack] under Universe? -Kevin HYPERLINK mailto:[EMAIL PROTECTED][EMAIL PROTECTED] http://www.PrecisOnline.com -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus

[U2] UV Triggers

I am making my first foray into Universe triggers having knowledge only of how it works with Unidata and the Universe documentation, and am having a devil of a time. Is it a requirement that in Universe, the file must be created via SQL in order to put triggers on it? And then what of this

RE: [U2] UDT SYSTEM(49) = UV ??? {Unclassified}

Kevin, System(1009) But the data is very strangely formatted, someone contributed a subroutine to display it nicely, see the list archives Mike -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kevin King Sent: Friday, 8 April 2005 08:48 To:

RE: [U2] UDT SYSTEM(49) = UV ???

Or 9001 as of UV 10.1 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bob Woodward Sent: Thursday, April 07, 2005 2:18 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UDT SYSTEM(49) = UV ??? The global variable @COMMAND.STACK should be what you're

RE: [U2] UDT SYSTEM(49) = UV ???

No, that's the command stack, not the call stack. I checked that out, and it's just like .L from the TCL prompt. That won't help me, I am hoping to find a way to get the subroutines that called subroutines that have finally culminated in the execution of a trigger. -Original Message-

Re: [U2] [UV] SQL DELETE on type 19 file

I have no idea, Clif. It may. It may only check for the existence of a file header with the magic number. Or it may simply check the file type. I had ceased to be an employee by the time SQL on files became available, so no longer any access to under the covers technical info. In any case,

RE: [U2] UDT SYSTEM(49) = UV ??? {Unclassified}

That's giving me 24 - nothing else. This is UV9.6 if that makes a diff. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of HENDERSON MIKE, MR Sent: Thursday, April 07, 2005 3:46 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UDT SYSTEM(49) = UV ???

RE: [U2] UDT SYSTEM(49) = UV ??? {Unclassified}

Thanks, but apparently not on this version. 9001 returns 0 on this version. Dang, dang, dang. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of HENDERSON MIKE, MR Sent: Thursday, April 07, 2005 3:49 PM To: u2-users@listserver.u2ug.org Subject: FW: [U2]

RE: [U2] UV Triggers

Thanks so much, but here's what I'm getting as a response: Universe/SQL: You must create a schema before you may create SQL tables. -Kevin [EMAIL PROTECTED] http://www.PrecisOnline.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Martin Canty Sent:

Re: [U2] UV Triggers

The correct syntax should be: CREATE.TRIGGER trigger_name [BEFORE | AFTER] UPDATE ON file_name FOR EACH ROW CALLING 'subroutine'; Note the semi-colon. All SQL commands end with one. Failure to include it will result in the SQL+ prompt that you got. The file does not have to be an SQL table,

RE: [U2] UV Triggers

Kevin, What version of UV are you using? Before 10.x, in order to have triggers files did have to be SQL-ized; however from 10.0 on you can put a trigger on an ordinary file of types 2-18 and 30. Your syntax difficulty is most likely a missing semi-colon (;) at the end of the statement - bites

RE: [U2] UDT SYSTEM(49) = UV ???

You're right. Guess I better slow my reading down before I reply back. Sorry. BobW -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of Kevin King Sent: Thursday, April 07, 2005 2:55 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UDT

[U2] Removing bad item

I know Ray Wurlod had a way of achieving this - but I cannot find it. UniVerse 9.6 on NT has a record with a % in the ID. I can select the item but not delete it, or do anything else with it. Does anyone have Ray's nice little SQL statement which will rid me of this record. I suspect it got

Re: [U2] Removing bad item

Sara, You can delete it by using quotation marks. Double-quotes should do the trick. Regards, LeRoy F. Dreyfuss Product Manager IBM UniVerse and UniData (U2) Extended Relational Databases IBM Information Management Software Tel: 303-672-1254 Fax: 303-294-4832 Mobile: 720-341-4317