Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
charuta
Starting Member
3 Posts |
 Posted - 2011-07-13 : 07:22:40
|
| hi there,I have written a stored procedure which calls a 'C' program using system command. I am getting an error while executing this stored procedure.Code:CREATE PROCEDURE logrec_sms00() DEFINE sys_cmd varchar(204); LET sys_cmd = 'mpipewrite'; SYSTEM sys_cmd;END PROCEDURE;Here 'mpipewrite' is a C program. I am using Informix database on linux. I created this procedure using dbacess. My program is also stored in my home directory. I am getting an error as:-------------------------668: The system command cannot be executed or it exited with a non-zero sta127: ISAM error: no primary key------------------Can anybody help me to remove this error please????Thanks,Charuta |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2011-07-13 : 07:30:18
|
You will hardly get help on here because this is a forum for MS SQL Server.Maybe you can get better help on an Informix-forum.
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
charuta
Starting Member
3 Posts |
Posted - 2011-07-13 : 07:33:17
|
| hmmm... do you think its Informix problem? I though there must be some problem related to stored procedure syntax. Do you have an example of the stored procedure calling C program?Thanks,Charuta |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2011-07-13 : 07:38:00
|
Your example code is completely different to all I have seen in SQL.So my example wouldn't help you.And you error isn't a syntax error so far...
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
charuta
Starting Member
3 Posts |
Posted - 2011-07-13 : 07:41:16
|
| ok. I will try on the Informix forums. Thanks for your quick replies.Thanks,Charuta |
|
|
|
|
|
|
stored procedure and system commands