Re: string constants in select
That works great.
Thanks!
----- Original Message -----
From: <ramesh.vasudevan@verizon.com>
To: "Bill Hamilton" <bham@finsco.com>
Cc: "informix-list iiug" <informix-list@iiug.org>;
<owner-informix-list@iiug.org>
Sent: Thursday, August 07, 2003 2:53 PM
Subject: Re: string constants in select
>
> Bill:
>
> You need to rewrite the select as follows:
>
> unload to setR.sql delimiter ";"
> select "alter table " || trim(owner) || "." || trim(tabname) || "
> lock mode(row)"
> from systables where tabid > 99 and locklevel != "R";>
> you will get a sql file with alter statements for all the tables
> that has no Row level lock.
>
> hope this will help to resolve the your problem.
>
sending to informix-list