On 23/09/2008, at 7:12 AM, GKern@xxxxxxxxxxxxxxxx wrote:

When using STRSQL, I enter CREATE FUNCTION and in return I get "Token
<END-OF-STATEMENT> was not valid."

Accurate because you have not completed the statement.


If I type CREATE FUNCTION and press F4 it tells me 'prompting not
supported'.

Also true. Interactive SQL does not support prompting for all SQL statements--usually the more complex ones. This has been the case for at least 6 releases.


If I type CREATE and press F4 I get:

Select one of the following:

1. CREATE ALIAS
2. CREATE COLLECTION
3. CREATE INDEX
4. CREATE PROCEDURE
5. CREATE TABLE
6. CREATE VIEW


Which substantiates the previous error message.

How do I go about creating the UDF?

Manually. You have to read the documentation, work out the correct statement, and type in by hand--just like on other platforms. Isn't lowest-common denominator a wonderful thing?

You may find a wizard in Navigator that helps but since that requires WinDOS I can't be bothered using it.

Regards,
Simon Coulter.
--------------------------------------------------------------------
FlyByNight Software OS/400, i5/OS Technical Specialists

http://www.flybynight.com.au/
Phone: +61 2 6657 8251 Mobile: +61 0411 091 400 /"\
Fax: +61 2 6657 8251 \ /
X
ASCII Ribbon campaign against HTML E-Mail / \
--------------------------------------------------------------------




This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].