Re: Informix SE on Solaris, using ACE report writer...
--- Chris Pilson <cp@dana.ucc.nau.edu>
> wrote:
>Hello all - I am new to Informix and, indeed, to SQL as a whole ... I am
>able to do selects, simple param[] calls, and so on, but I cannot do two
>very basic things that I need to be able to do and was hoping that someone
>on here could point me in the right direction -
> 1) I can do
> select * stuff from orders where order_date=today into
> temp foo;> which selects everything from the orders table and throws it into
> a table called foo, and a column called stuff (aliased) ... this
> is fine, but I *cannot* then go "back" to look at this table -
Are you sure that's fine? Unless orders only has one column the alias you have defined should fail and foo wouldn't be created. Drop your 'stuff' and after the table is created you should be able to
select * from foo
and get results. It will retain the same column names as the orders table. If you want to change the column names you will need to explicitly select and define each one:
select col1 order, col2 name
from orders
This will return the values in columns named 'order' and 'name'.
> I've tried database@server.foo.stuff, database.owner.foo.stuff,
> and the like, but I just cannot read this into anything! And,
> since I have 3 selects going on, I cannot read this into a
> variable, like
> select * into variable from orders where order_date=today
> ... so this is out the window, unfortunately. :(>
> 2) I can do
> select * from orders where order_date=today> but I cannot do:
> let foobar = (select * from orders where order_date =
> today);
> as I should be able to ... in fact, I can't use the LET keyword
> ANYWHERE! When isql goes to compile the .ACE file into an .ARC
> file, it whines about this and give me an error file instead.
>
><sigh> As it can be seen, I've turned everywhere, and hopefully someone
>on here will have a sense of what I am trying to do and steer me in the
>right direction.
>
>Thanks!
==
Maintainer of the procrastinator's FAQ. Well, maybe tomorrow I will be.
_____________________________________________________________
Want a new web-based email account ? ---> http://www.firstlinux.net