SUBSTRING_INDEX equivalent in DB2?

edwinholt · #1 (**permalink**) 01-14-04, 11:21

Is there a equivalent MYSQL SUBSTRING_INDEX function in Version 7-8 DB2?

String sqlQueryString = ("SELECT EVNTID, ENTDATE, DESC, SUBSTRING_INDEX(NOTES, ' ', 2), EVNTNAME FROM " + DatabaseSchema + ".TWBCALENDAR WHERE JULIAN_DAY(ENTDATE) >= JULIAN_DAY('" + startDate + "') ORDER BY ENTDATE");
rsEvents = stmt.executeQuery(sqlQueryString);

Thanks

sathyaram_s · #2 (**permalink**) 01-14-04, 11:34

You may consider writing a UDF

Sathyaram

Quote:

Originally posted by edwinholt
Is there a equivalent MYSQL SUBSTRING_INDEX function in Version 7-8 DB2?

String sqlQueryString = ("SELECT EVNTID, ENTDATE, DESC, SUBSTRING_INDEX(NOTES, ' ', 2), EVNTNAME FROM " + DatabaseSchema + ".TWBCALENDAR WHERE JULIAN_DAY(ENTDATE) >= JULIAN_DAY('" + startDate + "') ORDER BY ENTDATE");
rsEvents = stmt.executeQuery(sqlQueryString);

Thanks

edwinholt · #3 (**permalink**) 01-14-04, 11:39

Thank you. I'll go that route. I was just hoping that there would have been a quick fix.

Internet Services

Web Development

Digital Marketing

Consumer Tech