Recent content by tungaw2003

Only informix user can grant a permission to database user. U can also try to use root to grant permission.

I think you need to grant a read permission to your database user. grant select to username.

Uwe, Can you help me solve this problem?. I executed $ ps -aef|grep dbaccess|grep -v grep. Is it correct?. ipcrm is used to kill an ipc, however, i do not know where can i find the ipc number or semaphore coz I have a lot of Informixserver configured. Sometimes it work, sometimes not at...

Thanks, But i have a lot of INFORMIXSERVER configured on this machine. when i run ipcs, it shows a list of semaphores for informix. I can use ipcrm, but where can i find the semaphore to remove?.

It works.. Thanks a lot. tungaw

Hi, I have an Stored procedure Language on my remote IDS (ifxatsweb). I also have my local server (ifxlocal). The SPL executes a java program that resides on my remote server(ifxatsweb). When i executed the SPL on remote machine, there was no error, however, if i try to execute the SPL on my...

Hi, I want to remove the "|" on the end of each record. How will i do it?. CAROLINA|100000000.00|A000000003|10.0000000|11/05/2002|018| |40000000.00|A000000004|10.0000000|11/05/2002|018| CITY|70000000.00|A000000002|15.0000000|11/06/2002|011|...

Did you install the php?. do not use $find, instead use $locate php.ini

You cannot use "oninit -ivy" if it's already initialized. just use 'oninit -y ' if it's previously configured.

You can find it in /u/www/conf/php/php.ini. This is the default directory where the php.ini initially installed. Use "$ locate php.ini" if you're using linux.

I've already found it through "ps -aef|grep -in dbaccess" 87:informix 1566 1475 0 17:27:06 ttyp1 00:00:00 grep dbaccess what is 1566 and 1475 column?. Which one is the semaphore? Thanks a lot.

Hi, I'm running a delete from table, however, all of a sudden, there was an error displayed. It shows "134: ISAM error: no more locks er read to fetch next row.". I tried to add "lock table tablename in exclusive mode"., however, it's still the same. Because of the error...

Hi All, I want to call a binary program using SPL(stored procedure). I setup all environment variables, $PATH, INFORMIXSERVER, permission on the database, etc. However, I wasn't able to execute the : LET l_cmd = "/proj/informix/validate.sh "||UserId||" "||Password...

Hi All, I've already resolved the problem. The problem is not on sqlhosts nor .netrc. The problem is on setting up the php.ini file. INFORMIXSERVER,username and password should have default values instead of null strings. Thanks anyways.. tungaw

I would suggest, you give up the NT admin and focus on Unix Admin.