Re: IDS 10.0 error writing to /dev/null under Solaris only
On 05/10/2005 08:55 PM, Neil Truby wrote:
> Here's a funny thing:
>
> On HP-UX:
> ========
> $ onstat -V> IBM Informix Dynamic Server Version 10.00.HC1 Software Serial Number
> AAA#B000000
> $ uname -a> HP-UX sal B.11.11 U 9000/800 2012393627 unlimited-user license
> $ dbaccess stores_demo << !^Joutput to /dev/null^Jselect * from customer^J!>
> Database selected.
> 28 row(s) retrieved.
> Database closed.
>
> On Solaris
> =======
> $ onstat -V> IBM Informix Dynamic Server Version 10.00.UC1 Software Serial Number
> AAA#B000000
> $ uname -a> SunOS rizzo 5.9 Generic_117171-07 sun4u sparc SUNW,UltraAX-i2
> $ dbaccess stores_demo << !^Joutput to /dev/null^Jselect * from customer^J!>
> Database selected.
> 807: Cannot open file for output.
> Error in line 1> Near character position 20
> Database closed.
>
> Why should that be? It's not a permissions thing on Solaris. A Solaris
> customer originally pointed it out, so it's not just something about my
> server.
>
> Thanks
> Neil
>
>
>
>
Neil,
I think that it is a shell issue with newline characters.
To verify that run your scriptlet without ^J characters:
dbaccess stores_demo << !
output to /dev/null
select * from customer!
If it runs correctly, you have to find newline character
for your shell.
HTH.
--
Mladen Jovanovski
Phone: +389 2 244 1140
Mobile: +389 75 400 309
sending to informix-list
"Mladen Jovanovski" <mladen.jovanovski@cosmofon.com.mk> wrote in message
news:1115808007.9716c21bbab542df9900cb17405539b7@teranews...
>
> On 05/10/2005 08:55 PM, Neil Truby wrote:
>> Here's a funny thing:
>>
>> On HP-UX:
>> ========
>> $ onstat -V>> IBM Informix Dynamic Server Version 10.00.HC1 Software Serial Number
>> AAA#B000000
>> $ uname -a>> HP-UX sal B.11.11 U 9000/800 2012393627 unlimited-user license
>> $ dbaccess stores_demo << !^Joutput to /dev/null^Jselect * from>> customer^J!
>>
>> Database selected.
>> 28 row(s) retrieved.
>> Database closed.
>>
>> On Solaris
>> =======
>> $ onstat -V>> IBM Informix Dynamic Server Version 10.00.UC1 Software Serial Number
>> AAA#B000000
>> $ uname -a>> SunOS rizzo 5.9 Generic_117171-07 sun4u sparc SUNW,UltraAX-i2
>> $ dbaccess stores_demo << !^Joutput to /dev/null^Jselect * from>> customer^J!
>>
>> Database selected.
>> 807: Cannot open file for output.
>> Error in line 1>> Near character position 20
>> Database closed.
>>
>> Why should that be? It's not a permissions thing on Solaris. A Solaris
>> customer originally pointed it out, so it's not just something about my
>> server.
>>
>> Thanks
>> Neil
>>
>>
>>
>>
>
> Neil,
>
> I think that it is a shell issue with newline characters.
> To verify that run your scriptlet without ^J characters:
>
> dbaccess stores_demo << !
> output to /dev/null
> select * from customer> !
>
> If it runs correctly, you have to find newline character
> for your shell.
>
> HTH.
I don;t think it's anything like that, As I say, the same sql/script runs
fine on v9 on Solaris, or on v10 on any other OS. I've raised an IBM
Informix Tech Support call, 431612, so I guess I'll find out the IBM
response in due course.