Save 
Join IIUG
 for   
 

Informix News
29 July 09 - Wall Street Journal - IBM to Acquire SPSS, Adding to Acquisitions... Read
11 February 09 - InformationWeek - IBM Drifts Slowly Toward Mainstream Cloud Computing... Read
11 February 09 - CNNMoney.com - IBM to Deliver Software via Cloud Computing With Amazon Web Services... Read
07 January 09 - Huliq News - IBM Power Servers Helps Bank of Chengdu Build Up Core Banking System.. Read
04 December 08 - Steeleye - Multicarta achieves 99.997% uptime for its Informix-based Credit Card Authorization Centre... Read
16 October 08 - VendorRate - Informix Earns Top Customer Satisfaction Score on VendorRate in Q3... Read
14 August 08 - IIUG.org - Sellout Expected for the 2009 IIUG Informix Conference... Read
29 April 08 - IntelligentEnterprise.com - IBM Informix Upgrade Enhances Clustering, Database Management... Read
29 April 08 - itweek.com - IBM 'Cheetah 2' mauls data costs... Read
28 April 08 - eWeek.com - IBM Uncages Cheetah 2 Data Server... Read
28 April 08 - CNNMoney.com - IBM Helps Clients Reduce Data Management Costs With New Informix Dynamic Server... Read
09 April 08 - CNNMoney.com - MediaSpan Embeds IBM Informix Dynamic Server Software for Delivering News to Print, Web and Wireless Devices... Read
08 April 08 - IT-Director.com - Informix seeks developers... Read
18 February 08 - marketwire.com - Icarus Studios Partners With IBM to Upgrade Performance, Availability for Its Online Games... Read
17 January 08 - eWeek.com - IBM Adds Mac Support to IDS for Higher Education... Read
17 January 08 - informationweek.com - Lotus Notes For iPhone Signals Closer Ties Between IBM, Apple... Read
16 January 08 - marketwire.com - IBM Informix Dynamic Server to Deliver Support for Mac OS X... Read
16 January 08 - internetnews.com - IBM's IDS to Support Mac Platform... Read
28 June 07 - REG Developer - IBM and Informix tie down Cheetah... Read
27 June 07 - CBRonline.com - IBM corrects its own Informix customer figures... Read
14 June 07 - vnunet.com - IBM changes spots with Informix 'Cheetah' database... Read
14 June 07 - eChannelLine - IBM expands scope for IDS... Read
14 June 07 - Resellernews - IBM: Informix database alive and kicking... Read
13 June 07 - DB2 Magazine - Cheetah is now out of the gate... Read
12 June 07 - IBM - IDS 11 release announcement (pdf)... Read
12 June 07 - ChannelWeb Network - IBM Uncages IDS 11, Aka Cheetah, Database... Read
12 June 07 - eWeek.com - IBM's 'Cheetah' Ready to Pounce... Read
12 June 07 - InformationWeek - IBM Unleashes 'Cheetah' Database... Read
12 June 07 - WebWire - IBM Strengthens Database Portfolio With New Informix Dynamic Server... Read
12 June 07 - Intelligent Enterprise - IBM Unveils Informix Upgrade... Read
12 June 07 - ComputerWeekly.com - IBM's Cheetah IDS makes leap to better data centre clustering... Read
12 June 07 - ebiz - IBM Unveils Next Generation Informix Dynamic Server... Read
12 June 07 - computerworld.com - Will 'Cheetah' help IBM's Informix chase down market share?... Read
12 June 07 - Internetnews.com - No Data Can Outrun This 'Cheetah'... Read
12 June 07 - de.internet.com - IBM neuer Datenbank-Server mit Codenamen Cheetah ist fertig... Read
12 June 07 - verifox.de - IBM stärkt Datenbank-Portfolio mit neuem Informix Dynamic Server... Read
12 June 07 - golem.de - Informix 11 vorgestellt... Read
12 June 07 - Computerwoche.de - IBM stellt neue Informix-Version vor... Read
12 June 07 - IBM.de - IBM stärkt Datenbank-Portfolio mit neuem Informix Dynamic Server... Read
12 June 07 - Heise - IBM gibt Informix 11 frei... Read
25 May 07 - Taiwan.CNET.com - Local Taiwan Informix user group established... (Chinese language) ... Read
18 May 07 - ChannelWeb Network - IBM Musters Partners For Cheetah Release... Read
18 May 07 - eWeek.com - IBM Looks to 'Cheetah' to Speed Up Blade Servers... Read
7 May 07 - DB2 Magazine - SQL Shortcuts - Use these tricks to generate IDS SQL scripts... Read


End of Support Dates

RSS Feed: IIUG Forum: Datablade List

More IIUG RSS Feeds

Datablade list is a discussion forum dedicated to the discussion of Informix DataBlades. This is for both users and developers.


URL: http://www.iiug.org/rss/datablade-list.rss

Below is the latest content available from this feed:

Reminder: Please Respond to Balaji's Invitation
Posted by: balavinu14@gmail.com (Balaji Vinu) - Sat, 09 May 2009 12:26:13 EDT
Balaji Vinu wants you to join Yaari!

Is Balaji your friend?

<a
href="http://yaari.com/?controller=user&action=mailregister&friend=1&sign=YaariKOX818NVZ136LVG766XSL839">Yes,
Balaji is my friend!</a> <a
href="http://yaari.com/?controller=user&action=mailregister&friend=0&sign=YaariKOX818NVZ136LVG766XSL839">No,
Balaji isn't my friend.</a>

Please respond or Balaji may think you said no :(

Thanks,
The Yaari Team
<font
color="#505050">-----------------------------------------------------------</font>
<font color="#808080">Yaari Inc., 358 Angier Ave NE Atlanta, GA 30312</font>
<a href="http://yaari.com/?controller=privacy">Privacy Policy</a> | <a
href="http://yaari.com/?controller=absn&action=addoptout&email=datablade-list@iiug.org">Unsubscribe</a>
| <a href="http://yaari.com/?controller=termsofservice&action=index">Terms of
Service</a>

YaariKOX818NVZ136LVG766XSL839




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to datablade-list@iiug.org
2. Include the bracketed message number in the subject line: [241]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Balaji Vinu sent you a Friend Request on Yaari
Posted by: balavinu14@gmail.com (Balaji Vinu) - Wed, 06 May 2009 12:01:32 EDT
Balaji Vinu wants you to join Yaari!

Is Balaji your friend?

<a
href="http://yaari.com/?controller=user&action=mailregister&friend=1&sign=YaariKOX818NVZ136LVG766XSL839">Yes,
Balaji is my friend!</a> <a
href="http://yaari.com/?controller=user&action=mailregister&friend=0&sign=YaariKOX818NVZ136LVG766XSL839">No,
Balaji isn't my friend.</a>

Please respond or Balaji may think you said no :(

Thanks,
The Yaari Team

<font
color="#505050">-----------------------------------------------------------</font>
<font color="#808080">Yaari Inc., 358 Angier Ave NE Atlanta, GA 30312</font>
<a href="http://yaari.com/?controller=privacy">Privacy Policy</a> | <a
href="http://yaari.com/?controller=absn&action=addoptout&email=datablade-list@iiug.org">Unsubscribe</a>
| <a href="http://yaari.com/?controller=termsofservice&action=index">Terms of
Service</a>

YaariKOX818NVZ136LVG766XSL839




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to datablade-list@iiug.org
2. Include the bracketed message number in the subject line: [240]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: mi_prepare() and mi_exec()
Posted by: payned@us.ibm.com (Donald Payne) - Thu, 30 Apr 2009 16:55:28 EDT
Some thoughts [untested]:

- The call to mi_prepare() returns a _pointer_ to MI_STATEMENT, and the
call to mi_exec_prepared_statement() likewise needs a pointer to
MI_STATEMENT. So add an asterisk to the declaration:
MI_STATEMENT *stmt;

- The values array contains one element, a string, for the tabname; the
lengths array contains its length; and the types array contains its SQL
type:
MI_DATUM values[1] = { "mytab" }; /* or whatever table name you want to
select */
mi_integer lengths[1] = { strlen("mytab") };
mi_string types[1] = { "lvarchar" }; /* not sure about this; could be
"char(128)" */
For an example, see

http://publib.boulder.ibm.com/infocenter/idshelp/v115/topic/com.ibm.dapip.doc/sii-08-35520.htm#sii081031562

- The mi_exec_prepared_statement() looks OK.

- After you exec the statement, you need to fetch rows and columns, using:
- mi_get_result() (one call for the one query in your statement)
- mi_next_row() (call in a loop for each row; or since your particular
query should return only one row, you don't need the loop, just call it
once.)
- mi_value() or mi_value_by_name() to fetch each column
See

http://publib.boulder.ibm.com/infocenter/idshelp/v115/topic/com.ibm.dapip.doc/sii-08-39814.htm#sii-08-39814
and click "Next Page" at bottom to get details on each of these steps.

- When done fetching rows, close and drop the prepared statement to free
the cursor and other resources, using mi_close_statement(),
mi_drop_prepared_statement().

- Check the return value of all the DataBlade API (mi_) calls, for any
errors. See the documentation for the individual API calls for possible
return values.

HTH,
- Don

datablade-list-bounces@iiug.org wrote on 04/30/2009 08:20:55 AM:

> Good afternoon,
>
> I am currently attempting to exec and SQL statement within a C UDR. From
the
> IBM documentation I found the following syntax:
>
> MI_STATEMENT stmt;
> MI_DATUM values[1] = { /*??*/ };
> mi_integer lengths[1] = { /* strlen() ?? */ };
> mi_integer nulls[1] = { MI_FALSE };
> mi_string types[1] = { "??" };
>
> stmt = mi_prepare (
>
> conn,
>
> "select * from systables where tabname= ?::lvarchar;",
>
> NULL
> );
> mi_exec_prepared_statement(stmt, 0, MI_FALSE, 1,
>
> values, lengths, nulls, types, 0, NULL);
>
> I am trying to find documentation/examples on what values I should plug
in.
>
> Regards
> Kenneth
>
>
>


>
>




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to datablade-list@iiug.org
2. Include the bracketed message number in the subject line: [239]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

mi_prepare() and mi_exec()
Posted by: kenneth.penza@gov.mt (KENNETH PENZA) - Thu, 30 Apr 2009 08:20:56 EDT
Good afternoon,

I am currently attempting to exec and SQL statement within a C UDR. From the
IBM documentation I found the following syntax:

MI_STATEMENT stmt;
MI_DATUM values[1] = { /*??*/ };
mi_integer lengths[1] = { /* strlen() ?? */ };
mi_integer nulls[1] = { MI_FALSE };
mi_string types[1] = { "??" };

stmt = mi_prepare (

conn,

"select * from systables where tabname= ?::lvarchar;",

NULL
);
mi_exec_prepared_statement(stmt, 0, MI_FALSE, 1,

values, lengths, nulls, types, 0, NULL);

I am trying to find documentation/examples on what values I should plug in.

Regards
Kenneth




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to datablade-list@iiug.org
2. Include the bracketed message number in the subject line: [238]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: spatial module: st_transform problem
Posted by: joluinfante@gmail.com (JORGE INFANTE) - Tue, 28 Apr 2009 14:37:31 EDT
Hi, Robert!

Excuse me for the delay.
Thanks a lot for your response!
I did check your solution (insert into) and works ok for me.
I need more time to check all response, but, I'm impresed for your knowledge
about this. I'll complete the analysis, and reply to.
Another question: Do you have information about books or papers with more
thechnicall information about spatial on informix?. The unique source of
information for me is a pdf "IBM Informix Spatial DataBlade Module - User's
Guide". It is a very complete book, but, I'd like to read more material.

TIA
jorge infante
rosario - santa fe - argentina




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to datablade-list@iiug.org
2. Include the bracketed message number in the subject line: [237]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: spatial module: st_transform problem
Posted by: uleman@us.ibm.com (ROBERT ULEMAN) - Fri, 24 Apr 2009 19:52:41 EDT
Jorge,

Thank you for this question. I'd love to see more traffic on this forum!

Fortunately, this is an easy one. It really helps that you present a complete
test case; thank you for that.

You did everything right, but a tiny typographical error tripped you up. In
the srtext value you insert into the spatial_ref_sys table, you substitute the
WGS 1984 datum for the GRS 1980 datum that actually underlies the POSGAR
projections. I don't know the source of your datum specification (perhaps
copied from the srtext for srid=4?), but the last two digits in the second
spheroid parameter are transposed (_highlights_ inserted): 298.2572235_36_
should be 298.2572235_63_ . When I made that correction, the ST_Transform
function worked for me:

> select st_transform(the_geom, 4) from mytable;

(expression) 4 MULTIPOLYGON (((-60.6447115552 -32.95151404, -60.6447043468
-32.9518464663, -60.6443271611 -32.9519433611, -60.644101185 -32.9516707816,
-60.6443388958 -32.9514054106, -60.6447115552 -32.95151404)))

1 row(s) retrieved.

As you probably know, the ST_Transform() function can only transform data
between spatial reference systems that are defined on the same datum. This is
what "incompatible" in the error message refers to: in this case the datums
were not the same because their definitions differed in those two transposed
digits. Unfortunately, the Spatial DataBlade is not particularly smart about
detecting datum differences: it performs a strict character-based comparison,
not a numeric one based on knowledge of the meaning of each parameter.
Therefore, the character strings must be identical (though I don't know if the
comparison is case-sensitive) and EVEN THE PRESENCE OR ABSENCE OF TRAILING
ZEROS can make the comparison fail. In this case, the numeric values were
actually different, so that needed to be fixed anyway.

A few more comments; these may be arcane to most readers, but I hope some will
find them useful.

As you (Jorge) work for a cadastral agency, you are probably well aware that
there is a difference between the GRS80 and WGS84 geodetic references: the
inverse-flattening spheroid parameters are slightly different. To handle this
properly, a real datum transformation is needed; this requires specialized
software, and the Informix Spatial DataBlade does not provide this. For many
GIS applications, working with data of limited accuracy, the difference is
negligible; but for surveying purposes, it is not. If you know what you're
doing (and it certainly looks like you do) then you are obviously able to make
your own choice whether to accept the discrepancies that may result.

It is certainly not a requirement, but I have found it helpful to choose the
SRID as well as the coordinate offsets and units myself, rather than rely on
the function SE_CreateSRID(). These days, our internal coordinates are
expressed in big (64-bit) integers, so there is almost never a need to
fine-tune the offsets and units for individual project areas; a single choice
will suffice for all uses of a particular coordinate system. In other words,
you can cover the entire earth and still have sub-mm precision. This means
that you can tie each SRS you define one-for-one to the associated EPSG
coordinate reference, which in turn means that you can use the EPSG SRID
(22185, in this case) for your local database SRID as well. That makes it very
easy to keep track of what each SRID stands for, and if applied consistently
gives SRIDs a fixed meaning across multiple databases.

As to the choice of (X,Y) offsets and units, you chose a range of about 5500
km in X and only 45 km in Y. I'm not sure this is right: Transverse Mercator
projections are usually used for regions with a greater north-south extent. In
any case, SE_CreateSRID() produced an offset of -537 km and 5,791 km in X and
Y, respectively, and an xyunits value of over a billion, for a resolution of
less than 1 nm. Perhaps a more widely usable choice would be to follow the
published limits (from spatialreference.org) with very wide margins:
Projected Bounds: 5346660.9906, 5660186.1166, 5653339.0094, 7412332.1438
X offset: -1,000,000 (in case you really want to go west to near-zero
X-values)
Y offset: -1,000,000 (it doesn't hurt to start so far away from any reasonable
coordinates you'll ever encounter)
X/Y units: 1,000,000 (for a resolution of 1 micron)
With this, you still have enough digits to represent positive coordinates in
the billions; you have round numbers in the offsets and units, which makes it
easy to do back-of-the-envelope calculations and estimates in case you suspect
something is wrong; and no matter what kind of buffer operations you do, the
internal coordinate representation will never be a limitation. While it may be
useful at times to have the "coordinate out of range" error alert you to a bug
in a procedure or client, it is generally not a good idea to choose your
limits so tight that this becomes a reliable error trap, because if you ever
wanted to exceed the official bounds for some algorithmic or computational
reason, you would be stuck, with no escape.
With all this, your definition of the projected SRS would use this statement:

INSERT INTO spatial_references (
srid, description, auth_name, auth_srid,
falsex, falsey, xyunits, falsez, zunits, falsem, munits,
srtext
) VALUES (
22185, 'POSGAR 94 / Argentina 5', 'EPSG', 22185,
-1000000, -1000000, 1000000, -1000, 1000, -1000, 1000,
'PROJCS["Gauss_Kruger_Faja5", GEOGCS["GCS_WGS_1984",
DATUM["D_WGS_1984",SPHEROID["WGS_1984",6378137,298.257223563]],PRIMEM["Greenwich",0],UNIT["Degree",0.0174532925199433]],

PROJECTION["Transverse_Mercator"],PARAMETER["False_Easting",5500000.0],PARAMETER["False_Northing",0.0],

PARAMETER["Central_Meridian",-60.0],PARAMETER["Scale_Factor",1.0],PARAMETER["Latitude_of_Origin",-90.0],UNIT["Meter",1.0]]'
);

I hope that I've answered your original question and not made things too
confusing with all the other stuff. Don't hesitate to post further comments or
questions. If you want to take this off-line, you can contact me at the email
address below.

-Robert Uleman
Worldwide Technical Sales
Spatiotemporal Data Management
uleman@us.ibm.com




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to datablade-list@iiug.org
2. Include the bracketed message number in the subject line: [236]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

spatial module: st_transform problem
Posted by: joluinfante@gmail.com (JORGE INFANTE) - Thu, 23 Apr 2009 21:58:43 EDT
Hi, forum!

We are in Rosario, Argentina, working with coordinates transformation, from
utm (meters) to geographic (lat, lon).
Working with the example in the online documentation (Example 2: Projecting
data dynamically), we did generate new records for the tables spatial_ref_sys
and spatial_references.
The steps:
a) Add a record for epsg-22185 (a new srid # 1202):
execute function se_createsrid(8223.64246705, 6335848.41072399,
5459374.50493382, 6380556.86838906, 'POSGAR 94 / Argentina 5');
b) Complete other fields:
update sde.spatial_ref_sys
set auth_name = 'EPSG', auth_srid = 22185, srtext =
'PROJCS["Gauss_Kruger_Faja5", GEOGCS["GCS_WGS_1984", DATUM["D_
WGS_1984",SPHEROID["WGS_1984",6378137,298.257223536]],
PRIMEM["Greenwich",0],UNIT["Degree",0.0174532925199433]],
PROJECTION["Transverse_Mercator"],PARAMETER["False_Easting",5500000.0],
PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-60.0],
PARAMETER["Scale_Factor",1.0],PARAMETER["Latitude_of_Origin",-90.0],
UNIT["Meter",1.0]]' where srid = 1202;
c) Create a new table for put data of Rosario:
create table mytable(se_row_id serial, the_geom st_geometry);
d) Add a record with values in meters:
insert into mytable(the_geom) values('1202 MULTIPOLYGON (((5439716.1698
6354410.48638, 5439717.07569 6354373.62259, 5439752.41517 6354363.09261,
5439773.35028 6354393.44852, 5439750.9494 6354422.73947, 5439716.1698
6354410.48638)))');
e) Try a transformation (meters to grades) of the record, from projection
srid-1202 to srid-4 (epsg-4326, standard):
select st_transform(the_geom, 4) from mytable;

Here, we can see the error:
(USE46) - Incompatible coordinate reference systems in function ST_Transform.
The data in srtext fields are ok.
I'm thinking we have problems with others fields of the spatial_references
table.

Can any help me?

TIA
jorge infante
dirección de catastro
municipalidad de rosario
rosario - santa fe - argentina




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to datablade-list@iiug.org
2. Include the bracketed message number in the subject line: [235]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: Select from table where tablename store in....
Posted by: art.kagel@gmail.com (Art Kagel) - Sat, 28 Mar 2009 21:14:15 EDT
In 9.40 the only way you can do this is to get the Exec Datablade. Dynamic
SQL in stored procedures is not supported directly in IDS until v11.50 and
later.

Art S. Kagel
Oninit (www.oninit.com)
IIUG Board of Directors (art@iiug.org)

Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Oninit, the IIUG, nor any other organization
with which I am associated either explicitly or implicitly. Neither do
those opinions reflect those of other individuals affiliated with any entity
with which I am affiliated nor those of the entities themselves.

On Sat, Mar 28, 2009 at 5:11 AM, ABU ABAIDA <abuabaida@huawei.com> wrote:

> 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 name)
> in
> select statement like this
>
> TempTable = rec_270_200903 //store the table name according to the Month
> 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
>
>
>
>

>
>
>

--00163646c44285265c046637aec5




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to datablade-list@iiug.org
2. Include the bracketed message number in the subject line: [234]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: Select from table where tablename store in....
Posted by: miller3@us.ibm.com (John Miller iii) - Sat, 28 Mar 2009 11:53:58 EDT
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

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



=




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to datablade-list@iiug.org
2. Include the bracketed message number in the subject line: [233]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Select from table where tablename store in a varia
Posted by: abuabaida@huawei.com (ABU ABAIDA) - Sat, 28 Mar 2009 05:11:30 EDT
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 name) in
select statement like this

TempTable = rec_270_200903 //store the table name according to the Month 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




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to datablade-list@iiug.org
2. Include the bracketed message number in the subject line: [232]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: Can't Make / Compile Module
Posted by: jleffler.iiug@gmail.com (Jonathan Leffler) - Sat, 17 May 2008 21:57:47 EDT
Dear Emiliano,

Did you get any answer to this - or have you resolved it on your own?

Have you contacted IBM/Informix Technical Support?

If you've not been successful, you could consider posting to one of
the other mailing lists (I'd suggest ids@iiug.org) or just let me know
and I'll try and get the request to someone who can help.

On Wed, May 7, 2008 at 1:38 PM, Emiliano Romero <eromero@sitrack.com> wrote:
> Hi!, First I want to sorry about my English, I'm from Argentina and my
> English isn't very good.
>
> I'm really new in this stuff of datablade modules. I have a real heavy SPL
> so I want to make it in C to see if it runs faster. I'm trying to use
> dapi/String example in UNIX. I have generated the Datablade with UNIX
> Format. After that I copy all the directory of the proyect to my Linux
> Machine. There, in the src directory I run:
>
> # make -f StringsU.mak
>
> And I get the next result:
>
> mkdir -
> if test "" = "hpux" ; \
>
> then make -f StringsU.mak server ; \
>
> else make -f StringsU.mak server ; \
>
> fi
> make[1]: Entering directory `/home/informix/dbdk/Strings/src'
> cc -DMI_SERVBUILD -I/opt/informix/incl/public -I/opt/informix/incl/esql
> -I/opt/informix/incl -o -/support. -c c/support.c
> cc -DMI_SERVBUILD -I/opt/informix/incl/public -I/opt/informix/incl/esql
> -I/opt/informix/incl -o -/udr. -c c/udr.c
> cc -DMI_SERVBUILD -I/opt/informix/incl/public -I/opt/informix/incl/esql
> -I/opt/informix/incl -o -/CompressedStr. -c c/CompressedStr.c
> o -/Strings. \
>
> -/support. -/udr. -/CompressedStr. \
>
> 2> link.errs
> make[1]: [-/Strings.] Error 127 (ignored)
> if test -x /opt/informix/bin/filtersym.sh ; \
>
> then /opt/informix/bin/filtersym.sh link.errs ; \
>
> else cat link.errs ; \
>
> fi
> awk: cmd. line:1255: else if ($1 == "rtypwidth") {}
> awk: cmd. line:1255: ^ memory exhausted
> make[1]: *** [-/Strings.] Error 1
> make[1]: Leaving directory `/home/informix/dbdk/Strings/src'
> make: *** [all] Error 2
>
> I also try to make a new Project, and try with other Examples and I get the
> same error always. Any clue of what I'm doing wrong? I have search about
> this with no luck.
>
> Any help will be appreciate.
>
> Regards!
>
> Emiliano S. Romero
> Proyect Leader
> Sitrack.com Argentina S.A.
> E-mail: eromero@sitrack.com
>
> This message is for the designated recipient only and may contain
privileged,
> proprietary, or otherwise private information.
> If you have received it in error, please notify the sender immediately and
> delete the original. Any other use of the email by you is prohibited.
>
>
>

>
>
> See you at the IIUG Informix 2008 Conference
> The Power Conference for Informix Professionals
> April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas
> http://www.iiug.org/conf
> Registration Now Open!!
>

--
Jonathan Leffler #include <disclaimer.h>
Email: jleffler@earthlink.net, jleffler@us.ibm.com
Guardian of DBD::Informix v2008.0229 -- http://dbi.perl.org/
"Blessed are we who can laugh at ourselves, for we shall never cease
to be amused."
NB: Please do not use this email for correspondence.
I don't necessarily read it every week, even.




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to datablade-list@iiug.org
2. Include the bracketed message number in the subject line: [231]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Can't Make / Compile Module
Posted by: eromero@sitrack.com (Emiliano Romero) - Wed, 07 May 2008 16:38:44 EDT
Hi!, First I want to sorry about my English, I'm from Argentina and my
English isn't very good.

I'm really new in this stuff of datablade modules. I have a real heavy SPL
so I want to make it in C to see if it runs faster. I'm trying to use
dapi/String example in UNIX. I have generated the Datablade with UNIX
Format. After that I copy all the directory of the proyect to my Linux
Machine. There, in the src directory I run:

# make -f StringsU.mak

And I get the next result:

mkdir -
if test "" = "hpux" ; \

then make -f StringsU.mak server ; \

else make -f StringsU.mak server ; \

fi
make[1]: Entering directory `/home/informix/dbdk/Strings/src'
cc -DMI_SERVBUILD -I/opt/informix/incl/public -I/opt/informix/incl/esql
-I/opt/informix/incl -o -/support. -c c/support.c
cc -DMI_SERVBUILD -I/opt/informix/incl/public -I/opt/informix/incl/esql
-I/opt/informix/incl -o -/udr. -c c/udr.c
cc -DMI_SERVBUILD -I/opt/informix/incl/public -I/opt/informix/incl/esql
-I/opt/informix/incl -o -/CompressedStr. -c c/CompressedStr.c
o -/Strings. \

-/support. -/udr. -/CompressedStr. \

2> link.errs
make[1]: [-/Strings.] Error 127 (ignored)
if test -x /opt/informix/bin/filtersym.sh ; \

then /opt/informix/bin/filtersym.sh link.errs ; \

else cat link.errs ; \

fi
awk: cmd. line:1255: else if ($1 == "rtypwidth") {}
awk: cmd. line:1255: ^ memory exhausted
make[1]: *** [-/Strings.] Error 1
make[1]: Leaving directory `/home/informix/dbdk/Strings/src'
make: *** [all] Error 2

I also try to make a new Project, and try with other Examples and I get the
same error always. Any clue of what I'm doing wrong? I have search about
this with no luck.

Any help will be appreciate.

Regards!

Emiliano S. Romero
Proyect Leader
Sitrack.com Argentina S.A.
E-mail: eromero@sitrack.com

This message is for the designated recipient only and may contain privileged,
proprietary, or otherwise private information.
If you have received it in error, please notify the sender immediately and
delete the original. Any other use of the email by you is prohibited.




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to datablade-list@iiug.org
2. Include the bracketed message number in the subject line: [230]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Can't Make / Compile Module
Posted by: eromero@sitrack.com (EMILIANO ROMERO) - Wed, 07 May 2008 16:21:22 EDT
Hi!, First I want to sorry about my English, I'm from Argentina and my English
isn’t very good.

I’m really new in this stuff of datablade modules. I have a real heavy SPL so
I want to make it in C to see if it runs faster. I’m trying to use dapi/String
example in UNIX. I have generated the Datablade with UNIX Format. After that I
copy all the directory of the proyect to my Linux Machine. There, in the src
directory I run:

# make -f StringsU.mak

And I get the next result:

mkdir -
if test "" = "hpux" ; \

then make -f StringsU.mak server ; \

else make -f StringsU.mak server ; \

fi
make[1]: Entering directory `/home/informix/dbdk/Strings/src'
cc -DMI_SERVBUILD -I/opt/informix/incl/public -I/opt/informix/incl/esql
-I/opt/informix/incl -o -/support. -c c/support.c cc -DMI_SERVBUILD
-I/opt/informix/incl/public -I/opt/informix/incl/esql -I/opt/informix/incl -o
-/udr. -c c/udr.c cc -DMI_SERVBUILD -I/opt/informix/incl/public
-I/opt/informix/incl/esql -I/opt/informix/incl -o -/CompressedStr. -c
c/CompressedStr.c
o -/Strings. \

-/support. -/udr. -/CompressedStr. \

2> link.errs
make[1]: [-/Strings.] Error 127 (ignored)
if test -x /opt/informix/bin/filtersym.sh ; \

then /opt/informix/bin/filtersym.sh link.errs ; \

else cat link.errs ; \

fi
awk: cmd. line:1255: else if ($1 == "rtypwidth") {}
awk: cmd. line:1255: ^ memory exhausted
make[1]: *** [-/Strings.] Error 1
make[1]: Leaving directory `/home/informix/dbdk/Strings/src'
make: *** [all] Error 2

I also try to make a new Project, and try with other Examples and I get the
same error always. Any clue of what I'm doing wrong? I have search about this
with no luck.

Any help will be appreciate.

Regards!

Emiliano S. Romero




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to datablade-list@iiug.org
2. Include the bracketed message number in the subject line: [229]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: update a ifxdocdesc field
Posted by: weiming@us.ibm.com (WEIMING YE) - Thu, 15 Nov 2007 14:37:55 EST
You may find IfxDocDesc type definition from Excalibur Text Search DataBlade
User's Guide (Chapter 4):

CREATE ROW TYPE IfxDocDesc
(
format VARCHAR(18),
version VARCHAR(10),
location LLD_Locator,
params LVARCHAR
);

You will find the example as well.

Hope this help




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to datablade-list@iiug.org
2. Include the bracketed message number in the subject line: [228]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: Excalibur v Verity
Posted by: majp51@yahoo.com (Mark Jamison) - Thu, 15 Nov 2007 14:15:11 EST
Should probably point out that with 11.10 we also now have the option of the
Basic Text Search blade, which may be all you need.

----- Original Message ----
From: WEIMING YE <weiming@us.ibm.com>
To: datablade-list@iiug.org
Sent: Thursday, November 15, 2007 12:59:03 PM
Subject: Re: Excalibur v Verity [226]

Verity DataBlade has already been discontinued and not distributed any
more.
Excalibur Text DataBlade (ETX) is still not only in support but also in

development.

In the past years, ETX has fixed many defects and its performance has
been
improved and will continue to improve. ETX will continue to release new

version with new features.

If you still encounter any performance problem, please contact support
for
help.








* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to datablade-list@iiug.org
2. Include the bracketed message number in the subject line: [227]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: Excalibur v Verity
Posted by: weiming@us.ibm.com (WEIMING YE) - Thu, 15 Nov 2007 13:59:04 EST
Verity DataBlade has already been discontinued and not distributed any more.
Excalibur Text DataBlade (ETX) is still not only in support but also in
development.

In the past years, ETX has fixed many defects and its performance has been
improved and will continue to improve. ETX will continue to release new
version with new features.

If you still encounter any performance problem, please contact support for
help.




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to datablade-list@iiug.org
2. Include the bracketed message number in the subject line: [226]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: RE: Spatial blade compatibility with IDS
Posted by: weiming@us.ibm.com (WEIMING YE) - Thu, 15 Nov 2007 13:42:48 EST
upgrade from 9.40.UC1 to 9.40.UC4 should not impact on using your
spatial.8.11.UC1.

However, like other responses, I have more concern on that you are still using
that "very old" version. Think about this how much time it is behind:
8.11.UC1,...8.20.UC1, 8.20.UC2, 8.21.UC1. I would suggest you to download the
spatial 8.21.UC1, which is the latest version and free download from ibm
website, which included many bugfixes and new features, which support all IDS
9.40, 10, 11 going forward.

Anyway, wish you continue to enjoy using this product.




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to datablade-list@iiug.org
2. Include the bracketed message number in the subject line: [225]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

RE: Spatial blade compatibility with IDS
Posted by: mbadar@esri.com (Mike Badar) - Thu, 15 Nov 2007 10:37:12 EST
I would use the 8.20.UC2 version of the Spatial Datablade; it is
compatible with IDS 9.x, 10.x and 11.x. As OTC said: > blade. Why are
you going for such an old version of the engine?

Mike

> -----Original Message-----
> From: datablade-list-bounces@iiug.org
> [mailto:datablade-list-bounces@iiug.org] On Behalf Of Obnoxio
> The Clown
> Sent: Thursday, November 15, 2007 12:37 AM
> To: datablade-list@iiug.org
> Subject: Re: Spatial blade compatibility with IDS [223]
>
> GULSHAN KUMAR said:
> > Hi Experts,
> >
> > I have a query regarding the compatibility.
> >
> > We are using IDS 9.40 UC1 and having spatial.8.11.UC1
> blade. But now
> > we need to upgrade to IDS 9.40 UC4.
> >
> > Now my query is that whether spatial.8.11.UC1 is also
> compatible with
> > IDS 9.40
> > UC1 or we need to have the upgraded version of spatial.
>
> In general, I would always go for the latest version of the
> blade. Why are you going for such an old version of the engine?
>
> --
> Bye now,
> Obnoxio
>
> "I'm astonished anyone pays real money for this crap."
> -- Cosmo
>
> "Cluster in my trousers"
> -- Guy Bowerman
>
> --
> This message has been scanned for viruses and dangerous
> content by OpenProtect(http://www.openprotect.com), and is
> believed to be clean.
>
>
> * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * **
> * * * * * * * * * * * * * * * * *
>
>
>
>




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to datablade-list@iiug.org
2. Include the bracketed message number in the subject line: [224]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: Spatial blade compatibility with IDS
Posted by: obnoxio@serendipita.com (Obnoxio The Clown) - Thu, 15 Nov 2007 02:37:05 EST
GULSHAN KUMAR said:
> Hi Experts,
>
> I have a query regarding the compatibility.
>
> We are using IDS 9.40 UC1 and having spatial.8.11.UC1 blade. But now we
> need
> to upgrade to IDS 9.40 UC4.
>
> Now my query is that whether spatial.8.11.UC1 is also compatible with IDS
> 9.40
> UC1 or we need to have the upgraded version of spatial.

In general, I would always go for the latest version of the blade. Why are
you going for such an old version of the engine?

--
Bye now,
Obnoxio

"I'm astonished anyone pays real money for this crap."
-- Cosmo

"Cluster in my trousers"
-- Guy Bowerman

--
This message has been scanned for viruses and
dangerous content by OpenProtect(http://www.openprotect.com), and is
believed to be clean.




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to datablade-list@iiug.org
2. Include the bracketed message number in the subject line: [223]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Spatial blade compatibility with IDS
Posted by: gulshank@infotechsw.com (GULSHAN KUMAR) - Wed, 14 Nov 2007 23:42:59 EST
Hi Experts,

I have a query regarding the compatibility.

We are using IDS 9.40 UC1 and having spatial.8.11.UC1 blade. But now we need
to upgrade to IDS 9.40 UC4.

Now my query is that whether spatial.8.11.UC1 is also compatible with IDS 9.40
UC1 or we need to have the upgraded version of spatial.

Please provide your valuable inputs.

Thanks in Advance
Gulshan




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to datablade-list@iiug.org
2. Include the bracketed message number in the subject line: [222]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Hi Experts,

I have a query regarding the compatibility.

We are using IDS 9.40 UC1 and having spatial.8.11.UC1 blade. But now we need
to upgrade to IDS 9.40 UC4.

Now my query is that whether spatial.8.11.UC1 is also compatible with IDS 9.40
UC1 or we need to have the upgraded version of spatial.

Please provide your valuable inputs.

Thanks in Advance
Gulshan




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to datablade-list@iiug.org
2. Include the bracketed message number in the subject line: [222]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

 
Subscribe to this feed
You can subscribe to this RSS feed in a number of ways, including the following:

Drag the orange RSS button into your News Reader

Drag the URL of the RSS feed into your News Reader

Cut and paste the URL of the RSS feed into your News Readerv