RSS Feed: IIUG Forum: Datablade List

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

Re: spatial datablade registeration on amazon IDS
Posted by: weiming@us.ibm.com (WEIMING YE) - Sun, 18 Apr 2010 23:56:19 EDT
when you login into remote terminal, did you check if your terminal
environment has setup following variables?

setenv INFORMIXDIR /ix/informix
setenv INFORMIXSQLHOSTS /ix/etc/sqlhosts
setenv ONCONFIG onconfig.mine
setenv INFORMIXSERVER miine

setenv PATH $INFORMIXDIR/bin:$PATH

setenv LD_LIBRARY_PATH $INFORMIXDIR/lib:$INFORMIXDIR/lib/esql:/usr/lib

re-setup the PATH with $INFORMIXIDIR/bin after install.




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

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: [251]

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

spatial datablade registeration on amazon IDS
Posted by: witsunny@gmail.com (MONDAY SUNDAY) - Sat, 17 Apr 2010 20:52:21 EDT
Hi
I am using Ibm informix data server available on Amazon web service.
I want to use spatial datablade over their. From configuration details i got
to know that Spatial datablade is installed their.

Bu using SSH, i can log into the remote terminal, but thing is am not able to
start blade manager or DBAccess.I can see those files in %informix%/bin but
they don't run. It gives me error "command not found".

Does any one know how to register spatial datablade while using IBM IDS on
amazon cloud.

thanks




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

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: [250]

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

Re: mi_process_exec and shared memory
Posted by: jgoldrick@judsonu.edu (JIM GOLDRICK) - Thu, 15 Apr 2010 11:18:42 EDT
>
>
I bet you say that to all the girls!

--
Cheers,
Obnoxio The Clown

True, but for some reason they never understand me.

Anyway, I am now posting from the web.
I would like to start an external process from a trigger. So, I am looking at
the example on mi_process_exec() which is supposed to do a fork (I donÂ’t want
to wait for the process to run). But I would like to make sure that this exec
call will not run in the Informix shared memory. Does anyone know if the
mi_process_exec() will use shared memory?

Also, anyone know why my messages were garbled?

Thanks,

Jim




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

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: [249]

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

Re: mi_process_exec and shared memory
Posted by: obnoxio@serendipita.com (Obnoxio The Clown) - Thu, 15 Apr 2010 11:04:37 EDT
Goldrick, Jim wrote:
> #
> ..•Ùb‘ëh²Ö«µ©ÞÆ׫�©i®‡²Çë¢f­®(
>
z´¨!©¥¢‰"ž­¶žÅ©©•ê'š*k¡Ç¬±ì^sbr¬²êi¢Ç�¶‡hiú+�‡hžÜžÛhÁ¨­~Ší…êk¡Ç¬²Ú+ºpn´Œ(ºWeŠG­¢f¤zË«zØZ¶Øb±ì^qÆ¥—¥–z-®éâžØ^"wè®h±²«yÙžšŠò‡¬j|¨�é'£Ÿ¶¦Ššèqë,{œÂ)eºÇ¬…ªÞvg¦¢¼ˆ¶¬ŠÛ(Âzk¡Ç¬²'n�׫¶®±êçjg¨ž‹«µë-™§!Šw§¢Ò'~Šæ‹
>
>
>

>
>
>
I bet you say that to all the girls!

--
Cheers,
Obnoxio The Clown

http://obotheclown.blogspot.com
I will now proceed to pleasure myself with this fish.

--
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: [248]

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

FW: mi_process_exec and shared memory
Posted by: jgoldrick@judsonu.edu (Goldrick, Jim) - Thu, 15 Apr 2010 10:57:56 EDT
#
..•Ùb‘ëh²Ö«µ©ÞÆ׫�©i®‡²Çë¢f­®( z




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

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: [247]

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

mi_process_exec and shared memory
Posted by: jgoldrick@judsonu.edu (Goldrick, Jim) - Thu, 15 Apr 2010 10:52:57 EDT
#
..•Ùb‘ëh²Ö«µ©ÞÆ׫�©i®‡²Çë¢f­®(
z´¨!©¥¢‰"ž­¶žÅ©©•ê'š*k¡Ç¬±ì^sbr¬²êi¢Ç�¶‡hiú+�‡hžÜžÛhÁ¨­~Ší…êk¡Ç¬²Ú+ºpn´Œ(ºWeŠG­¢f¤zË«zØZ¶Øb±ì^qÆ¥—¥–z-®éâžØ^"wè®h±²«yÙžšŠò‡¬j|¨�é'£Ÿ¶¦Ššèqë,{œÂ)eºÇ¬…ªÞvg¦¢¼ˆ¶¬ŠÛ(Âzk¡Ç¬²'n�׫¶®±êçjg¨ž‹«µë-™§!Šw§¢Ò'~Šæ‹




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

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: [246]

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

Re: phonetic datablade
Posted by: CSA@dk.ibm.com (Claus Samuelsen) - Tue, 23 Mar 2010 11:35:07 EDT
There is a Soundex bladelet. I'm not sure that it is still downloadable,
but you can find all the coding and how to use it in the RedBook
"Customizing Informix Dynamic Server for Your Environment". You can cut
and paste the C coding from the PDF file. It's all in chapter 8.5 and
appendix A.

Med venlig hilsen / Yours sincerely

Claus Samuelsen
Senior IT Specialist
IBM SWG Information Management

phone: +45 2880 3058
e-mail: csa@dk.ibm.com

From:
"BEVIS KENNEDY" <bkennedy@utah.gov>
To:
datablade-list@iiug.org
Date:
23-03-2010 15:30
Subject:
phonetic datablade [242]
Sent by:
datablade-list-bounces@iiug.org

Hi all,

Does anyone know of an existing phonetic datablade?
I have been tasked with coming up with a phonetic search tool. My first
instinct is to see if anyone has already created a datablade for this
purpose.

Thanks in advance.






Medmindre andet er angivet ovenfor: / Unless Otherwise Stated Above:
IBM Danmark ApS
Nymøllevej 91
2800 Kongens Lyngby, Danmark
CVR nr.: 65305216




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

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: [245]

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

Re: phonetic datablade
Posted by: art.kagel@gmail.com (Art Kagel) - Tue, 23 Mar 2010 11:21:43 EDT
A poster yesterday was asking why his UDR that implements soundex works on
one server but not on a second server. Maybe you should contact him for a
copy of the UDR's C soundex function.

Art

Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
IIUG Board of Directors (art@iiug.org)

See you at the 2010 IIUG Informix Conference
April 25-28, 2010
Overland Park (Kansas City), KS
www.iiug.org/conf

Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Advanced DataTools, the IIUG, nor any other
organization with which I am associated either explicitly, implicitly, or by
inference. 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 Tue, Mar 23, 2010 at 10:29 AM, BEVIS KENNEDY <bkennedy@utah.gov> wrote:

> Hi all,
>
> Does anyone know of an existing phonetic datablade?
> I have been tasked with coming up with a phonetic search tool. My first
> instinct is to see if anyone has already created a datablade for this
> purpose.
>
> Thanks in advance.
>
>
>
>

>
>
>

--001517447a42a11f040482795e99




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

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: [244]

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

Re: phonetic datablade
Posted by: obnoxio@serendipita.com (Obnoxio The Clown) - Tue, 23 Mar 2010 10:32:54 EDT
BEVIS KENNEDY wrote:
> Hi all,
>
> Does anyone know of an existing phonetic datablade?
> I have been tasked with coming up with a phonetic search tool. My first
> instinct is to see if anyone has already created a datablade for this
purpose.

ETX Text search and Verity both do this, IIRC. I don't think BTS does,
though.

--
Cheers,
Obnoxio The Clown

http://obotheclown.blogspot.com
I will now proceed to pleasure myself with this fish.

--
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: [243]

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

phonetic datablade
Posted by: bkennedy@utah.gov (BEVIS KENNEDY) - Tue, 23 Mar 2010 10:30:00 EDT
Hi all,

Does anyone know of an existing phonetic datablade?
I have been tasked with coming up with a phonetic search tool. My first
instinct is to see if anyone has already created a datablade for this purpose.

Thanks in advance.




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

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: [242]

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

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]

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