Re: SQL status code values

[jared <jhunter@xxxxxxxxxxxx>]

another hit, similar sounding, for the CREATE VIEW statement...

"The type name must be the name of an existing user-defined type (SQLSTATE
42704)"
https://aurora.vcu.edu/db2help/db2s0/frame3.htm#sqls0624

/j

On Fri, 13 Aug 2004, Bob Kohlndorfer wrote:

> Here is something I found with a google search for SQL 42704.
>
> A CONTINUE HANDLER ensures that the SQL procedure will continue if it
> detects SQLSTATE 42704 ("undefined object name"), which DB2 returns from the
> DROP statement if the table does not exist.
>
> found at:
> http://publib.boulder.ibm.com/infocenter/db2v8luw/index.jsp?topic=/com.ibm.db2.udb.doc/ad/c0009170.htm
>
>
> There were many other results from this search.
>
> Hope this helps,
> Bob Kohlndorfer
> ----- Original Message -----
> From: <c.chambers@xxxxxxx>
> To: <midrange-l@xxxxxxxxxxxx>
> Sent: Friday, August 13, 2004 8:25 AM
> Subject: SQL status code values
>
>
> Can - anyone direct me to a list of values returned in the SQLSTATE keyword
> in embedded SQL statements.
>
> Or more specifically what does Status 42704 mean?
>
> I have searched in vain
>
> Regards etc,
>
> Chris
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
>
>
>
>
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
>
>