List of Contributions

Really does not answer the question. There are two situations: 1) user uses the various jar and zip files provided in the IBM Data Server Driver for JDBC and SQLJ or with Db2. Yes, license needs to be purchased. If for no other reason than the Connect won't really happen if there isn't a license and ...

Does a user *really* need a Db2 Connect License to access (using any method) Db2 for z/OS from a distributed environment? Or merely require a license to use IBM's JDBC drivers for a generic application? Is a Db2 Connect license required to use, for example, Data Studio (does this use the same JDBC ...

>For TSO-REXX subscribe / signoff / archive access instructions, send email >to LISTSERV@VM.MARIST.EDU with the message: INFO TSO-REXX But it seems to have been quiet for some time. James Campbell ------------------------------ James Campbell ------------------------------

For the record, the problem with TIMESTAMP(TO_DATE('2005-10-10', 'YYYY-MM-DD'), '00:00:00.000') is that the time portion should either have dots, not colons, as separators or be in USA format with no seconds portion and an AM or PM signifier. As others have used: '2005-10-10' is a standard date format ...

Are the CLIENT_USERID and CLIENT_WRKSTNNAME special registers actually set up? SELECT CURRENT CLIENT_USERID, CURRENT CLIENT_WRKSTNNAME FROM SYSIBM.SYSDUMMY1; ------------------------------ James Campbell ------------------------------

No such thing as a checksum of a table or of a row. There are HASH functions which can produce a checksum of a string. Map the result to a number, add the resulting numbers in a row and you'll have something approaching a checksum of a row. Add all of them together and that will be the closest you'll ...

"db2 oz version 11" is ... what? If you mean Db2 11 (for LUW) then I cannot help -apart from commenting that those who might would probably like to know if you mean 11.1 or 11.5 - it might make a difference. If you mean Db2 11 for z/OS - then the SYSCAT views are not maintained. Someone (not, as I ...