Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2003
    Posts
    38

    Post Unanswered: Substitute of PL/SQL function INSTR() in DB2

    Hi,

    Can you please suggest me the alternate of PL/SQL's INSTR() function in Db2. During portying from Oracle to DB2, I could not find it's substitute.

    Thanks.
    Raj Shekhar

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: Substitute of PL/SQL function INSTR() in DB2

    Apologies, am not sure ...

    Check the first link below , which has a number of UDFs ...

    The second link is a oracle to db2 porting guide

    and the third is the porting portal in db2 dd ...

    HTH



    http://www7b.software.ibm.com/dmdd/l...dfs/index.html

    http://www7b.software.ibm.com/dmdd/l...205wilkins.pdf

    http://www7b.software.ibm.com/dmdd/z...ing/index.html

  3. #3
    Join Date
    May 2003
    Location
    Phoenix, US
    Posts
    39

    Re: Substitute of PL/SQL function INSTR() in DB2

    Hi,
    Pls see the scalar function POSSTR(string1,string2)

    Thanks
    Sateesh
    Originally posted by Raj Shekhar
    Hi,

    Can you please suggest me the alternate of PL/SQL's INSTR() function in Db2. During portying from Oracle to DB2, I could not find it's substitute.

    Thanks.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •