Search code examples
ibm-midrangeiseries-navigatorudf

How to create UDF in AS400

I have this code of UDF that stars with create function...

But I have NO idea where to put it inside the iseries navigator screen. can anyone help me? Google isn't helping

Solution

  • Expand the Databases branch to show all the DBs on the system..

    Then either

    • Right click on the DB and select Run SQL Scripts

    or

    • Expand the DB to show schemas
    • Right click your selected schema and select New-->Function-->SQL

    The first is probably your best option as you seem to have the complete source.