RSS Feed: IIUG Forum: Development Tools

Development Tools is a forum for discussion of Informix-related development tools and applications.

RE: Genero Studio vs Querix LyciaStudio
Posted by: ddk@fidelity-soft.be (Danny DE KOSTER) - Fri, 20 Jan 2012 04:21:36 EST
Hi Guys,

We are now starting a new application and we are using Genero Studio for a
couple of months.
Are there many people who are using Querix? Are there people who have been
using both of them? What is the best tool?
Thanks for any reactions.

Met vriendelijke groeten / Sincères salutations / Kinds regards,

Danny De Koster

FIDELITY SOFT nv
Cardijnstraat 5
1980 Eppegem

Tel: 015/618.270
Fax: 015/616.052

-----Oorspronkelijk bericht-----
Van: development-tools-bounces@iiug.org
[mailto:development-tools-bounces@iiug.org] Namens ERIC VERCELLETTO
Verzonden: woensdag 18 januari 2012 16:51
Aan: development-tools@iiug.org
Onderwerp: Re: Genero Studio vs Querix LyciaStudio [747]

Hi Pravin,

just to confirm Art K's settlements; I became a great fan of Lycia: they have
the right software architecture, easily scalable, they have the right way (
well, for me ) on how to extend the 4GL IDE, ie the graphical extensions are
linked with the forms ( ex .per files) , and not to the source code ( ex .4gl
files).

Those guys have great ideas for the upcoming features and really know how to
implement them efficently. One among all is the possibilty to invoke Java
methods directly from the 4GL application. Many more coming !

Another strong argument is Lycia's dev and runtime pricing and, in case your
are an Informix passionate as I am, the Querix staff will never try
proactively to sell you a migration to Oracle services package!

Regards,
Eric








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

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

1. Address it to development-tools@iiug.org
2. Include the bracketed message number in the subject line: [748]

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

Re: Genero Studio vs Querix LyciaStudio
Posted by: eric.vercelletto@begooden-it.com (ERIC VERCELLETTO) - Wed, 18 Jan 2012 10:50:37 EST
Hi Pravin,

just to confirm Art K's settlements; I became a great fan of Lycia: they have
the right software architecture, easily scalable, they have the right way (
well, for me ) on how to extend the 4GL IDE, ie the graphical extensions are
linked with the forms ( ex .per files) , and not to the source code ( ex .4gl
files).

Those guys have great ideas for the upcoming features and really know how to
implement them efficently. One among all is the possibilty to invoke Java
methods directly from the 4GL application. Many more coming !

Another strong argument is Lycia's dev and runtime pricing and, in case your
are an Informix passionate as I am, the Querix staff will never try
proactively to sell you a migration to Oracle services package!

Regards,
Eric




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

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

1. Address it to development-tools@iiug.org
2. Include the bracketed message number in the subject line: [747]

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

Re: add a serial column to exsisting table
Posted by: art.kagel@gmail.com (Art Kagel) - Fri, 06 Jan 2012 10:47:06 EST
Create a sequence then update the columns using the sequence's next
function.

Art

Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
Blog: http://informix-myview.blogspot.com/

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 Fri, Jan 6, 2012 at 3:47 AM, ANIS JAZIRI <jaziri.anis@hotmail.com> wrote:

> Hello,
> We need your help please,
> Sorry, but it's very urgent.
> We have a table count arround 700 000 rows.
> we need to add to this table a serial column.
> I have this error:
> -287 Cannot add serial column column-name to table.
>
> But, I discover a solution for it:
> You can add a serial column in three steps:
> 1-Add the column with an INTEGER data type.
> 2-Update the table with nonnull, unique values in each row of the new
> column.
> 3-ALTER TABLE MODIFY to change the data type of the column to SERIAL.
>
> I found a problem to resolve point number two, we need to insert fill the
> added column by a sequence of unique integer number (like serial)
>
> May I have a solution for it, please?
>
>
>
>

>
>
>

--bcaec51a8672a3fa6704b5ddf5a8




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

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

1. Address it to development-tools@iiug.org
2. Include the bracketed message number in the subject line: [746]

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

RE: add a serial column to exsisting table
Posted by: douglawry@hotmail.com (Doug Lawry) - Fri, 06 Jan 2012 06:03:39 EST
Nice solution unless the table is too big and you get long transaction
aborted. You would want at least to lock the table exclusively to avoid an
explosion in shared memory allocated to locks, or change the table type to
RAW if supported and not replicated.

Regards,
Doug Lawry

-----Original Message-----
From: development-tools-bounces@iiug.org
[mailto:development-tools-bounces@iiug.org] On Behalf Of Claus Samuelsen
Sent: 06 January 2012 10:39
To: development-tools@iiug.org
Subject: Re: add a serial column to exsisting table [744]

create sequence new_order
increment by 1 start with 1;

create table t1 (col1 int, col2 int);

insert into t1 values (0,0);
insert into t1 values (0,0);

update t1
set col1 = new_order.nextval;

med venlig hilsen
Claus Samuelsen
IBM SWG Information Management
Phone: +45 2880 3058
E-mail: csa@dk.ibm.com

From: "ANIS JAZIRI" <jaziri.anis@hotmail.com>
To: development-tools@iiug.org,
Date: 06-01-2012 09:47
Subject: add a serial column to exsisting table [740]
Sent by: development-tools-bounces@iiug.org

Hello,
We need your help please,
Sorry, but it's very urgent.
We have a table count arround 700 000 rows.
we need to add to this table a serial column.
I have this error:
-287 Cannot add serial column column-name to table.

But, I discover a solution for it:
You can add a serial column in three steps:
1-Add the column with an INTEGER data type.
2-Update the table with nonnull, unique values in each row of the new
column.
3-ALTER TABLE MODIFY to change the data type of the column to SERIAL.

I found a problem to resolve point number two, we need to insert fill the
added column by a sequence of unique integer number (like serial)

May I have a solution for it, please?

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



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 development-tools@iiug.org
2. Include the bracketed message number in the subject line: [745]

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

Re: add a serial column to exsisting table
Posted by: CSA@dk.ibm.com (Claus Samuelsen) - Fri, 06 Jan 2012 05:38:52 EST
create sequence new_order
increment by 1 start with 1;

create table t1 (col1 int, col2 int);

insert into t1 values (0,0);
insert into t1 values (0,0);

update t1
set col1 = new_order.nextval;

med venlig hilsen
Claus Samuelsen
IBM SWG Information Management
Phone: +45 2880 3058
E-mail: csa@dk.ibm.com

From: "ANIS JAZIRI" <jaziri.anis@hotmail.com>
To: development-tools@iiug.org,
Date: 06-01-2012 09:47
Subject: add a serial column to exsisting table [740]
Sent by: development-tools-bounces@iiug.org

Hello,
We need your help please,
Sorry, but it's very urgent.
We have a table count arround 700 000 rows.
we need to add to this table a serial column.
I have this error:
-287 Cannot add serial column column-name to table.

But, I discover a solution for it:
You can add a serial column in three steps:
1-Add the column with an INTEGER data type.
2-Update the table with nonnull, unique values in each row of the new
column.
3-ALTER TABLE MODIFY to change the data type of the column to SERIAL.

I found a problem to resolve point number two, we need to insert fill the
added column by a sequence of unique integer number (like serial)

May I have a solution for it, please?






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 development-tools@iiug.org
2. Include the bracketed message number in the subject line: [744]

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

Re: RE: add a serial column to exsisting table
Posted by: jaziri.anis@hotmail.com (ANIS JAZIRI) - Fri, 06 Jan 2012 04:47:10 EST
Thank you for quickly response.
I am a beginner in informix.
I'am using Sql-WorkBench to manage Informix dataBase.
You think that is possible to execute this procedure on it.
I hope so.
If it's impossible, where shell i execute or what's the editor which allow me
to execute such procedure.

Thank you again for your assistance




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

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

1. Address it to development-tools@iiug.org
2. Include the bracketed message number in the subject line: [743]

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

RE: add a serial column to exsisting table
Posted by: douglawry@hotmail.com (Doug Lawry) - Fri, 06 Jan 2012 04:42:15 EST
Trying again in HTML as indentation was removed from plain text by the
server J

-----Original Message-----
From: development-tools-bounces@iiug.org
[mailto:development-tools-bounces@iiug.org] On Behalf Of Doug Lawry
Sent: 06 January 2012 09:39
To: development-tools@iiug.org
Subject: RE: add a serial column to exsisting table [741]

CREATE TABLE test_table (contents VARCHAR(255));

INSERT INTO test_table VALUES ('one');

INSERT INTO test_table VALUES ('two');

INSERT INTO test_table VALUES ('three');

ALTER TABLE test_table ADD unique_id INT BEFORE contents;

CREATE PROCEDURE update_serial()

DEFINE v_rowid INT;

DEFINE v_serial INT;

LET v_serial = 1;

FOREACH SELECT ROWID INTO v_rowid FROM test_table

UPDATE test_table SET unique_id = v_serial WHERE ROWID = v_rowid;

LET v_serial = v_serial + 1;

END FOREACH;

END PROCEDURE;

EXECUTE PROCEDURE update_serial();

ALTER TABLE test_table MODIFY unique_id SERIAL NOT NULL;

CREATE UNIQUE INDEX i_unique_id ON test_table (unique_id);

Regards,

Doug Lawry

-----Original Message-----

From: <mailto:development-tools-bounces@iiug.org>
development-tools-bounces@iiug.org

<mailto:[mailto:development-tools-bounces@iiug.org]>
[mailto:development-tools-bounces@iiug.org] On Behalf Of ANIS JAZIRI

Sent: 06 January 2012 08:47

To: <mailto:development-tools@iiug.org> development-tools@iiug.org

Subject: add a serial column to exsisting table [740]

Hello,

We need your help please,

Sorry, but it's very urgent.

We have a table count arround 700 000 rows.

we need to add to this table a serial column.

I have this error:

-287 Cannot add serial column column-name to table.

But, I discover a solution for it:

You can add a serial column in three steps:

1-Add the column with an INTEGER data type.

2-Update the table with nonnull, unique values in each row of the new

column.

3-ALTER TABLE MODIFY to change the data type of the column to SERIAL.

I found a problem to resolve point number two, we need to insert fill the

added column by a sequence of unique integer number (like serial)

May I have a solution for it, please?

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






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

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

1. Address it to development-tools@iiug.org
2. Include the bracketed message number in the subject line: [742]

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

RE: add a serial column to exsisting table
Posted by: douglawry@hotmail.com (Doug Lawry) - Fri, 06 Jan 2012 04:38:34 EST
CREATE TABLE test_table (contents VARCHAR(255));

INSERT INTO test_table VALUES ('one');
INSERT INTO test_table VALUES ('two');
INSERT INTO test_table VALUES ('three');

ALTER TABLE test_table ADD unique_id INT BEFORE contents;

CREATE PROCEDURE update_serial()

DEFINE v_rowid INT;

DEFINE v_serial INT;

LET v_serial = 1;

FOREACH SELECT ROWID INTO v_rowid FROM test_table

UPDATE test_table SET unique_id = v_serial WHERE ROWID = v_rowid;

LET v_serial = v_serial + 1;

END FOREACH;

END PROCEDURE;

EXECUTE PROCEDURE update_serial();

ALTER TABLE test_table MODIFY unique_id SERIAL NOT NULL;

CREATE UNIQUE INDEX i_unique_id ON test_table (unique_id);

Regards,
Doug Lawry

-----Original Message-----
From: development-tools-bounces@iiug.org
[mailto:development-tools-bounces@iiug.org] On Behalf Of ANIS JAZIRI
Sent: 06 January 2012 08:47
To: development-tools@iiug.org
Subject: add a serial column to exsisting table [740]

Hello,
We need your help please,
Sorry, but it's very urgent.
We have a table count arround 700 000 rows.
we need to add to this table a serial column.
I have this error:
-287 Cannot add serial column column-name to table.

But, I discover a solution for it:
You can add a serial column in three steps:
1-Add the column with an INTEGER data type.
2-Update the table with nonnull, unique values in each row of the new
column.
3-ALTER TABLE MODIFY to change the data type of the column to SERIAL.

I found a problem to resolve point number two, we need to insert fill the
added column by a sequence of unique integer number (like serial)

May I have a solution for it, please?

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





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

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

1. Address it to development-tools@iiug.org
2. Include the bracketed message number in the subject line: [741]

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

add a serial column to exsisting table
Posted by: jaziri.anis@hotmail.com (ANIS JAZIRI) - Fri, 06 Jan 2012 03:47:08 EST
Hello,
We need your help please,
Sorry, but it's very urgent.
We have a table count arround 700 000 rows.
we need to add to this table a serial column.
I have this error:
-287 Cannot add serial column column-name to table.

But, I discover a solution for it:
You can add a serial column in three steps:
1-Add the column with an INTEGER data type.
2-Update the table with nonnull, unique values in each row of the new column.
3-ALTER TABLE MODIFY to change the data type of the column to SERIAL.

I found a problem to resolve point number two, we need to insert fill the
added column by a sequence of unique integer number (like serial)

May I have a solution for it, please?




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

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

1. Address it to development-tools@iiug.org
2. Include the bracketed message number in the subject line: [740]

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

Re: Does PHP conflict with perl DBI
Posted by: ogj@tollpost.no (Øyvind Gjerstad) - Wed, 04 Jan 2012 07:30:02 EST
The following e-mail was sent to you via Development Tools Forum from Øyvind Gjerstad (ogj@tollpost.no) at IP address 85.158.139.227 (proxy25.messagelabs.net).



Re: Does PHP conflict with perl DBI

Did you find out anything regarding this case? I have just learned the same thing the hard way. A consultant of ours tried to install pdo_informix in php during the holidays, and this caused our regular DBI/DBD::Informix access in mod_perl to stop working. No error messages, just hangs on connection. He eventually gave up with php, but did not remove the config, so it took me a while to figure out. I suppose there are some name clashes or something?

Best regards,
Øyvind Gjerstad



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

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

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

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

Re: Fetch attemped on unopen cursor
Posted by: rbergeron@elitenet.ca (Groupe Elite Net Group Inc.) - Tue, 20 Dec 2011 18:02:53 EST
You probably have this cursor in a transaction logic somewhere, so you need
to declare the cursor with hold statement
This should solve your problem :)

2011/12/20 PATRICIA MUDA <patriciamuda@gmail.com>

> Hola!!!!
>
> Necesitaría me ayuden a resolver el siguiente problema:
>
> estoy migrando una base de datos Informix con su respectiva aplicación de
> un
> sistema operativo Unix-Sco a un Linux fedora
>
> las versiones de los productos son:
>
> Fedora release 10 (cambridge) - kernel 2.6.27.41-170.2.117.fc10.x86_64
> Informix - 4gl versión 7.30.UC5
> IBM Informix Dynamic Server Versión 11.10.FC1
>
> la programación es la siguiente:
> ..
> ..
> integer anroiart
> ..
> ..
>
> DECLARE e_cur CURSOR FOR
>
> SELECT UNIQUE articulo.codart, articulo.nroiart,
>
> artimed.cantidad, artimed.coduni,
>
> articulo.descrip
>
> FROM artienva, articulo, artimed
>
> WHERE artienva.nroiart = anroiart
>
> AND articulo.nroiart = artienva.nroienv
>
> AND artimed.nroiart = artienva.nroienv
>
> AND artimed.codmed = "C"
>
> ..
> ..
>
> FOREACH e_cur ......
>
> en el momento del foreach el programa revienta y da el siguiente error
>
> SQL statement error number -400
> Fetch attemped on unopen cursor
>
> Las pruebas que hice fueron:
> 1. correr con debuguer --> NO FALLA, el programa sigue sin problemas
> 2. hacer un programita muy simple solamente con las líneas descriptas
> arriba
> --> NO FALLA, el programa sigue sin problemas
> 3. correr desde dbaccess las mismas líneas descriptas arriba --> NO FALLA,
> resuelve muy bien la select
>
> DESPUES, reprograme en forma más simple las líneas de arriba y llegue a lo
> siguiente:
>
> DECLARE cc CURSOR FOR
>
> SELECT UNIQUE artienva.nroienv, artienva.nroiart
>
> FROM artienva
>
> WHERE artienva.nroiart = anroiart
>
> ORDER BY 1
>
> MESSAGE "STATUS DESPUES DECLARE ", status
>
> SLEEP 2
>
> LET cenva = 1
>
> FOREACH cc INTO p_enva[cenva].nroienv, p_enva[cenva].nroiart
>
> ERROR "ENTRO"
>
> MESSAGE "STATUS DESPUES FOREACH ", status
>
> SELECT UNIQUE artimed.nroiart, artimed.cantidad, artimed.coduni
>
> INTO p_enva[cenva].nroienv, p_enva[cenva].cantidad,
>
> coduni[cenva]
>
> FROM artimed
>
> WHERE artimed.nroiart = p_enva[cenva].nroienv
>
> AND artimed.codmed = "C"
>
> MESSAGE "STATUS DESPUES FOREACH ", status
>
> ERROR "DESPUES DE SELECT ARTIMED"
>
> SLEEP 2
>
> SELECT UNIQUE articulo.codart, articulo.descrip
>
> INTO p_enva[cenva].codenv, descrip[cenva]
>
> FROM articulo
>
> WHERE articulo.nroiart =p_enva[cenva].nroienv
>
> MESSAGE "STATUS DESPUES FOREACH ", status
>
> ERROR cenva, " DESPUES DE buscar descripcion del envase en ARTICULOS"
>
> SLEEP 2
>
> ..
> .. END FOREACH
>
> fui colocando distintos mensajes en los comandos ERROR Y MESSAGE, para
> saber
> por que parte del código pasaba en el momento de la corrida y observo que :
>
> el foreach lo hace 4 veces y una vez lo hizo 6 veces y despues SIEMPRE
> revienta dando el mismo mensaje
>
> SQL statement error number -400
> Fetch attemped on unopen cursor
>
> Desde ya agradezco alguna sugerencia.
>
> Muchas gracias
>
> Patricia
>
>
>
>

>
>
>

--

Richard Bergeron
Groupe Elite Net Inc.
19A Rue Eden
Gaspé, Québec Canada G4X 1Z5

Tel. : 418.361.3532
E-mail : rbergeron@elitenet.ca
Web : www.elitenet.ca

--00235433362e9d1cf004b48e1087




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

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

1. Address it to development-tools@iiug.org
2. Include the bracketed message number in the subject line: [739]

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

Fetch attemped on unopen cursor
Posted by: patriciamuda@gmail.com (PATRICIA MUDA) - Tue, 20 Dec 2011 16:53:08 EST
Hola!!!!

Necesitaría me ayuden a resolver el siguiente problema:

estoy migrando una base de datos Informix con su respectiva aplicación de un
sistema operativo Unix-Sco a un Linux fedora

las versiones de los productos son:

Fedora release 10 (cambridge) - kernel 2.6.27.41-170.2.117.fc10.x86_64
Informix - 4gl versión 7.30.UC5
IBM Informix Dynamic Server Versión 11.10.FC1

la programación es la siguiente:
..
..
integer anroiart
..
..

DECLARE e_cur CURSOR FOR

SELECT UNIQUE articulo.codart, articulo.nroiart,

artimed.cantidad, artimed.coduni,

articulo.descrip

FROM artienva, articulo, artimed

WHERE artienva.nroiart = anroiart

AND articulo.nroiart = artienva.nroienv

AND artimed.nroiart = artienva.nroienv

AND artimed.codmed = "C"

..
..

FOREACH e_cur ......

en el momento del foreach el programa revienta y da el siguiente error

SQL statement error number -400
Fetch attemped on unopen cursor

Las pruebas que hice fueron:
1. correr con debuguer --> NO FALLA, el programa sigue sin problemas
2. hacer un programita muy simple solamente con las líneas descriptas arriba
--> NO FALLA, el programa sigue sin problemas
3. correr desde dbaccess las mismas líneas descriptas arriba --> NO FALLA,
resuelve muy bien la select

DESPUES, reprograme en forma más simple las líneas de arriba y llegue a lo
siguiente:

DECLARE cc CURSOR FOR

SELECT UNIQUE artienva.nroienv, artienva.nroiart

FROM artienva

WHERE artienva.nroiart = anroiart

ORDER BY 1

MESSAGE "STATUS DESPUES DECLARE ", status

SLEEP 2

LET cenva = 1

FOREACH cc INTO p_enva[cenva].nroienv, p_enva[cenva].nroiart

ERROR "ENTRO"

MESSAGE "STATUS DESPUES FOREACH ", status

SELECT UNIQUE artimed.nroiart, artimed.cantidad, artimed.coduni

INTO p_enva[cenva].nroienv, p_enva[cenva].cantidad,

coduni[cenva]

FROM artimed

WHERE artimed.nroiart = p_enva[cenva].nroienv

AND artimed.codmed = "C"

MESSAGE "STATUS DESPUES FOREACH ", status

ERROR "DESPUES DE SELECT ARTIMED"

SLEEP 2

SELECT UNIQUE articulo.codart, articulo.descrip

INTO p_enva[cenva].codenv, descrip[cenva]

FROM articulo

WHERE articulo.nroiart =p_enva[cenva].nroienv

MESSAGE "STATUS DESPUES FOREACH ", status

ERROR cenva, " DESPUES DE buscar descripcion del envase en ARTICULOS"

SLEEP 2

..
.. END FOREACH

fui colocando distintos mensajes en los comandos ERROR Y MESSAGE, para saber
por que parte del código pasaba en el momento de la corrida y observo que :

el foreach lo hace 4 veces y una vez lo hizo 6 veces y despues SIEMPRE
revienta dando el mismo mensaje

SQL statement error number -400
Fetch attemped on unopen cursor

Desde ya agradezco alguna sugerencia.

Muchas gracias

Patricia




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

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

1. Address it to development-tools@iiug.org
2. Include the bracketed message number in the subject line: [738]

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

access informix database from android
Posted by: s.azhagappan@gmail.com (AZHAGAPPAN SIVARAMAN) - Wed, 07 Dec 2011 04:28:09 EST
Hello ,

In my android application development, I need to connect and access the
Informix database from my android application.

But I would like to know if it is possible to directly connect to the Informix
db using JDBC from my android application or is there any other means by which
I can access the Informix db?

Waiting for an early reply.

Thanks & Regards,
Azhagappan.




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

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

1. Address it to development-tools@iiug.org
2. Include the bracketed message number in the subject line: [737]

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

Re: Genero Studio vs Querix LyciaStudio
Posted by: neilom@4js-emea.com (Neil O'Meara) - Thu, 01 Dec 2011 07:33:46 EST
As I work for Four Js I can only comment on Genero.

As we at 4Js wrote our own IDE for Genero it is tightly integrated with
the language and gives all of the features that you would expect in a
modern IDE (project management, editor with automatic syntax completion,
code navigation, graphical form painter, graphical debugger, code
profiler .....). The IDE also provides the Genero Report Writer and
Application Generator.

Genero is close to 100% compatible with existing 4GL and with the IBM
partnership the aim is to make compatibility even better. The Genero
compiler is tighter than the Informix compiler so some errors that would
have occurred at runtime are detected at compile time. I personally have
seen 500 programs used by 350 concurrent users migrated from I4GL on
Unix to Genero on Linux in 1 day, with live running starting 2 days
later. Migration to a simple GUI is also very easy but obviously taking
advantage of full GUI features requires some effort.

Here is a link to the web site section on modernising I4GL applications
and a video showing modernisation of the Stores Demo
http://www.4js.com/en/company/ibm-i4gl-to-genero

http://www.4js.com/en/training/videos/viewvideo/368/webinars/modernizing-the-informix-4gl-stores-demo-webinar-2011-us

The Genero language is a superset of 4GL adding all of the features that
you need for GUI programming including Multiple Dialogs, Tree View, Drag
and Drop ....... . The language also includes extensions for XML
handling, Web Services, reading/writing files/sockets, to call JAVA code
directly in-line from you 4GL and much more.

Genero allows you to run in traditional green screen mode or in GUI.
The GUI mode allows you to use either a desktop client which runs on
Windows, Linux and Mac or to use a browser. The latest version
(currently in Early Access) supports HTML5 as well as AJAX, Silverlight
and snippet sets for rendering like native apps on iPhone ... all of
which have been available for some time.

Full integration with web based products is possible from both the
desktop client and web client so that you can use APIs to any web based
product such as Google maps or Fusion Charts.

There are many Genero customers using the product to run I4GL code on
other databases but of course we all know Informix is the best :-)

As Art pointed out Genero now carries the IBM stamp of approval with IBM
and has thousands of customers worldwide

Why not download the evaluation software from www.4js.com and experience
the joy of using Genero for yourself.

Neil O'Meara

On 30/11/2011 13:55, Art Kagel wrote:
> Querix's IDE is Eclipse, they have essentially written a 4GL support module
> for Eclipse and ship that industry standard IDE with Lycia. The 4Js IDE is
> homegrown but has similar functionality, it is after all an IDE.
>
> On the compiler's features, I have mostly worked with Lycia, so I will
> leave it to others to report on 4Js features. Lycia is nearly 100%
> compatible with your existing 4GL code. Almost all code compiles out of
> the box and works exactly as it did under the Informix 4GL compilers. The
> occasional differences are the same kind you ran into under Informix 4GL
> when switching from R4GL (p-machine version) to C4GL (compiled version)
> where there were small behavioral differences.
>
> Lycia comes with several runners or front-ends. There is a traditional
> character based runner under which your 4GL apps will look and feel exactly
> like they do under C4GL. There are also a windows-native and a portable
> JAVA runner under which your apps will be instantly transformed into GUI
> apps with basic buttons and working mouse controls and GUI field navigation
> with no changes to your code. There is even support for running the JAVA
> running the JAVA runner inside of a web server so that your apps can be
> used inside of web browsers and even smart phones like Android and iPhone
> phones. You can then add support for making your apps more gui and web
> aware in your form files, in configuration files, and even by adding
> function calls inside your code to completely modernize your applications.
>
> Lycia also supports connecting your applications to other databases than
> Informix - though why anyone would want to do that escapes me ;-) - which
> includes automated translation of the SQL dialects so you need make few
> changes in your code to migrate it to another server. This feature will
> make your management happy as they can feel more comfortable not switching
> away from 4GL altogether "Just in case Informix goes away!"
>
> Much of this also goes for 4Js, but again I'm less comfortable talking
> about it, but my impression over the years has been that Lycia's
> compatibility with Informix 4GL is tighter and converting to a fully
> graphical aware application is easier with Lycia. The biggest attraction
> for 4Js these days is that once again it has IBM's stamp of approval and
> IBM support and will become the official IBM 4GL over the next year or so.
> You can download Lycia from Querix's web site for a 30-day free trial
> anytime and see for yourself how easy it is to bring your apps into the
> modern age!
>
> Art
>
> Art S. Kagel
> Advanced DataTools (www.advancedatatools.com)
> Blog: http://informix-myview.blogspot.com/
>
> 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 Wed, Nov 30, 2011 at 1:54 AM, PRAVIN
BANKAR<pravinebankar@gmail.com>wrote:
>
>> Hi Art,
>>
>> I would like to know as the IDE as well as the compiler/language products
>> as a
>> whole for both the studios.
>>
>> Thank for your quick response.
>>
>> Regards,
>> Pravin Bankar
>>
>>
>>
>>
>

>>
>>
>>
> --90e6ba6e8d2ab346a904b2f41762
>
>
>

>
>




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

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

1. Address it to development-tools@iiug.org
2. Include the bracketed message number in the subject line: [736]

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

Does PHP conflict with perl DBI
Posted by: steve.barss@police.saskatoon.sk.ca (STEVE BARSS) - Wed, 30 Nov 2011 16:11:48 EST
We've been using mod_perl with DBI for a long time to connect with our IDS
11.5 database, and we just upgraded PHP to 5.3 so we could use pdo_informix.
Everything installed properly, but once we created a connection with PHP, all
of the mod_perl connections went dead. Does anyone know if this is a known
issue or if there are any workarounds? it seems weird that we can't use both
PHP and mod_perl on the same webserver.

thanks for any ideas




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

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

1. Address it to development-tools@iiug.org
2. Include the bracketed message number in the subject line: [735]

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

Re: Genero Studio vs Querix LyciaStudio
Posted by: art.kagel@gmail.com (Art Kagel) - Wed, 30 Nov 2011 08:55:52 EST
Querix's IDE is Eclipse, they have essentially written a 4GL support module
for Eclipse and ship that industry standard IDE with Lycia. The 4Js IDE is
homegrown but has similar functionality, it is after all an IDE.

On the compiler's features, I have mostly worked with Lycia, so I will
leave it to others to report on 4Js features. Lycia is nearly 100%
compatible with your existing 4GL code. Almost all code compiles out of
the box and works exactly as it did under the Informix 4GL compilers. The
occasional differences are the same kind you ran into under Informix 4GL
when switching from R4GL (p-machine version) to C4GL (compiled version)
where there were small behavioral differences.

Lycia comes with several runners or front-ends. There is a traditional
character based runner under which your 4GL apps will look and feel exactly
like they do under C4GL. There are also a windows-native and a portable
JAVA runner under which your apps will be instantly transformed into GUI
apps with basic buttons and working mouse controls and GUI field navigation
with no changes to your code. There is even support for running the JAVA
running the JAVA runner inside of a web server so that your apps can be
used inside of web browsers and even smart phones like Android and iPhone
phones. You can then add support for making your apps more gui and web
aware in your form files, in configuration files, and even by adding
function calls inside your code to completely modernize your applications.

Lycia also supports connecting your applications to other databases than
Informix - though why anyone would want to do that escapes me ;-) - which
includes automated translation of the SQL dialects so you need make few
changes in your code to migrate it to another server. This feature will
make your management happy as they can feel more comfortable not switching
away from 4GL altogether "Just in case Informix goes away!"

Much of this also goes for 4Js, but again I'm less comfortable talking
about it, but my impression over the years has been that Lycia's
compatibility with Informix 4GL is tighter and converting to a fully
graphical aware application is easier with Lycia. The biggest attraction
for 4Js these days is that once again it has IBM's stamp of approval and
IBM support and will become the official IBM 4GL over the next year or so.
You can download Lycia from Querix's web site for a 30-day free trial
anytime and see for yourself how easy it is to bring your apps into the
modern age!

Art

Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
Blog: http://informix-myview.blogspot.com/

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 Wed, Nov 30, 2011 at 1:54 AM, PRAVIN BANKAR <pravinebankar@gmail.com>wrote:

> Hi Art,
>
> I would like to know as the IDE as well as the compiler/language products
> as a
> whole for both the studios.
>
> Thank for your quick response.
>
> Regards,
> Pravin Bankar
>
>
>
>

>
>
>

--90e6ba6e8d2ab346a904b2f41762




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

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

1. Address it to development-tools@iiug.org
2. Include the bracketed message number in the subject line: [734]

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

Re: Genero Studio vs Querix LyciaStudio
Posted by: pravinebankar@gmail.com (PRAVIN BANKAR) - Wed, 30 Nov 2011 01:54:19 EST
Hi Art,

I would like to know as the IDE as well as the compiler/language products as a
whole for both the studios.

Thank for your quick response.

Regards,
Pravin Bankar




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

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

1. Address it to development-tools@iiug.org
2. Include the bracketed message number in the subject line: [733]

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

Re: Genero Studio vs Querix LyciaStudio
Posted by: art.kagel@gmail.com (Art Kagel) - Tue, 29 Nov 2011 18:01:49 EST
The IDE or the compiler/language products as a whole?

Art
On Nov 29, 2011 12:20 PM, "PRAVIN BANKAR" <pravinebankar@gmail.com> wrote:

> Hi,
>
> Can anybody help me to understand the difference between two different
> IDEs:
> Genero Studio vs Querix LyciaStudio?
>
> Any kind of help would be appreciated. Thank you.
>
> Regards,
> Pravin Bankar
>
>
>
>

>
>
>

--00151773d9d25eca3d04b2e79a45




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

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

1. Address it to development-tools@iiug.org
2. Include the bracketed message number in the subject line: [732]

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

Genero Studio vs Querix LyciaStudio
Posted by: pravinebankar@gmail.com (PRAVIN BANKAR) - Tue, 29 Nov 2011 14:20:09 EST
Hi,

Can anybody help me to understand the difference between two different IDEs:
Genero Studio vs Querix LyciaStudio?

Any kind of help would be appreciated. Thank you.

Regards,
Pravin Bankar




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

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

1. Address it to development-tools@iiug.org
2. Include the bracketed message number in the subject line: [731]

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

Re: Error: Statement length exceeds maximum
Posted by: veraju16@gmail.com (Emmanuel Raju V) - Tue, 01 Nov 2011 10:01:43 EDT
Thank you Art for your help.

On Tue, Nov 1, 2011 at 7:12 PM, Art Kagel <art.kagel@gmail.com> wrote:

> Reduce the size of the procedure. The maximum length of any SQL in
> Informix (and the entire CREATE PROCEDURE/FUNCTION... END
> PROCEDURE/FUNCTION block is treated as a single statement) must be less
> than 64K. You will have to extract blocks of code from the procedure and
> move them into sub-functions.
>
> Art
>
> Art S. Kagel
> Advanced DataTools (www.advancedatatools.com)
> Blog: http://informix-myview.blogspot.com/
>
> 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, Nov 1, 2011 at 6:44 AM, EMMANUEL RAJU <veraju16@gmail.com> wrote:
>
> > Hi All,
> > I wrote SP with 1798 lines of code. I tried to add new statements to SP
> > then i got the error "Statement length exceeds maximum".
> > Help us to how to reduce this error.
> >
> >
> >
> >
>
>

> >
> >
> >
>
> --e89a8f3ba85dffe1eb04b0ac84ac
>
>
>
>

>
>
>

--
Thank you,
Emmanuel Raj V

--20cf303f6a10e4dd4004b0acc9b5




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

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

1. Address it to development-tools@iiug.org
2. Include the bracketed message number in the subject line: [730]

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