Re: DB2 RAISE_ERROR equivalent in IDS

Manas Dadarkar said: > > Hi, > I am trying to find out if the DB2 RAISE_ERROR function can be > implemented in IDS. The description of the function from the DB2 > documentation is as follows > > *The RAISE_ERROR function causes the statement that includes the function > to > return an error with the specified SQLSTATE, SQLCODE -438, and > diagnostic-string.* > ** > Any ideas, suggestions welcome. Doesn't *anybody* RTFM any more? RAISE EXCEPTION? -- Bye now, Obnoxio "C'est pas parce qu'on n'a rien ` dire qu'il faut fermer sa gueule" - Coluche did i mention i like nulls? heck, i even go so far as to say that all columns in a table except the primary key could/should be nullable. this has certain advantages, for example, if you need to insert a child record and you don't have a parent row for it, just do an insert into the parent table with the primary key value (everything else null), and voila, relational integrity is preserved. but this is, admittedly, a bit controversial among modellers. --r937, dbforums.com sending to informix-list

Obnoxio The Clown wrote: > Manas Dadarkar said: > >>Hi, >> I am trying to find out if the DB2 RAISE_ERROR function can be >>implemented in IDS. The description of the function from the DB2 >>documentation is as follows >> >>*The RAISE_ERROR function causes the statement that includes the function >>to >>return an error with the specified SQLSTATE, SQLCODE -438, and >>diagnostic-string.* >>** >>Any ideas, suggestions welcome. > > > Doesn't *anybody* RTFM any more? RAISE EXCEPTION? > And they don't even bother googling for "informix raise error"