Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by rostik

  1. rostik

    Is there any "decode" function in Microsoft SQL syntax?

    Thanks very much. Rostik s-)
  2. rostik

    How to automatically produce a .csv file from Access Database?

    Thanks guys very much! It works both ways. Rostik s-)
  3. rostik

    Is there any "decode" function available in Micorosoft SQL syntax?

    Erik, I know that. I need help with alternative to decode function! (read my question, please)
  4. rostik

    How to automatically produce a .csv file from Access Database?

    Hi All, What would be a best way to automatically produce a .csv file from Access Database? Thanks
  5. rostik

    Is there any "decode" function available in Micorosoft SQL syntax?

    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&quot...
  6. rostik

    Is there any "decode" function in Microsoft SQL syntax?

    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?
  7. rostik

    Is there any "decode" function in Microsoft SQL syntax?

    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&quot...
  8. rostik

    Please help -- Suddenly, I cannot telnet to SCO box!

    Thank you guys. I have cleaned /tmp directory and then restarted Unix box. It works! Thanks again. Rostik
  9. rostik

    Please help -- Suddenly, I cannot telnet to SCO box!

    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...
  10. rostik

    How to Mapp a Unix box as a drive letter on Windows 2000 client ?

    Thanks a lot!
  11. rostik

    How to Mapp a Unix box as a drive letter on Windows 2000 client ?

    thanks. Where I can find this Unix add-on pack? %-)
  12. rostik

    Export to ASCII file in SQL statement

    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.!
  13. rostik

    Informix Connect

    Ivelina, give me your e-mail, and I will send you zip file as an attachment. Rostik Ilinskiy
  14. rostik

    Does anybody knows Informix Database Security?

    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...
  15. rostik

    Does anybody knows Informix Security very well ?

    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...
See more

Part and Inventory Search

Back
Top