Hi everybody!
In Informix or Oracle there is a "decode" function. What it does is
converts some available values in the field and changes to
whatewer you ask. For examle:
SELECT employee_name, DECODE(employee_code, "A", "1", "B",
"2"...
Thanks, but Iif function works only if just 1 value should be changed, then for rest of the case data will be the same. I need to have ability to decode multiple values!
Any suggestions?
Hi everybody!
In Informix or Oracle there is a "decode" function. What it does is converts some available values in the field and changes to whatewer you ask. For examle:
SELECT employee_name, DECODE(employee_code, "A", "1", "B", "2"...
Hi everyone,
this morning I have run a "sort" command: sort file_name.
File was very big. I've vate for 5 min. and then terminated telnet session. Now
I cannot connect. It gives me error: " No utpm entry. You must exec "LOGIN" from lower level "sh". Connect...
Which Error message is it?
I would use the following command:
UNLOAD TO "file_name.unl" SELECT * FROM your_table_name;
Make sure you have rights to write in the directory you are unloading this file to.!
Hi,
Does anybody know how to remove a user from PUBLIC group in
informix Security? The problem is, that when I am creating user acount
on Unix box, this acount becomes to be a leageble user for Informix
DB. I cannot (some business rules) REVOKE all from PUBLIC. What I
need is just to remove...
Hi,
Does anybody know how to remove a user from PUBLIC group in informix Security? The problem is, that when I am creating user acount on Unix box, this acount becomes to be a leageble user for Informix DB. I cannot (some business rules) REVOKE all from PUBLIC. What I need is just to remove an...
Hi,
you can download Informix SetNet32 is part of Informix SDK kit you can find for free from www.intraware.com (you need to become a member. It is free too). Then install it. You need a valid license id for Informix server.
Good luck.
Rostik
Thanks.
Yes I know all manual steps. However, when I am manually entering to the server, it will ask me login and password. In this case I can enter it. However, how to by pass it if it will be unattended (cron) script????
Rostik
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.