RE: creating stored procedures using ISQL
I seem to recall a similar problem a while back. Have you tried this in
dbaccess? I think ISQL is not capable of some things with stored
procedures.
} -----Original Message-----
} From: Greg Laurin [SMTP:glaurin@coldstorage.com]
} Sent: Sunday, December 14, 1997 11:21 AM
} To: informix-list@rmy.emory.edu
} Subject: creating stored procedures using ISQL
}
} This is something that sounds to simple but I can't create a stored
} procedure in ISQL
}
} I tried -
} CREATE PROCEDURE test()
} END PROCEDURE;
}
} and it works, OK I tried -
}
} CREATE PROCEDURE test(ltqty INT)
}
} let ltqty = ltqty / 2; -- I also tried it without the ;
}
} END PROCEDURE;
}
} and it gives me a syntax error, Why ?
}
}
} I have looked in all the manuals for I4GL 4.01 and ISQL 4.02 and there
} is
} nothing, absolutely nothing on stored procedures :(
}
} Thanks In advance for helping me with this simple and dump question
}
} Doug Gray
} penngray@netrover.com
}
}