Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Scott Black — — source: Informix-list mailing list archive (1991-1998)
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
}
}
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.