Recent content by nilin

Hi, I need to convert following Oracle SQL to Informix SQL, Please help since i am facing problems with Outer join Thanks in advance Sandeep Oracle SQL: =====+++++ SELECT DISTINCT PVC.PVC_ID,PVC.RSWITCH,PVC.RSLOT,PVC.RPORT,PVC.PVC_RDLCI...

Hi, I need to convert following Oracle SQL to Informix SQL, Please help since i am facing problems with Outer join Thanks in advance Sandeep Oracle SQL: =====+++++ SELECT DISTINCT PVC.PVC_ID,PVC.RSWITCH,PVC.RSLOT,PVC.RPORT,PVC.PVC_RDLCI...

Dear all, I am installing Informix IDS 10.0 While initializing Parameters i am getting error: Bad READ/WRITE perms: '/user/informix/data/rootdbchnk' Please help me. Thanks in advance Sandeep Pawar

It will remove the blank spaces from left / right sides of the selected field, hope so..try

Hi, Can some one help me in solving one SQL problem! I have 10 records in a table, i want a SQL which should select from record 4 to 10 , first 3 records i want to skip. (informix SQL) thank you, nilin

Hi, I am initializing the Parameters in Informix IDS 9.4 using ONMONITOR but getting error as "Error writing to network". This is a new installation. Please help me if anybody faced this problem. Thanks in advance Sandeep

Dear all, I am using Informix 9.4 on Linux and trying to connect it through IBM Informix .Net Provider (Client SDK 2.81 TC3 - client OLEDB/Informix Native driver). But it asks for cdotnet.sql script to be run on Informix in sysmaster Database, what is this script about? can anybody help me...

Hello, Recently I am facing a problem as stated below, please help me out. See i have two diff. tables in my database. and on a form i have array to display records from both of these two tables. now when a form loads i want select records from both of these table and display them. I write two...

What is the meaning of following SQL? SQL : Select * from employee where 1 = 0

What would be the diff. between your sql and following one? SELECT D.deptid,D.deptname,COUNT(E.deptid) count_emp FROM Emp_master E,Dept_master D WHERE E.deptid=D.deptid GROUP BY 1,2 thaning you, nilin

Hello, Can anybody guide me , what should be the sql for following criteria, Emp_master table has columns (empid,empname,deptid,joindt) Dept_master table has columns (deptid,deptname) Now I want to find out how many emp. are there in each Dept? Can u give me the Sql? nilin

Hi Shriyan, Thanks for reply, but if i edit this DBSERVERALISES to ONCONFIG and when i do the shutdown of Informix (to bounce back) it is not coming from OFFLINE to ONLINE (since it's not in Quiescent Mode) so Share Memory is not initialized.... can you tell me why is it so? one more think i...

Hi Shriyan, find bellow the required dump of the commands 1> grep $INFORMIXSERVER $INFORMIXDIR/etc/$ONCONFIG DBSERVERNAME admnsrv1 # Name of default database server 2> grep $INFORMIXSERVER $INFORMIXDIR/etc/sqlhosts admnsrv1 onipcshm spica on_admnsrv1 admnsrv1 onsoctcp spica on_admnsrvtcp...

Hi Shriyan, While connecting from Windows 2000 client PC to Informix Server (Informix 7.x with HP-UNIX 10.x) i am getting error number -908 when trying from ILogin Full error message is like: Message from ILogin Demo Database: Sqlcode = -908 Refer to Informix find error utility or...

Hi Shriyan, Thanks for reply But can you explain me this SQL (num_of_extents & total_size) ? like what this count(*) returns and what is the relation between num_of_extents & total_size? Is it in KB , MB or i need to multiply both to find my table and database size in total? does it gives...