Datablade List Forum

Re: Select from table where tablename store in a v

Posted By: John Miller iii
Date: Saturday, 28 March 2009, at 11:53 a.m.

In Response To: Select from table where tablename store in a varia (ABU ABAIDA)

The ability to execute dynamically SQL statements in stored procedures =
is
a feature which was introduced into version 11. You can compose an SQL=

statement as a string and then execute it.

The exec datablade can also be used to execute dynamic SQL
in stored procedures or you can write a C or JAVA User Defined
Routine (UDR) which can be called from your stored procedure.

John F. Miller III
STSM, Support Architect
miller3@us.ibm.com
503-578-5645
IBM Informix Dynamic Server (IDS)

|------------>
| From: |
|------------>
>--------------------------------------------------------------------=
-----------------------------------------------------------------------=
--|
|"ABU ABAIDA" <abuabaida@huawei.com> =

=
|
>--------------------------------------------------------------------=
-----------------------------------------------------------------------=
--|
|------------>
| To: |
|------------>
>--------------------------------------------------------------------=
-----------------------------------------------------------------------=
--|
|datablade-list@iiug.org =

=
|
>--------------------------------------------------------------------=
-----------------------------------------------------------------------=
--|
|------------>
| Date: |
|------------>
>--------------------------------------------------------------------=
-----------------------------------------------------------------------=
--|
|03/28/2009 02:11 AM =

=
|
>--------------------------------------------------------------------=
-----------------------------------------------------------------------=
--|
|------------>
| Subject: |
|------------>
>--------------------------------------------------------------------=
-----------------------------------------------------------------------=
--|
|Select from table where tablename store in a varia [232] =

=
|
>--------------------------------------------------------------------=
-----------------------------------------------------------------------=
--|
|------------>
| Sent by: |
|------------>
>--------------------------------------------------------------------=
-----------------------------------------------------------------------=
--|
|datablade-list-bounces@iiug.org =

=
|
>--------------------------------------------------------------------=
-----------------------------------------------------------------------=
--|

In My case, The table name is dynamic like rec_270_YYYYMM, I store this=

Table
name into a variable then I want to use this variable(Which has table n=
ame)
in
select statement like this

TempTable =3D rec_270_200903 //store the table name according to the Mo=
nth
and
Year

then I want to use above variable in select statment
Select * from TempTable

I want to implement this task in Informix Version 9.4 DB, I try my best=
but

alwasy I failed. Note I have implement this thing store Procedure

Kindly Guide me to implement and how I can achieve this thing.Any
suggestion

***********************************************************************=
********

Forum Note: Use "Reply" to post a response in the discussion forum.

=

Messages In This Thread

• Select from table where tablename store in a varia
  ABU ABAIDA -- Saturday, 28 March 2009, at 5:11 a.m.
  • Re: Select from table where tablename store in a v
    John Miller iii -- Saturday, 28 March 2009, at 11:53 a.m.
  • Re: Select from table where tablename store in a v
    Art Kagel -- Saturday, 28 March 2009, at 9:14 p.m.

Datablade List Forum is maintained by Administrator with WebBBS 5.12.