I can't import by name function with DB2

dataservices job design
1

Hello.

I am trying to import DB2 UB functions, however, DI seems doesn’ find functions or SP. I am using DI 6.5.1.4, I don’t know if there is a bug with this version and unfortnatly, our customer doen’t have support anymore.

someone have an idea?

thanks in advance

omdelangel (BOB member since 2008-07-08)

2

Does the DB2 datastore have the functions subnode or just tables?? If I recall correctly 6.5 did support stored procedures/functions for Oracle but not DB2. Not sure though.

Werner Daehn :de: (BOB member since 2004-12-17)

3

thanks for replay.
The DataStore has both, functions and tables subnode, in the Technical Manual doesn’t say any about a restricction for DB2 to import functions, here i read a similar case in the past but i don’t know if they could resolved it , My intention is to import a function Translate for clean unavailable characters for example, phone nuber field, they want to eliminate all characters diferent of numbers from the source. I am using Replace Function (in DI) but I would like to simplify the code for something like this.

PhoneNum = Replace(Translate(PhoneNum,’’,Translate(PhoneNum,’’,‘1234567890’)),’ ‘,’’)

In this way I can eliminate all chars diferent of numbers

thanks in advance

omdelangel (BOB member since 2008-07-08)

4

are you able to import stored procedure from DB2 ? as Werner mentioned this feature for DB2 may not be there in 6.5

I think even in higher version of DI/DS for DB2 you can’t import functions you can import only stored procedures, there is some limitation in DB2 ODBC API, I can check that

if you are able to import stored procedure, wrap your DB2 function in a stored procedure and use that

manoj_d (BOB member since 2009-01-02)

5

Thanks manoj_d, efectively, i can import Stored Procedures, i will do your suggestion change function by a Procedure

Thanks alot !!!

:wave:

omdelangel (BOB member since 2008-07-08)