List of Contributions

JAMES CAMPBELL

Contact Details

My Content

1 to 11 of 11 total

RE: Unload FROMCOPY using a select statement

Posted By JAMES CAMPBELL Mon April 12, 2021 01:57 AM
Found In Egroup: Db2 for z/OS & Db2ZAI \ view thread
Try: UNLOAD TABLESPACE . FROMCOPY FROM TABLE . WHEN ( ) ------------------------------ JAMES CAMPBELL ------------------------------

RE: LISTAGG not usable though FUNCTION LEVEL V12R1M501

Posted By JAMES CAMPBELL Thu September 24, 2020 01:25 AM
Found In Egroup: Db2 for z/OS & Db2ZAI \ view thread
Db2 might be at FL501, but are you? What does SELECT CURRENT APPLICATION COMPATIBILITY FROM SYSIBM.SYSDUMMY1 ; show? (Issued from your JDBC program, of course.) Possible solution: SET CURRENT APPLICATION COMPATIBILITY = 'V12R1M501'; before your SELECT. ------------------------------ ...

RE: .Net core 3.1 license-help-using-ibmdatadb2core-in-net-with-db2

Posted By JAMES CAMPBELL Mon September 14, 2020 07:11 PM
Found In Egroup: Db2 for z/OS & Db2ZAI \ view thread
This is really outside my expertise (I work on the z/OS side of the question), but there are several references to having an incorrect version of the license file. Such as https://www.ibm.com/support/pages/sql1598n-error-connecting-mainframe-db2-ibm-data-server-driver-even-though-db2-connect- ...

RE: Db2 trimming trailing blanks in table names in -601 SQLcode processing

Posted By JAMES CAMPBELL Tue August 25, 2020 01:51 AM
Found In Egroup: Db2 for z/OS & Db2ZAI \ view thread
SQL identifiers, "A delimited identifier is ... Trailing blanks in the sequence are not significant, although they are stored with the identifier." https://www.ibm.com/support/knowledgecenter/SSEPGG_9.7.0/com.ibm.db2.luw.sql.ref.doc/doc/r0000720.html and repeated up to 11.5 . Similar wording, except ...

RE: Explanation of Field QW0021DR: "COMMIT" / "COMMIT+1"

Posted By JAMES CAMPBELL Thu May 07, 2020 02:43 AM
Found In Egroup: Db2 for z/OS & Db2ZAI \ view thread
LOCK DURATION The lock duration: COMMIT Until commit (QW0021DR=x '40') COMMIT+1 Past commit; applies to locks needed to maintain the position for a cursor opened WITH HOLD (QW0021DR=x '41') https://www.ibm.com/support/knowledgecenter/SSUSPA_5.4.0/com.ibm.omegamon.xe.pm_db2.doc_5.4.0/ko2rr/ ...

RE: PL/1 Stored Procedured in DB2 Community Edition

Posted By JAMES CAMPBELL Tue May 05, 2020 03:10 AM
Found In Egroup: Db2 \ view thread
There's also https://sourceforge.net/projects/pl1gcc/ , but that appears to have stalled for many years. I recall reading somewhere that the developers have (or "had") problems dealing with the ability of ON blocks to return into the code from whence they were invoked. James Campbell ------ ...

RE: Question About IPL after applying PTF UI65806

Posted By JAMES CAMPBELL Fri March 13, 2020 10:02 PM
Found In Egroup: Db2 for z/OS & Db2ZAI \ view thread
UI65806 is a fix to the Early Code. You can implement it (while Db2 is down) by using -REFRESH DB2,EARLY. Note that -REFRESH uses only those libraries that were in the linklist at the last IPL. The -REFRESH produces a min-MEPL - check it has what you expect. ​ ------------------------------ JAMES ...

RE: DB2 query

Posted By JAMES CAMPBELL Thu February 20, 2020 05:02 PM
Found In Egroup: Db2 \ view thread
> I have one field with in DB2 View and that is character datatype. That field is having 3 kind of formats > > 1. 4MAR17 etc CASE WHEN field_is_in_format_1 THEN convert_to_desired_format ... ELSE '0000' END You can create the tests for deciding on the input format and the expression for ...

RE: DB2 z/OS - How to monitor SQLs running against database ?

Posted By JAMES CAMPBELL Mon January 20, 2020 01:28 AM
Found In Egroup: Db2 \ view thread
There are a number of monitoring programs that might be being used on the z/OS system - IBM's Omegamon, Brocade's (was CA) Sysview performance for Db2 (used to be known as Insight), BMC's Apptune and Mainview . Talk to the Db2 for z/OS system programmer to find out what they have. Generally DB2-L is ...

RE: Date query

Posted By JAMES CAMPBELL Mon December 23, 2019 09:21 AM
Found In Egroup: Db2 \ view thread
date(substr(abcd,1,4)||'-'||substr(abcd,5,2)||'-'||substr(abcd,7,2)) Note that the dashes say the date string is in ISO format - yyyy-mm-dd . Other date formats as USA with slashes - mm/dd/yyyy - and EUR with dots - dd.mm.yyyy. ------------------------------ JAMES CAMPBELL -------------------- ...

RE: Date query

Posted By JAMES CAMPBELL Mon December 23, 2019 09:21 AM
Found In Egroup: Db2 \ view thread
date(substr(abcd,1,4)||'-'||substr(abcd,5,2)||'-'||substr(abcd,7,2)) https://www.ibm.com/support/knowledgecenter/SSEPGG_11.1.0/com.ibm.db2.luw.sql.ref.doc/doc/r0000784.html Note that the hyphens say that the date string is in ISO format. Other formats are USA with slashes - mm/dd/yyyy - and EUR with ...