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

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

windows-1252?Q52=65=3A=75=70=64=61=74=65=20=61....
Posted by: kagel@bloomberg.net (ART KAGEL, BLOOMBERG/ 731 LEXIN) - Thu, 01 Nov 2007 15:26:33 EDT
This is probably the wrong forum, it more properly belongs in the IDS or
Classics format. That said:

I have no idea what an ifxdocdesc field is, but if you 'UPDATE textolei..' why
specify 'texto.format' and not 'textolei.format'? This isn't even a problem
with correlation names (which BTW are not permitted in UPDATE statements in
Informix), but with using a truncated table name. Since the tablename isn't
needed at all in the WHERE and SET clauses, how about just:

update textolei
set format = 'msword'
where format = 'octet_stream';

Art S. Kagel

----- Original Message -----
From: Fernanda Braz <datablade-list@iiug.org>
To: datablade-list@iiug.org
At: 11/01 15:15:48

I´m trying to update the format field of an ifxdocdesc field.
I´ve used this update command:

update textolei
set texto.format = 'msword'
where texto.format = 'octet_stream'

and got the following message:

522: Table (texto) not selected in query.

Searching the Finderr utility with this error number, I got the following:

"You used a correlation name to qualify a column name in either a GROUP BY
clause or a SET clause. Consider rewriting the statement in an SPL routine
that you then use as the triggered action, passing the column value as an
argument. In any case, you must rewrite the statement without a using a
correlation name in the GROUP BY clause or the SET clause."

How can I update the format field of an ifxdocdesc field?

Thanks in advance.

Fernanda Braz








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

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

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

update a ifxdocdesc field
Posted by: fernanda@cl.df.gov.br (FERNANDA BRAZ) - Thu, 01 Nov 2007 15:15:24 EDT
I´m trying to update the format field of an ifxdocdesc field.
I´ve used this update command:

update textolei
set texto.format = 'msword'
where texto.format = 'octet_stream'

and got the following message:

522: Table (texto) not selected in query.

Searching the Finderr utility with this error number, I got the following:

"You used a correlation name to qualify a column name in either a GROUP BY
clause or a SET clause. Consider rewriting the statement in an SPL routine
that you then use as the triggered action, passing the column value as an
argument. In any case, you must rewrite the statement without a using a
correlation name in the GROUP BY clause or the SET clause."

How can I update the format field of an ifxdocdesc field?

Thanks in advance.

Fernanda Braz




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

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

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

Re: DOUBT IN INFORMIX
Posted by: jleffler.iiug@gmail.com (Jonathan Leffler) - Fri, 12 Oct 2007 00:43:25 EDT
On 9/27/07, Link, David A <DALink@west.com> wrote:
> The easiest way to do it is to put a BEGIN WORK; and COMMIT WORK; around
> the the 2 insert statements. Both inserts then will have to succeed in
> order for the unit of work to be committed to the database.

That would be true except that DB-Access largely ignores errors,
unless you tell it not to by setting DBACCNOIGN in the environment.

Or use SQLCMD; one of the reasons it was written was to deal with that
problem.

>
> -----Original Message-----
> From: datablade-list-bounces@iiug.org
> [mailto:datablade-list-bounces@iiug.org] On Behalf Of balaji vinu
> Sent: Thursday, September 27, 2007 12:21 AM
> To: datablade-list@iiug.org
> Subject: Fwd: DOUBT IN INFORMIX [216]
>
> ---------- Forwarded message ----------
> From: balaji vinu <balavinu14@gmail.com>
> Date: Sep 27, 2007 10:25 AM
> Subject: DOUBT IN INFORMIX
> To: informix-list@iiug.org
>
> I am working in Informix and writing a UNIX shell script to insert data
> into a table.
>
> For eg:
>
> #!/bin/ksh
>
> ... ~dfsipc12/bin/hdsenv.sh
>
> hdsenv TEST
>
> dbaccess report_test@cmisdv_sc_tcp<<!
>
> insert into abc values(1);
>
> insert into abc values(2);
>
> !
>
> If there is any exception in the second insert query I want to ROLLBACK
> the
> transaction in such a way that the first insert query should also be
> rolled back.
> Could you please share some idea HOW TO USE EXCEPTIONS IN INFORMIX SO
> THAT I
> CAN ROLLBACK OR COMMIT the transactions.
>
> And also how to use exception in STORED PROCEDURE in INFORMIX..

--
Jonathan Leffler #include <disclaimer.h>
Email: jleffler@earthlink.net, jleffler@us.ibm.com
Guardian of DBD::Informix v2007.0914 -- http://dbi.perl.org/
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: [219]

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

RE: DOUBT IN INFORMIX
Posted by: DALink@west.com (Link, David A) - Thu, 27 Sep 2007 09:06:01 EDT
The easiest way to do it is to put a BEGIN WORK; and COMMIT WORK; around
the the 2 insert statements. Both inserts then will have to succeed in
order for the unit of work to be committed to the database.

David

-----Original Message-----
From: datablade-list-bounces@iiug.org
[mailto:datablade-list-bounces@iiug.org] On Behalf Of balaji vinu
Sent: Thursday, September 27, 2007 12:21 AM
To: datablade-list@iiug.org
Subject: Fwd: DOUBT IN INFORMIX [216]

---------- Forwarded message ----------
From: balaji vinu <balavinu14@gmail.com>
Date: Sep 27, 2007 10:25 AM
Subject: DOUBT IN INFORMIX
To: informix-list@iiug.org

I am working in Informix and writing a UNIX shell script to insert data
into
a table.

For eg:

#!/bin/ksh

... ~dfsipc12/bin/hdsenv.sh

hdsenv TEST

dbaccess report_test@cmisdv_sc_tcp<<!

insert into abc values(1);

insert into abc values(2);

!

If there is any exception in the second insert query I want to ROLLBACK
the
transaction in such a way that the first insert query should also be
rolled
back.
Could you please share some idea HOW TO USE EXCEPTIONS IN INFORMIX SO
THAT I
CAN ROLLBACK OR COMMIT the transactions.

And also how to use exception in STORED PROCEDURE in INFORMIX..

Thanks,

Balaji Vinu

--
no me "NO" life know me "KNOW" life

--
no me "NO" life know me "KNOW" life

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





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

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

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

Re: Fwd: DOUBT IN INFORMIX
Posted by: obnoxio@serendipita.com (Obnoxio The Clown) - Thu, 27 Sep 2007 02:42:14 EDT
balaji vinu said:
> ---------- Forwarded message ----------
> From: balaji vinu <balavinu14@gmail.com>
> Date: Sep 27, 2007 10:25 AM
> Subject: DOUBT IN INFORMIX
> To: informix-list@iiug.org
>
> I am working in Informix and writing a UNIX shell script to insert data
> into
> a table.
>
> For eg:
>
> #!/bin/ksh
>
> .. ~dfsipc12/bin/hdsenv.sh
>
> hdsenv TEST
>
> dbaccess report_test@cmisdv_sc_tcp<<!
>
> insert into abc values(1);
>
> insert into abc values(2);
>
> !
>
> If there is any exception in the second insert query I want to ROLLBACK
> the
> transaction in such a way that the first insert query should also be
> rolled
> back.
> Could you please share some idea HOW TO USE EXCEPTIONS IN INFORMIX SO THAT
> I
> CAN ROLLBACK OR COMMIT the transactions.
>
> And also how to use exception in STORED PROCEDURE in INFORMIX..

RTFM?

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

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

Fwd: DOUBT IN INFORMIX
Posted by: balavinu14@gmail.com (balaji vinu) - Thu, 27 Sep 2007 01:21:30 EDT
---------- Forwarded message ----------
From: balaji vinu <balavinu14@gmail.com>
Date: Sep 27, 2007 10:25 AM
Subject: DOUBT IN INFORMIX
To: informix-list@iiug.org

I am working in Informix and writing a UNIX shell script to insert data into
a table.

For eg:

#!/bin/ksh

.. ~dfsipc12/bin/hdsenv.sh

hdsenv TEST

dbaccess report_test@cmisdv_sc_tcp<<!

insert into abc values(1);

insert into abc values(2);

!

If there is any exception in the second insert query I want to ROLLBACK the
transaction in such a way that the first insert query should also be rolled
back.
Could you please share some idea HOW TO USE EXCEPTIONS IN INFORMIX SO THAT I
CAN ROLLBACK OR COMMIT the transactions.

And also how to use exception in STORED PROCEDURE in INFORMIX..

Thanks,

Balaji Vinu

--
no me "NO" life know me "KNOW" life

--
no me "NO" life know me "KNOW" life




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

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

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

unsubscribe
Posted by: todhsals@hotmail.com (todh sals) - Thu, 19 Jul 2007 09:56:21 EDT
_________________________________________________________________
PC Magazine’s 2007 editors’ choice for best web mail—award-winning Windows
Live Hotmail.

http://imagine-windowslive.com/hotmail/?locale=en-us&ocid=TXT_TAGHM_migration_HMWL_mini_pcmag_0707




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

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

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

Re: onspaces error
Posted by: jleffler.iiug@gmail.com (Jonathan Leffler) - Thu, 07 Jun 2007 13:08:12 EDT
Forwarding on behalf of Guy Bowerman.
Thank you for generating the answer (or follow-up suggestions), Guy.

The original question - at the bottom of the message - was posted on
the datablade list; it is better treated on the IDS list. Please
exclude datablade-list@iiug.org from responses to this message, and
only follow-up on the ids@iiug.org list.

===============

From: "Guy" <gbowerman@yahoo.com>
Subject: Re: onspaces error... [212]

Hi,

Assuming you rule out permissions problems with the onconfig file, are
you logged in via Remote Desktop? Do you get the same error when
logged in directly?

Can you run regedit and check this Registry value:


HKEY_LOCAL_MACHINE\Software\Informix\Online\%INFORMIXSERVER%\Environment\ONCONFIG

based on the INFORMIXSERVER value set in the command line environment?

I wouldn't really expect this value to be wrong or you'd have problems
running other commands.

Thanks
Guy

ps I am not on this alias, Jonathan was kind enough to forward the
mail, please include the ids alias in the reply.

Jonathan Leffler wrote:

Dear CJ,

I'm not convinced this is the best mailing list for this question - it
probably belongs on the ids@iiug.org mailing list instead.

Have you looked at the full ACL (all the permissions) on the path
%INFORMIXDIR%/etc/%ONCONFIG%?

On 6/4/07, CJ BUTCHER <creighton_butcher@adaptec.com> wrote:
> I've run into a little problem and am hoping someone out there might help.
I'm
> trying to add some space to my database. When I run the following command:
>
> onspaces -a psapstab -p D:\informix\LPR\sapdata\psapstab.005 -o 0 -s 1024000
>
> I get the following message:
>
> WARNING: Cannot access configuration file $INFORMIXDIR/etc/$ONCONFIG.
>
> This is amy production DB server, running informix 9.4 with the latest
> patches. I'm on a windows 2003 server, the database is up and running
> correctly. The %INFORMIXDIR% and %ONCONFIG% variables have the correct
values
> in them. I'm logged in as informix when I try to run the command. I have
> plenty of disk space in the supplied location. I was able to add a chunk to
a
> different dbspace a few weeks ago, but could not when I wanted needed to
last
> week. I get the same error is I type onspaces with no arguments just trying
to
> look at help on this server. onstat, onmode and others seem to work fine.
>
> All the reading/searching of done over the last few days has not pointed me
to
> any solution. Any thoughts????

Who's Amy? :-)

--
Jonathan Leffler #include <disclaimer.h>
Email: jleffler@earthlink.net, jleffler@us.ibm.com
Guardian of DBD::Informix v2007.0226 -- http://dbi.perl.org/
NB: Please do not use the jleffler.iiug@gmail.com 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: [214]

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

Re: onspaces error...
Posted by: jleffler.iiug@gmail.com (Jonathan Leffler) - Thu, 07 Jun 2007 00:26:26 EDT
Dear CJ,

I'm not convinced this is the best mailing list for this question - it
probably belongs on the ids@iiug.org mailing list instead.

Have you looked at the full ACL (all the permissions) on the path
%INFORMIXDIR%/etc/%ONCONFIG%?

On 6/4/07, CJ BUTCHER <creighton_butcher@adaptec.com> wrote:
> Hi All,
>
> I've run into a little problem and am hoping someone out there might help.
I'm
> trying to add some space to my database. When I run the following command:
>
> onspaces -a psapstab -p D:\informix\LPR\sapdata\psapstab.005 -o 0 -s 1024000
>
> I get the following message:
>
> WARNING: Cannot access configuration file $INFORMIXDIR/etc/$ONCONFIG.
>
> This is amy production DB server, running informix 9.4 with the latest
> patches. I'm on a windows 2003 server, the database is up and running
> correctly. The %INFORMIXDIR% and %ONCONFIG% variables have the correct
values
> in them. I'm logged in as informix when I try to run the command. I have
> plenty of disk space in the supplied location. I was able to add a chunk to
a
> different dbspace a few weeks ago, but could not when I wanted needed to
last
> week. I get the same error is I type onspaces with no arguments just trying
to
> look at help on this server. onstat, onmode and others seem to work fine.
>
> All the reading/searching of done over the last few days has not pointed me
to
> any solution. Any thoughts????
>
> Thank in advance,
>
> CJ
>
>
>

>
>
>

--
Jonathan Leffler #include <disclaimer.h>
Email: jleffler@earthlink.net, jleffler@us.ibm.com
Guardian of DBD::Informix v2007.0226 -- http://dbi.perl.org/
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: [213]

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

onspaces error...
Posted by: creighton_butcher@adaptec.com (CJ BUTCHER) - Mon, 04 Jun 2007 12:13:55 EDT
Hi All,

I've run into a little problem and am hoping someone out there might help. I'm
trying to add some space to my database. When I run the following command:

onspaces -a psapstab -p D:\informix\LPR\sapdata\psapstab.005 -o 0 -s 1024000

I get the following message:

WARNING: Cannot access configuration file $INFORMIXDIR/etc/$ONCONFIG.

This is amy production DB server, running informix 9.4 with the latest
patches. I'm on a windows 2003 server, the database is up and running
correctly. The %INFORMIXDIR% and %ONCONFIG% variables have the correct values
in them. I'm logged in as informix when I try to run the command. I have
plenty of disk space in the supplied location. I was able to add a chunk to a
different dbspace a few weeks ago, but could not when I wanted needed to last
week. I get the same error is I type onspaces with no arguments just trying to
look at help on this server. onstat, onmode and others seem to work fine.

All the reading/searching of done over the last few days has not pointed me to
any solution. Any thoughts????

Thank in advance,

CJ




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

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

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