Oninit cdi / Archive
Talk to an expert →

Question about query

Posted in 2006

Topics: General Discussion

luissol — — source: Usenet: comp.databases.informix

Hi, I'm using informix but I need to get only new values of a table and what I need is a query that is something like this SELECT top (number1 - number2 ) * FROM table; where my variables are: number1 --> a variable that I know number2 --> select count(*) FROM table Thanks Luis Saavedra

↪ replying to luissol
Quman — — source: Usenet: comp.databases.informix

Using a PERL script $number1= arg(0); $number2 <= slect coiunt(*) from table ... ... dbh-> do (" select $number1 - $number2...) ..... do not trust the above new PERL syntax. Quman On 4 Oct 2006 14:10:24 -0700, luissol <luissol@gmail.com> wrote: > Hi, I'm using informix but I need to get only new values of a table > > and what I need is a query that is something like this > > > SELECT top (number1 - number2 ) * FROM table; > > where my variables are: > number1 --> a variable that I know > number2 --> select count(*) FROM table > > Thanks > Luis Saavedra > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list >

↪ replying to Quman
luissol — — source: Usenet: comp.databases.informix

I'm using C# to access the database Quman wrote: > Using a PERL script > > $number1= arg(0); > $number2 <= slect coiunt(*) from table ... > > ... > dbh-> do (" select $number1 - $number2...) > > ..... > > > do not trust the above new PERL syntax. > > Quman > > > > > On 4 Oct 2006 14:10:24 -0700, luissol <luissol@gmail.com> wrote: > > Hi, I'm using informix but I need to get only new values of a table > > > > and what I need is a query that is something like this > > > > > > SELECT top (number1 - number2 ) * FROM table; > > > > where my variables are: > > number1 --> a variable that I know > > number2 --> select count(*) FROM table > > > > Thanks > > Luis Saavedra > > > > _______________________________________________ > > Informix-list mailing list > > Informix-list@iiug.org > > http://www.iiug.org/mailman/listinfo/informix-list > >

Related threads