MVSFORUMS.com

DB2 V7 on Z/OS, we built UDF's to migrate between a long part number and a short part number as needed. The UDF's are working fine, converting away happily in any SELECT statement.

But, due to a p ...

I have used SYSIBM.SYSDUMMY1 for years in cases where I had a literal that needed a function of any kind applied. Normally, I will expect this UDF to reference a column in a table, rather than a lite ...

The changes we made worked! Kolusu, it appears not to matter that the SYSDUMMY1 table definition is not equal to the field or fields in question; for example, the following query:

select sandbox. ...

Sorry for any lack of clarity!!

Kolusu, I think I understand what you mean, and it will be possible for me to test this UDF using a value selected from a real table.

jsharon, I was using the sta ...

I was wondering if anyone has anything new to add to this thread? I have a working SP, and a UDF created on it, but it doesn't return anything when invoked through a function call, while the SP does ...

I was finally able to test the scenario I described, and the delete ran very quickly, so it is apparent that DB2 is indeed able to use a multi-column index to do a referential integrity check.

Sorry, Kolusu, this is a long-known hole in the EXPLAIN function. You are not directly referencing the child table in your query (so no EXPLAIN output related to the child table), but DB2 must check ...

I have a table (Fact table in a data mart) with 5 foreign keys; to allow Starjoin to be selected more frequently, I am considering 5 different indexes, each with all 5 columns, but also each with a di ...

Once again, Kolusu, you have come to the rescue!! With some additional modifications and a long time until I figured out the cause for a -408 value problem (the last two columns, representing the SQL ...

Very ingenious, and makes sense! I will report back as soon as I can try it. Thanks much again, Kolusu!!! Very Happy

Kolusu, you are so very close; the only problem with your example is that the "COUNT(*)" function is a count from a different table, and THAT is exactly why I'm trying to use the nested tabl ...

Thanks for the responses, programmer and Kolusu; programmer, the syntax still must be off, though I cannot see why; I get a -104 on the token "MIN" for your example. You are on the right tr ...

I always turn to Kolusu when all other sources fail!

I am trying to insert into an audit table of our own design. The idea is to name some identifying data about the row, then either a count value ...

Thanks, Kolusu; my nitty gritty work with DB2 has been limited lately, I knew this answer, but couldn't pull it from offline storage!! My buffers had been flushed!! Your help, as always, is apprecia ...

I've built a query that has been working fine, but the file is being transferred by SFTP (used to be a standard FTP), and the required CR/LF line termination that terminated each output line in the FT ...