[DB2-L] V7 for z/OS and UDF, Part2

Ruediger Kurtz

[DB2-L] V7 for z/OS and UDF, Part2
Walter,

thanks, but same result (-440)

Ruediger

-----Ursprüngliche Nachricht-----
Von: DB2 Data Base Discussion List [mailto:[login to unmask email] Im Auftrag von Walter Janißen
Gesendet: Freitag, 13. Januar 2006 13:39
An: [login to unmask email]
Betreff: Re: [DB2-L] V7 for z/OS and UDF, Part2

Hi Rüdiger

Did you try:

SELECT *
FROM T7.TAGEVO
WHERE GEVO_INV = INVTSTF(timestamp(('2006-01-05-
08.17.55.293557'))

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Ruediger Kurtz

AW: [DB2-L] V7 for z/OS and UDF, Part2
(in response to Ruediger Kurtz)
Oops, to fast ... I just tried it, different result this time:

-417, Reason 00E7900C; something wrong with our WLM,

now I changed the WLM in the function's definition, different error this time:

SQLCODE = -444, ERROR: USER PROGRAM INVTSTF COULD NOT BE FOUND

have to check with our application programmer (he wrote the program),

seems we're getting somewhere eventually.

Thanks a lot

Ruediger



-----Ursprüngliche Nachricht-----
Von: DB2 Data Base Discussion List [mailto:[login to unmask email] Im Auftrag von Walter Janißen
Gesendet: Freitag, 13. Januar 2006 13:39
An: [login to unmask email]
Betreff: Re: [DB2-L] V7 for z/OS and UDF, Part2

Hi Rüdiger

Did you try:

SELECT *
FROM T7.TAGEVO
WHERE GEVO_INV = INVTSTF(timestamp(('2006-01-05-
08.17.55.293557'))

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Mallik

Re: AW: [DB2-L] V7 for z/OS and UDF, Part2
(in response to Ruediger Kurtz)
Try defining the input parm as CHAR(26) field and you CAST that into timestamp before you process it further.

Thanks,
Mallik


Kurtz, Rüdiger <[login to unmask email]> wrote: Oops, to fast ... I just tried it, different result this time:

-417, Reason 00E7900C; something wrong with our WLM,

now I changed the WLM in the function's definition, different error this time:

SQLCODE = -444, ERROR: USER PROGRAM INVTSTF COULD NOT BE FOUND

have to check with our application programmer (he wrote the program),

seems we're getting somewhere eventually.

Thanks a lot

Ruediger



-----Ursprüngliche Nachricht-----
Von: DB2 Data Base Discussion List [mailto:[login to unmask email] Im Auftrag von Walter Janißen
Gesendet: Freitag, 13. Januar 2006 13:39
An: [login to unmask email]
Betreff: Re: [DB2-L] V7 for z/OS and UDF, Part2

Hi Rüdiger

Did you try:

SELECT *
FROM T7.TAGEVO
WHERE GEVO_INV = INVTSTF(timestamp(('2006-01-05-
08.17.55.293557'))

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm




---------------------------------
Yahoo! Photos – Showcase holiday pictures in hardcover
Photo Books. You design it and we’ll bind it!

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm