Home SELCOPY CBLVCAT SELCOPY/i Trial/Prices CBL SiteMap
 
Multiple Information Retrieval, Manipulation & Update for IBM Mainframe, iSeries, UNIX & PC Platforms
 
 

SELCOPY Product Suite 3.00 for z/OS

Maintenance to SELCOPY Product Suite for z/OS is distributed as service bundles of APAR fixes and PTFs and applied via SMP/E electronic delivery (FTP).

Each service bundle is referenced as Snnnnnnn or Xnnnnnnnn, where nnnnnnn is the service bundle number. "S" prefixed bundles contain APAR fixes (Zaps) only whereas "X" prefixed bundles contain PTFs (module replacements, etc.)

Please note that service packages X0000001 to X0000005 are included in the SELCOPY Product Suite 3.00 package id CBL11091.

Service application jobs and README documentation are itemised in the table below.

SELCOPY Product Suite for z/OS Service File Size Last Update
Service README 9,543 bytes 2011/09/23 15:29
SVCRFN 6,225 bytes 2011/09/20 15:01
FTPJOB 1,968 bytes 2011/03/18 10:45

Before beginning install of the SELCOPY Product Suite, please see the README text file for information on alternative methods of downloading and installing service.

Installation material electronic transfer methods are documented in detail in the README text file but are summarised as follows:

  1. Directly transfer the required service package materials from the FTP site to an HFS (or ZFS) directory on the z/OS host using either of the supplied job streams (FTPJOB or SVCRFN.) Whichever job is chosen, it should be copied to a member of a job library on the z/OS system, tailored for your local environment and submitted for batch processing. Job tailoring instructions are found in the comment data at the start of each member.

    FTPJOB simply uses the z/OS FTP client to transfer the package materials, whereas SVCRFN optionally performs the following additional tasks:

    • For SMP/E 34.09 or later, checks the SHA-1 package integrity.
    • Executes an SMP/E RECEIVE FROMNETWORK directly into the existing CSI (Consolidated Software Inventory) for SELCOPY Product Suite.

    The service bundle libraries (Xnnnnnnn and Snnnnnnn), including SMP/E HOLDDATA and RECEIVE, APPLY, ACCEPT jobs are found in the following directory of the CBL ftp server:

      ftp://ftp.cbl.com/Mainframe/mvs/smpe/smpnts

  2. If you are unable to FTP transfer the SMP/E service packages directly from the CBL FTP site to your z/OS host HFS directory (e.g. because of firewall restrictions), then the service package archives (zip or pax.Z) may be downloaded to your PC workstation as an alternative. Actions required following download of the two different archive formats are as follow:

    1. The zip archive must be unzipped to a folder of the Windows workstation before executing the supplied cblftpz.cmd Windows batch procedure to FTP the package material from the workstation to the z/OS host HFS directory.
    2. The pax.Z archive may be transferred from the Windows/Mac/Linux workstation to the z/OS host HFS directory and extracted using the z/OS Unix shell command, pax.

Service Package Archives   ZIP   PAX.Z
File Size Last Update Download File Size Last Update Download
X0000001 201,125 bytes 2011/01/21 14:50 ZIP      
X0000002 200,390 bytes 2011/02/04 14:36 ZIP      
X0000003 381,997 bytes 2011/02/15 13:47 ZIP      
X0000004 317,565 bytes 2011/03/17 15:57 ZIP      
X0000005 49,219 bytes 2011/03/24 15:04 ZIP      
X0000006 91,240 bytes 2011/09/13 15:07 ZIP 129,024 bytes 2011/09/23 12:32 PAX.Z
X0000007 275,026 bytes 2011/09/13 15:07 ZIP 354,816 bytes 2011/09/23 12:30 PAX.Z
X0000008 131,619 bytes 2011/09/13 15:07 ZIP 161,280 bytes 2011/09/23 12:30 PAX.Z
X0000009 54,858 bytes 2011/09/13 15:07 ZIP 64,512 bytes 2011/09/23 12:28 PAX.Z
X0000010 41,338 bytes 2011/09/13 15:07 ZIP 64,512 bytes 2011/09/23 12:28 PAX.Z
X0000011 136,991 bytes 2011/09/20 14:05 ZIP 193,536 bytes 2011/09/23 11:23 PAX.Z
X0000012 1,161,441 bytes 2011/12/05 16:31 ZIP 1,677,312 bytes 2011/12/05 16:31 PAX.Z
X0000013 190,673 bytes 2012/04/10 11:41 ZIP 258,048 bytes 2012/04/10 11:41 PAX.Z
X0000017 207,878 bytes 2012/09/03 16:32 ZIP 290,304 bytes 2012/09/03 16:32 PAX.Z

 
 

SELCOPY Product Suite 3.00 for z/VSE and z/VM

Maintenance to SELCOPY Product Suite for z/VM and z/VSE is distributed as a single .zip download containing MSHP batch jobs for VSE and ZAPTEXT input for VM/CMS. An MSHP job or ZAPTEXT input file applies service to one of the SELCOPY Product Suite components (i.e. SELCOPY, SELCOPY/i or CBLVCAT).

It is strongly recommended that all service is applied to the product components. However, if you choose to selectively apply maintenance, then please refer to the zap descriptions to determine whether service co-requisites and/or pre-requisites exist.

The following table contains a link to the latest SELCOPY Product Suite for z/VM and z/VSE maintenance .ZIP file.

Service Zip File ZIP File Size Last Update
SELCOPY Product Suite 3.00 for z/VSE and z/VM Maintenance 22,683 bytes 2012/10/04 12:23

 
 

SELCOPY Product Suite 3.00 Maintenance Summary

Product maintenance corrects known errors to SELCOPY/i, SELCOPY/batch and CBLVCAT components of SELCOPY Product Suite. The following table identifies SELCOPY Product Suite SYSMODs contained in each service package.

Service Package Id SYSMODs
X0000017 RS00019   RI00006
X0000013 RS00015
X0000012 RS00014   RI00003
X0000011 RS00013  
X0000010 RS00012
X0000009 RS00011
X0000008 RI00002
X0000007 RS00010
X0000006 RS00009
X0000005 RS00008
X0000004 RS00007
X0000003 RS00006
X0000002 RS00005   RS00004   RS00003   RS00002  
X0000001 RS00001   RI00001
 

The following tables contain descriptions of published PTFs to SELCOPY Product Suite 3.00 catogorised by product service package. APAR fix SYSMODs that have been superseded by a PTF are enclosed in parentheses beneath the PTF SYSMOD reference.

 
z/OS Service Bundle SMP/E SYSMOD Component Op Sys APAR Publish Date Description
X0000017 RS00019 SELCOPY/i z/OS IQ003329 IQ003328 2012/09/03
IQ003329:
Assembler macro ZZSNAME (alias CBLNAME) default for SELCOPY option SSysBlksize amended to be "Yes" so that SMS system determined blocksize is set and is used on output to blocked data set with BLKSIZE=0.

SSysBlksize=No (the previous default) means that records are unblocked when BLKSIZE=0.

IQ003328:
See also SELCOPY 3.00 PTF RI00006 (SQ11976) which is pre-requisite.

Assembler macro ZZSNAME (alias CBLNAME) undeclared SELCOPY option SMVSOutQSAM renamed as SMVSOutBSAM with default remaining as "No" (CBLSUSR1 x'02' off). PTF RI00006 interprets this as indication to use QSAM for output data set processing.

i.e. QSAM (not BSAM) processing is default for output sequential and PDS/PDSE library data sets.

RI00006 (QI00012 QI00013 QI00014 QI00015) SELCOPY z/OS SQ011978 SQ011976 SQ011969 SQ011959 2012/09/03
SQ011978
0C4 occurs for ADABAS processing following a call to SELCOPAD which has been link edited as AMODE(31) from the ADAUSER module supplied with ADABAS version 8 or later.

Same problem in previous release.

SQ011976
Correct performance degredation introduced by SELCOPY's BSAM processing for output data sets.

Use of BSAM to process records written to output data sets was introduced as the default for SELCOPY release 3.00. Although use of BSAM processing potentially reduces CPU time, the elapsed run-time may be increased significantly when writing large amounts of data.

Application of this PTF will disable default use of SELCOPY's BSAM processing, defaulting instead to QSAM processing as for previous releases.

BSAM output processing may be re-activated as the installation default using CBLNAME option SMVSOutBSAM=Yes.

SQ011969
ABEND U4088 Reason Code=63 may occur if more than one COBOL II routine is called in the same SELCOPY job.

SQ011959
Using SELCOPY's BSAM processing for output data sets, RECFM=V (Unblocked) format output data sets are potentially written with blocks containing more than 1 record. (By definition RECFM=V format data sets have one record per block with BDW = RDW+4.)
 
z/OS Service Bundle SMP/E SYSMOD Component Op Sys APAR Publish Date Description
X0000013 RS00015 SELCOPY/i z/OS IQ003031 IQ002867 IQ002866 IQ002865 IQ002864 IQ002863 IQ002860 IQ002856 IQ002853 IQ002851 IQ002848 2012/04/10
IQ003031:
Resolve open error on attempt to perform text or structured (SDE) EDIT/BROWSE of an IAM data set that is not catalogged in the ICF master catalog.

Also corrects report of VSAM information for IAM data sets in List Catalog (LC) and List Dataset (LD) windows.

Note that IAM V9.00 PTF P900120 or IAM 8.10 PTF P810278 are pre-requisite.

IQ002867, IQ002863, IQ002856,
IQ002853, IQ002851:
Compare Files Utility Enhancements:

  1. Support for Hierarchical Compare.
  2. REPORT output to a specified PDS/PDSE member, e.g. hlq.COMPFILE.REPORT(AB001), now correctly creates associated SDO with the same member name but belonging to PDS/PDSE library of type SDO, e.g. hlq.COMPFILE.REPORT.SDO(AB001).
  3. Batch execution of COMPFILE now has default report:

       %racfuser%.SELCOPYI.COMPFILE.REPORT
    

IQ002866:
For IPO panels, syntax generation for a file object that refers to a physical sequential data set should ignore any member name specified.

IQ002865:
Correct SDE EDIT/BROWSE of a new PDS/PDSE member where the library DSN matches the DSN of an existing Physical Sequential data set.

Now returns the following error message on EDIT/BROWSE:

  ZZSD411E A member name was specified for an existing
           sequential dataset.

IQ002864:
Correct SDE EDIT/BROWSE display of packed numbers whereby the sign and decimal point were not displayed when the packed decimal field is defined with an odd precision value which is equal to the scale.

IQ002860:
Correct loop in List Window types where prefix command "=" is used twice with no previously entered prefix command.

IQ002848:
Correct File Search/Update/Copy/Remap facility so that records are no longer reported for FIND search string falling outside the specified bounds

 
z/OS Service Bundle SMP/E SYSMOD Component Op Sys APAR Publish Date Description
X0000012 RS00014 SELCOPY/i z/OS IQ002847 IQ002844 IQ002841 IQ002837 IQ002836 IQ002835 IQ002834 IQ002832 IQ002831 IQ002830 IQ002828 IQ002827 IQ002826 IQ002825 IQ002824 IQ002822 IQ002821 IQ002819 IQ002818 IQ002817 IQ002814 IQ002812 IQ002810 IQ002809 IQ002808 IQ002807 IQ002806 IQ002805 IQ002804 IQ002802 IQ002800 IQ002798 IQ002796 IQ002795 IQ002794 IQ002793 IQ002792 IQ002791 IQ002790 IQ002788 IQ002784 IQ002783 IQ002782 IQ002781 IQ002779 IQ002777 IQ002775 IQ002774 IQ002773 IQ002772 IQ002771 IQ002770 IQ002769 IQ002768 IQ002765 IQ002763 IQ002762 IQ002758 IQ002757 IQ002756 IQ002755 IQ002753 IQ002752 IQ002751 IQ002750 IQ002749 IQ002747 IQ002746 IQ002745 IQ002744 IQ002743 IQ002742 IQ002740 IQ002737 IQ002736 IQ002735 IQ002733 IQ002731 IQ002729 IQ002728 IQ002727 IQ002723 IQ002718 IQ002715 IQ002713 IQ002707 IQ002705 IQ002704 IQ002703 IQ002702 IQ002701 IQ002700 IQ002690 IQ002688 IQ002686 IQ002677 IQ002674 IQ002673 IQ002672 IQ002670 IQ002664 IQ002663 IQ002662 IQ002661 IQ002656 IQ002655 IQ002646 IQ002641 IQ002640 IQ002639 IQ002638 IQ002617 IQ002613 IQ002609 IQ002605 IQ002565 IQ002551 IQ002540 IQ002519 IQ002488 IQ001978 2011/12/05
IQ002640, IQ002744, IQ002772,
IQ002798, IQ002800, IQ002831:
Enhanced Compare File facility.

This includes support for new "Compare Files" panel accessed via the "Utilities" drop menu, list prefix command "CF" or line command COMPFILE.

COMPFILE also supports parameters that allow full function execution from via the command line or CMDTEXT.

The Compare Files utility allows the compare of NEW and OLD versions of a file, with options that include support for the following:

  1. Specify the start record.
  2. Restrict the number of records compared.
  3. Restrict the number of differences reported.
  4. Restrict the comparison to specified areas of each record.
  5. Re-synchronise record pairs following a mismatch.
  6. Specify key segments (at the record-type level) that allow the utility to identify 'corresponding pairs' of records.
  7. Control how re-synchronisation should occur following detection of an inserted or deleted record.
  8. Apply a structure (copybook) overlay to map records, and optionally restrict the comparison to specified record-types and/or named fields. This is known as a "formatted compare".
  9. Apply different structures to the NEW and OLD files, with comparison restricted to fields that exist in both structures. This allows comparison of files where corresponding fields are of different data-type, length and/or location within NEW and OLD records.

See Help for the Compare File panel and COMPFILE line command for details of use and report output. Alternatively, view the SELCOPY/i Compare Files Utility PDF document.

IQ002713, IQ002718, IQ002745,
IQ002749, IQ002750, IQ002751,
IQ002752, IQ002753, IQ002755,
IQ002756, IQ002757, IQ002758,
IQ002779, IQ002791, IQ002792,
IQ002796, IQ002812, IQ002814,
IQ002818, IQ002819, IQ002821,
IQ002822, IQ002824, IQ002825,
IQ002826:
Structured data edit (SDE) support for FILTER on BROWSE and EDIT. This allows the user to restrict the load of records to only those assigned a specific record-type (for formatted display with a structure or copybook) and also satisfy criteria specified by an optional WHERE <expression>.

FILTER is particularly useful where FOR #recs is specified (which forces in-storage edit) and the number of records (#recs) to be loaded exceeds available storage.

This update also introduces support for built-in function calls so enhancing support of SDE expressions used by line commands USE WHEN, RCOLOUR, LOCATE, WHERE, EDIT FILTER and BROWSE FILTER. See SDE Help for description of SDE expressions.

The SDE Edit/Browse panel now has menu item FILTER to open the "Create Filter" panel (also started via the FILTER line command.)

See Help for the Create Filter panel and SDE EDIT and BROWSE line commands for details of use.

IQ001978, IQ002810:
Structured data edit (SDE) enhanced support for record-type assignment via the SDE Edit/Browse Utility window and USE CLI command.

USE <rectype> <ALWAYS>
Assign rectype to all records.

USE <rectype> NEVER
Exclude rectype from any automatic assignment processing.

USE <rectype> WHEN
No <expression> specified following WHEN will now remove any existing WHEN <expression>.

USE <rectype> FOR FOCUS RECORD <OFF>
Assign rectype to record on focus line.

IQ002639:
Structured data edit (SDE) support for command RCOLOUR which allows colouring of records assigned a particular record-type which also satisfy a specified WHEN <expression>.

  RCOLOUR <rectype> <colour> <highlight> WHEN <expr>

IQ002705:
Support has been introduced for Innovation Access Method (IAM) data sets. These types of data set are sequential data sets that are processed as VSAM data sets.

SELCOPY/i supports use of IAM files for text edit/browse, SDE edit/browse, File Search and Update, File Copy and File Compare. Furthermore, catalog lists and dataset details lists display IAM data set entries as being DSORG VSAM.

IQ002774:
SELCOPY/i universal support of standard GDG generation data set name notation. i.e. for text edit/browse, SDE edit/browse, File Search and Update, File Copy and File Compare. e.g.

  EDIT  NBJ.GDG01(-1)

IQ002736:
Structured data edit (SDE) support for command LOCATE has been enhanced so that a field name (or field reference) may be specified as the target of the locate. In both table view format and single view format the display will be scrolled to the relevant field. i.e. LOCATE <field_name> PREV/NEXT/FIRST/LAST.

IQ002488:
DB2 CREATE STORAGEGROUP panel has been corrected so that an asterisk entered in the Volume Serial Number field to indicate SMS volumes, is enclosed in in apostrophes/single quotation marks (i.e. '*').

IQ002655:
Correct RS00007 (PTF in Error) change brought about by APAR IQ002548 which caused the "Favourites" panel (FAV) to become unresponsive.

IQ002540:
Help window displaying information about the running version of SELCOPY/i ("Help" menu item -> "About") now displays the CBL copyright string.

IQ002641:
All menu items that still referred to the old product name "CBLi" have now been updated to refer to "SELCOPY/i".

IQ002638:
Any subtask generated by CBLIVTAM for a user now propagates the user ACEE to the subtask. Previously, the ACEE of the userid assigned to the CBLIVTAM started task was used. This most often resulted in the user having more restrictive access privilages than might be expected by that user.

IQ002613:
Correct a 0C7 program check that can occur when converting a packed decimal value to display numeric and the given output length parameter is supplied as being greater than 255 (X'FF') characters.

IQ002673:
Structured data edit (SDE) LIST MODULES command (used for CBL diagnostics) has been enhanced to support a SELCOPY/i library module name parameter (default SDELIB.)

IQ002686:
Correct 0C4 in CBLDLL that occurs when attempting "System Edit" (command SYSEDIT) to switch to ISPF edit of a data set currently in a CBLe text edit view which has an exclusive SPFEDIT ENQ set by another user.

IQ002769:
Correct "Compare Libraries" item in "Utilities" menu bar so that it opens the "Compare Library Members" dialog instead of the "Compare Files" dialog.

IQ002770:
Correct possible abend in CBLDLL which occurs when attemptin SDE browse/edit of a non-existant file.

IQ002775:
For structured data edit (SDE), correct an 0C4 program check that occurs on execution of a PFKey assigned the attribute "BEFORE" when modifications exist to the data in the SDE edit view.

IQ002656, IQ002727:
Intial startup of SELCOPY/i for new users has been improved so that the user is no longer prompted to make selections about their SELCOPY/i environment.

Default values are assigned based on the user's TSO login id and options set in the SELCOPY/i Site INI file.

A further presumption is made that the user has authority to allocate new data sets with the prefix specified for System INI option, System.UserINIFile, and that SMS automatic class selection will occur for SMS storage group. If this is not the case, then allocation of new data sets will fail and the user will be prompted to enter new dataset allocation values (Volser).

Any default values that are automatically assigned may be updated by the user at a later time and as required.

IQ002805, IQ002763:
Correct an 0C4 program check that may occur when changed data exists in multiple SDE edit views of the same data and command FILE is executed.

IQ002768:
CBLVCAT Raw data list has been corrected so that the RECFM column now has width 3 instead of 2 which resulted in truncation of some record format descriptions. e.g. truncating FBS to FB.

IQ002690, IQ002746, IQ002777:
Updates to the window display when operating in maximised mode:

  1. Non-SDE or text edit MDI child windows no longer show the edit status bar.

  2. The MDI client area size is now recalculated if window focus is on an MDI child window that has its own menu bar. This is because the menu bar now occupies the MDI parent window menu bar.

  3. List windows now use the two free blank lines before the status line.

  4. Modal dialog windows for defining new VSAM data sets can now be open in maximised mode. Also, the action buttons at the bottom of modal dialog windows are no longer obscured when displayed on a 24x80 screen.

IQ002551, IQ002661, IQ002677,
IQ002700, IQ002701, IQ002702,
IQ002731, IQ002782, IQ002783,
IQ002784, IQ002793, IQ002795,
IQ002802, IQ002808, IQ002609:
Enhance support for interactive panel (IPO) windows (window class WINWIPO0).

IPO windows are used for any new dialag panel introduced in SELCOPY/i which currently includes SELCOPY/i DB2 panels, Compare File, SDE Edit and Create Filter. Future development will see existing panel windows converted to IPO panels.

IQ002646, IQ002674, IQ002715,
IQ002762:
Correct the following File Search and Update facility issues:

  1. An FSU command line parameter is ignored if it immediately follows an OUTPUT, REPORT or USING parameter that specifies a quoted fileid. e.g. FIND is ignored in the following:

      FSU  REPORT 'JGE.FSURPT'  FIND('ABC') INP(JGE.*)
    
  2. If a COBOL/PL1 copybook (not an SDO) is applied for formatted record file update, then the generated SDO report output is not saved when selected to do so by the user.

  3. Re-edit of a report generated for a formatted record file compare does not correctly identify record-types by implementing USE WHEN criteria to the report SDO.

  4. From the File-Search/Update (FSU) panel, corruption of the generated command occurs when entries in the "Column SELECT" field are of length > 50 characters

  5. ZZSD009E Invalid operand occurs if FSU command includes specification of a PDS/PDSE member which is an FSU keyword. e.g. NEW, REPLACE, etc.

IQ002662, IQ002663:
For structred data edit (SDE), fix a possible abend in SDELIB when edit/browse is performed using a COBOL/PL1 copybook.

Also fixes abend that occurs if SDE edit/browse of a library DSN is specified without a member, invoking a member selection list, and the second or subsequent member is selected.

IQ002817:
Zoomed List windows have been enhanced so that the list entry name, value and description are displayed and the width adjusted to show the full data width if possible.

IQ002807:
SELECT command from a LIST window has been enhanced to support mimimal abbreviation of field names.
e.g. From a LISTDATASET window... Command:

  select Entry,Org,Trks,Pri,Alu,Sec,*

may be abbreviated to:

  sel e o tr p a s,*

IQ002670, IQ002703, IQ002704,
IQ002707, IQ002723, IQ002728,
IQ002729, IQ002733, IQ002735,
IQ002740, IQ002742, IQ002743,
IQ002773, IQ002737, IQ002747,
IQ002765, IQ002771, IQ002781,
IQ002664:
Corrections to miscellaneous structured data edit (SDE) issues, notably:

  1. INSERT of a new formatted record, which is of a record-type containing zoned decimal fields, no longer primes these fields with X'00' which caused prefix area condition =ERRV> and error ZZSD368I on attempting to modify the record.

  2. INSERT of a new formatted record, now primes each field with a value that adheres to the field's defined constraints. e.g. a COBOL field defined with OCCURS 3 TO 7 will be primed with 3 by default.

  3. INSERT a record of a specific record-type now implicitly sets DRECTYPE to that record-type.

  4. Correct potential loop caused by the distributed SDE edit/browse profile macro, SDEPROF, and macro SDESHRNK.

  5. SDEPROF now returns error message ZZSD015E if LOCATE is performed on edit of a non-existant file.

  6. In an SDE window view, correct display of variable arrays with dimension size defined by a packed decimal or zoned decimal field. Before this fix was introduced, array was displayed with zero elements.

  7. SET UNNAMED OFF option is now reflected in a single record format SDE view.

  8. Display of shadow lines are now hidden immediately following execution of SET SHADOW OFF ALL where the focus line is "Top of data" (record 0).

  9. SDE selective editing commands ALL, EXCLUDE ALL, LESS, MORE, ONLY, WHERE are no longer erroneously disabled for SDE DB2 table browse/edit.

  10. SET DSORG RRDS now works as documented for data in an SDE window view.

IQ002809:
In list-windows (e.g. LISTDATASET), where a key field (e.g. ENTRY) is selected but is not the first field selected, then sort of that column did not work.

IQ002805:
In list-windows (e.g. LISTALLOC), consecutive entries which duplicate key values (e.g. DDName) now display with ditto sign (x'7F') in pos 3, instead of being completely blanked out.

IQ002828:
Command "BROWSE MY.DATASET USING MY.SDO" no longer treats "MY.DATASET USING MY.SDO" as the dataset name.

IQ002688:
Correct 0C1 program check that occurs in CBLDLL when executing a STRIP trailing function for a z/Architecture CPU that does not have Extended Translation Facility 3 installed. (STRIP uses the TRTR instruction.)

IQ002804:
IPO Menu bar items were not "tabbable" when in maximised state.

IQ002830, IQ002832, IQ002834,
IQ002835:
CBLe macro DSQL introduced and macro DCMD updated to provide shorthand method of invoking the SELCOPY/i DB2 "Execute SQL statements" and "Execute DB2 command" panels.

Parameters for both DSQL and DCMD:

-SSN <ssn_name>
Specifies the DB2 sub-system to which the SQL statement or DB2 command will be passed. If DB2 Primary Option panel exists with a connection to <ssn_name>, then this connection is used (i.e. no new connection is made.)

Default is the last sub-system to which a connection was made via the DB2 Primary Options panel.

-LIMit <n_rows>
Limit the number of rows to be displayed in the Execute SQL panel following a SELECT transaction or the number of bytes used for the Execute DB2 command response buffer.

<sql_syntax> | <db2_cmd>
The remainder of the DSQL or DCMD input parameter string is treted as the SQL statement or DB2 command stream respectively.

Also increases maximum support SQL command length from 512 to 32000 bytes.

IQ002837:
Dialog panels should not react to the ENTER key when it is in the maximise, minimise or restore buttons.

IQ002828:
Support for rudimentory program SDEASEQ1 to generate SELCOPY EQUate statements from a SELCOPY/i SDE structure, COBOL or PL1 Copybook/ADATA file.

Input parameters are:

  1. Selected record type in the structure/copybook from which to generate the EQU statements. Alternatively, specify "ALL" to use all record mapping definitions.
  2. Source structure/copybook type ADA/COBOL/PL1/SDO.
    ADA - COBOL or PL1 ADATA data set.
    COBOL - COBOL copy book.
    PL1 - PL1 include file.
    SDO - SELCOPY/i generated structure.
  3. Complete DSN of one or more structure/copybook data sets each separated by a comma (,).

e.g.

  PARM='ALL COBOL NBJ.COB(REPLACE), NBJ.COB(CBYBOOK)'

EQUates are written to dataset allocated to ddname SELCEQU

IQ002844:
OPTIONS command parameter default is now EDIT. Also corrects OPTIONS EDIT output so that the HELP command is reinstated.

IQ002847:
Correct RS00010 PTF in error wherby SDE CHANGE ALL with bounds set changes one more occurence than it should. This error was introduced by IQ002625.
RI00003 (QI00011 QI00008) SELCOPY z/VSE SQ011950 SQ011939 2011/11/24
SQ011950
0S03I PROGRAM CHECK INTERRUPTION at SELCOPY+01E052E usually when SELCOPY is run in a small partition.

SQ011950
ERROR 642 - VSE VOL NOT FOUND/MOUNTED may occur on CA-DYNAM/D managed file I/O. Caused by SELCOPY file label SYS/volser checking prior to OPEN where no extent information exists.

Although only a recommendation in CA-DYNAM/D documentation, in order for this zap to operate successfully ££BDYD££,MOVE must be added to the SET SDL in the ASI procedure.

Same problem in Release 2.02 with Zap 01 applied.

RI00003 (QI00010 QI00009) SELCOPY z/OS SQ011947 SQ011945 2011/11/24
SQ011947
IEC340I, IEA705I, ERR574, ERR509 and other possible errors relating to storage acquisition may occur for BSAM I/O. Symptoms manifest particularly where dynamic allocation is used on a generic output DSN (DSN=n AT p syntax) and an OPEN is performed many times during the SELCOPY execution. e.g. one OPEN each for a large number of output data sets.

SQ011945
MVS data set UPDATE-in-place uses the prevailing LRECL value to move record data to the I/O buffer. This has the potential to omit data for update that occupies positions between the current LRECL value and the length of the current update file record.

With Zap 09 applied, if no length is specified on an UPDATE statement for an MVS non-KSDS data set, then the length of the update record and not the prevailing LRECL value is used to move data to the I/O buffer. Note that this zap does not apply to KSDS data set records whereby the record length may be altered by an UPDATE-in-place operation.

Same problem in previous release.

 
z/OS Service Bundle SMP/E SYSMOD Component Op Sys APAR Publish Date Description
X0000011 RS00013 SELCOPY/i z/OS IQ002714 IQ002712 IQ002697 IQ002685 IQ002683 IQ002681 IQ002680 IQ002679 IQ002669 IQ002667 IQ002665 2011/09/20
IQ002665:
Display of SDE columns should be sensitive to 'REF OFF', 'TYPE OFF' etc when determining minimum display width.

IQ002667:
In SDE edit/browse, FIND failed to find negative values in signed numeric fields.

IQ002669:
In SDE edit/browse, the LESS command doesn't refresh screen. i.e. needed to issue a scoll command before it appeared to have worked.

IQ002679:
ZZSD329E FCOPY: "From" dataset does not exist. when from dataset referred to to an HFS path.

Problem also affected FSU with output to an HFS file that didn't already exist.

IQ002680:
In an HFS copy of a JCL deck that is technically LRECL=32760 scrolling is super slow due to many LCOLOUR/SCOLOUR commands set by COLSET (especially for JCL) that use ARBCHAR (wildcard chars).

Solution is for COLSET to set ZONE 1 80 for the SCOLOUR/LCOLOUR commands.

IQ002681:
DSN macro used an upper cased version of fileid at cursor, which was useless for HFS files.

IQ002683:
'C' (Copy) prefix command used uppercased version of fileid when attempted from a HFS LISTPATH (LP) list window.

IQ002685:
The FCOPY parameter STARTxxx was ignored when the BATCH parameter was also supplied.

IQ002697:
In maximised mode, IPO context sensitive help hits the help file a few lines below the intended target.

IQ002712:
The following SDE selective editing commands are restricted when the whole file is not loaded into storage.
  ALL
  EXCLUDE ALL
  LESS
  MORE
  ONLY
  WHERE

However, this restriction should not be applied when "FOR nnn" is specified, in which case all nnn records are loaded and kept in storage.

e.g. To see only the records containing the character 'M' in position 1, of the first 10000 records of a large file, on the SDE panel specify:

  FOR:     10000 # records
Then issue the command:
  ONLY c'M' 1
IQ002714:
0C4 at SDEFMSG0+02BC from
 <SData Edit   _                       \
         VOLUM1:CBL.TEST.FILE          \
   UPDate                              \
    FOR  10000  records                \
 |||||||||||||||||||||||||||||||||||||||
when dataset CBL.TEST.FILE does not exist on volume VOLUM1.
 
z/OS Service Bundle SMP/E SYSMOD Component Op Sys APAR Publish Date Description
X0000010 RS00012 SELCOPY/i z/OS IQ002695 2011/09/02
IQ002695:
With SYSMOD PTF RS00008 applied, 0C4 occurs in the unusual case that UserIniFile=ddname is specified in the SELCOPY/i System ini file.

 
z/OS Service Bundle SMP/E SYSMOD Component Op Sys APAR Publish Date Description
X0000009 RS00011 SELCOPY/i z/OS IQ002689
IQ002687
IQ002662
2011/08/04
IQ002689:
Expand Structured Data Edit (SDE) support for datatype zoned-decimal to fields of length greater than 16 bytes.

IQ002687:
New REXX (edit macro) tool SELCEQU added. SELCEQU will generate SELCOPY/batch EQU statements from an SDO, ADATA or COBOL/PL1 copybook.

Format:
SelcEqu  rec-type  <ADA|COBOL|PL1|SDO> structure_file
         ALL                      ---

IQ002662:
SDE edit/browse of a library without member name, using an SDO causes a member selectionbox to appear.

Selection of a member works first time, but second fails, with potential program check at SDEFSEO3+122.

e.g.
<sd e                            CBL.FDD.DATA       \
                   using      cbl.cbli.SDO(FDDOLD)  \
|||||||||||||||||||||||||||||||||||||||||||||||||||||

The same program check can also occur when SDE edit/browse is performed directly from a COBOL/PL1 copybook.

e.g.
<sd e CBL.IQ002689.TEST1                            \
      using cobol CBL.SDE.COPYBOOK.COBOL(IQ002689)  \
|||||||||||||||||||||||||||||||||||||||||||||||||||||

 
z/OS Service Bundle SMP/E SYSMOD Component Op Sys APAR Publish Date Description
X0000008 RI00002 (QI00003 QI00004 QI00005 QI00006 QI00007) SELCOPY z/OS SQ011919 SQ011920 SQ011931 SQ011932 SQ011933 2011/08/02
SQ011933:
ERROR 077 - VSAM OPEN FAILURE or input file treated as empty if CBLNAME option SVsamRc160=Empty is set, when a non-ESDS VSAM file is read using the ESDS keyword.

SQ011932:
IEC020I 001-1 abend may occur when DIRDATA input of a library member that is already open for output under a different DD name, and CBLNAME option SError584=No is in effect. "ERROR 502 - INP BLK NOT MULT OF LRECL" may also occur.

SQ011931:
BLKSIZE on SELCOPY WRITE statement is ignored for output to data set with DISP=NEW. BLKSIZE on WRITE to sequential data set should override any BLKSIZE found in the VTOC DCB if DISP=NEW/OLD is specified.

Also, BLKSIZE is incorrectly updated for all PDS library or DISP=MOD/SHR sequential data set output if CBLNAME option SError582=No is set.

SQ011919:
0C4 abend may occur where a CALL statement to a COBOL II routine is performed following a CALL to a non-Language Environment routine.

SQ011920:
0C1 or ERROR 503 (RC=44) Output LRECL too Large may occur for output to RECFM=VBS data set.
 
z/OS Service Bundle SMP/E SYSMOD Component Op Sys APAR Publish Date Description
X0000007 RS00010 SELCOPY/i z/OS IQ002582
IQ002623
IQ002624
IQ002625
IQ002626
IQ002627
IQ002628
IQ002629
IQ002630
IQ002633
IQ002635
IQ002636
2011/05/04
IQ002582:
FILE Search/Update/Copy (FSU) facility has been updated so that performing copy of a data set or PDS/PDSE member which involves one or more CHANGE operations, now supports changes in the resulting record length. e.g.

 <Fsu _                                    \
  CHANGE (                                 \
          (TEXT ALL  'Nicholas' 'Nick'  )  \
           AND                             \
          (TEXT ALL  'Jim'      'James' )  \
         )                                 \
  INPUT  (CBL.IQ002623.ORIG)               \
  OUTPUT  CBL.IQ002623.UPDATED             \
 |||||||||||||||||||||||||||||||||||||||||||

Output data set allocated record format and maximum length restrictions still apply.

IQ002623:
SDE edit view potentially displays an invalid record length (greater than the edited data set's allocated LRECL) in the "Length" field (RECLEN ON). This occurs following a successful CHANGE TEXT command where the replace string is longer than the search string and where trailing blanks are absorbed in the updated record.

IQ002624:
An FSU CHANGE operation, which changes ALL occurrences of the specified search string to a longer replace string, uses the original location of a found string instead of its location following a previously successful find/replace operation.

Therefore, where a search string has multiple hits in the same record, the replace string will overwrite incorrect locations for the second and subsequent hits. e.g.

   FSU  INP(CBL.TEST)  C('IN' '1234' ALL TEXT)

           <---+----1----+----2----+----3----+
 Before -> * BEGIN WHEN ITS TIME TO BEGIN
 After  -> * BEG1234 WHEN ITS TIME TO B1234IN

IQ002625:
SDE CHANGE ALL for variable length unformatted records fails when changing a search string to a longer replace string if there is more than one occurrence of the search string on a record and one of the occurrences of that string is shifted right beyond the original record length.

IQ002626:
Following an upgrade to release 3.00 of SELCOPY/i from a previous release, causes the user's TSO session to become unresponsive if SELCOPY/i is started in a terminal of less than 26 displayable lines (i.e. a 24x80 Model 2).

FIRSTUSE is executed automatically the first time a user starts SELCOPY/i following an upgrade. Prior to this PTF, a non-scrollable message window identifying new facilities would be displayed which exceeded the 24 line depth. The effect was that the user could not continue normally and the TSO session became unresponsive.

IQ002627:
SYSTASK list output now includes user and group name information for each task in the address space.

IQ002628:
In order to match ISPF 3.4, list cataloged files (LC) and list dataset details (LD) windows now include a selection field, AllVols>, with supported values Y or N. This field controls whether or not a file entry for each volume of a multi-volume dataset is displayed.

The report field, VTot, has also been introduced for these types of lists in order to display the total number of volumes on which the file is allocated.

IQ002629:
The userid of the CBLIVTAM job owner is used as the SQLID when performing DB2 tasks (SELECT, etc.) in a SELCOPY/i VTAM environment. This results in DB2 AUTH errors during the connection process. e.g. SQL errors -551, -553.

See cataloged procedure ZZSPVTAM for execution of SELCOPY/i as a stand-alone VTAM application (CBLIVTAM).

For batch address spaces the default action of the DB2 connection process is to use the JOB level user id, rather than any task associated ACEE user id, as the primary authorisation id of the connection.

This PTF introduces a new sample library member, ZZS3SATH, which may be used to update the DB2 connection authorisation exit, DSN3@ATH.

The modification implemented in ZZS3SATH only changes the default processing of the authorisation exit when the DB2 connection is attempted in a batch address space from a subtask of the program CBLAVTAM. (i.e. SELCOPY/i under VTAM.)

The basic source for ZZS3SATH was copied from DSN910.SDSNSAMP(DSN3SATH) and modified. No lines have been changed or deleted. Added lines have IQ002629 in column 64.

The DB2 administrator should first verify whether this exit has already been modified on operational DB2 subsystems. If so, the inserted lines in ZZS3SATH sample member should be carefully merged with the existing, tailored source.

Installation specific DB2 exit management standards (e.g. SMP/E USERMOD) should be used to assemble and link edit the exit source as DSN3@ATH (as required by DB2) into the appropriate DB2 subsystems' user exit libraries.

Note that exit DSN3@ATH must be available to the DB2 master address space and the DB2 subsystems must be restarted in order that changes take effect.

IQ002630:
Correct 0C4 abend which occurs if an IPO window is closed using the close button in the title bar while in the same interaction the user has modified any input fields in the panel.

IQ002633:
DSN CBLe macro updated so that option "6. Structured Browse/Edit Dialog" correctly updates the data set name in the SDE Browse/Edit dialog window.

IQ002635:
Correct error where closing a message box that was displayed in such a way that its buttons were not visible, causes the parent window to become unresponsive to messages.

IQ002636:
Execution of an FSU line-command (typically using PF4 (CMDTEXT) from the user's HOME command file) that has one or more additional commands chained using the command separater character (default is semi-colon) e.g.

 <SData Fsu _                         \
   FIND   (                           \
           SEO_FsuInp                 \
          )                           \
   INPUT  (                           \
           CBL.CBLI310.ASM(sdef*)     \
          )                           \
 ;sd sel z HOLD,*  from Hit           \
 ||||||||||||||||||||||||||||||||||||||
resulted in ...
 +-----------------------------------------------------+
 | CBLi System Command                               x |
 |                                                     |
 |  !  Command SdeShrnk                  ended with    |
 |     return code 20.                                 |
 |                                                     |
 |                         OK                          |
 |                                                     |
 +-----------------------------------------------------+

 
z/OS Service Bundle SMP/E SYSMOD Component Op Sys APAR Publish Date Description
X0000006 RS00009 SELCOPY/i z/OS IQ002606
IQ002607
IQ002608
IQ002610
IQ002612
IQ002615
IQ002620
IQ002621
2011/04/12
IQ002606:
HELP menu now refers to "SELCOPY Batch" and "CBLVCAT Batch" items to distinguish SELCOPY and CBLVCAT components of the SELCOPY Product Suite as batch products.

IQ002607:
SELCOPY/Debug SYSIN window did not initially show PF key definitions at bottom of screen.

IQ002608:
COLSET macro, which applies context sensitive string colouring, suports an SLC parameter for SELOPY control statements.

This is now automatically applied if SELCOPY sysprint output is recognised.

IQ002610:
Text edit REXX macro HH, if not provided with a string, should act on the cursor token.

IQ002612:
DB2 List Tables support for prefix command "SC" to create SELCOPY/batch jobs (via FILEUTIL macro) added.

IQ002615:
VOLSTATS window is not flagged as being an MDI child window and so is always on top of the window display.

VTOC and VTOC Extent lists generated from VOLSATS menu items do not open as MDI child windows.

IQ002620:
SDE 'EXTRACT /FVALUE fieldname/' failed for mixed case field names. This was evident when using COLCOPY/COLPASTE macros to copy values from fields with mixed case names.

IQ002621:
SELCOPY/i became unresponsive after focus had been placed onto another window while the SELCOPY/debug invocation panel was being displayed. SELCOPY/debug invocation panel is now intentionally modal.

'File' menu items:
Execute SELCOPY ...
Execute CBLVCAT ...

replaced with
SELCOPY Debug/Dev ...
CBLVCAT Interactive ...

 
z/OS Service Bundle SMP/E SYSMOD Component Op Sys APAR Publish Date Description
X0000005 RS00008 SELCOPY/i z/OS IQ002602
IQ002600
IQ002599
IQ002598
2011/04/01
IQ002598:
SDESHRNK macro to shrink the width of an SDE view to fit fields belonging to the 1st record type has been updated so that it is always actioned.

Previously, no action was taken unless the INI variable %user.SDE.ZCols% was set. This variable was only ever set by the SDE panel on releases of SELCOPY/i prior to 3.00. (e.g. "Window Rows: 50 x Columns: 124") Therefore, any 1st-time user on SELCOPY/i 3.00 would never benefit from this feature.

IQ002599:
FCOPY Dialog to copy a PDS member to a new, unallocated sequential data set opens an Allocate Non-VSAM dialog window for the new data set.

FCOPY now allows the user to update the Type field to be SEQ. Previously, FCOPY would only allow the same DSORG as the source data set. (i.e. PDS or PDSE.)

IQ002600:
A 0C4 abend at EDTFREX1+0492 that occurred during initial configuration of SELCOPY/i when executing FIRSTUSE SITE, has been corrected.

Condition arose on an attempt by the installer to follow a non-standard upgrade path from SELCOPY/i 1.70 to SELCOPY Product Suite 3.00.

IQ002602:
RACF error message and failed OPEN occurs on startup of SELCOPY/i when the System INI data set has been migrated. Problem was caused by failure by SELCOPY/i to wait for the data set to be recalled, following its dynamic allocation, before attempting the OPEN.

SELCOPY/i has been corrected to first detect whether the data set is migrated and, if so, recall it before performing the dynamic allocation.

 
z/OS Service Bundle SMP/E SYSMOD Component Op Sys APAR Publish Date Description
X0000004 RS00007 (QS00021) SELCOPY/i z/OS IQ002546
IQ002547
IQ002548
IQ002549
IQ002550
IQ002552
IQ002553
IQ002554
IQ002555
IQ002556
IQ002557
IQ002558
IQ002559
IQ002560
IQ002563
IQ002566
IQ002568
IQ002572
IQ002573
IQ002577
IQ002578
IQ002579
IQ002580
IQ002583
IQ002584
IQ002585
IQ002586
IQ002589
IQ002593
IQ002595
IQ002597
2011/03/17
IQ002546:
Allow only FORMAT TABLE and FORMAT SINGLE for DB2 EDIT and browse.

Use of FORMAT CHAR or FORMAT HEX to display DB2 table rows without column formatting is no longer permitted.

IQ002447:
The COMPFILE utility has been corrected so that specification of "=" (equals) as the 2nd compare fileid PDS member name, may immediately be followed by the closing ")" (right parenthesis).

Previously this condition would return the following error message...

   ZZSD007E Operator ) cannot follow operator =.

IQ002548:
Commands originating from a REXX IPO procedure should be passed to any list or table object in the current view if not recognised as an IPO command.

IQ002549:
The following prefix commands have been updated or added for use in DB2 Lists of Tables, Aliases, Columns, Synonyms and Views:

B - (exists) Now starts Browse dialog (like E).
BI - (new) Browse Immediately bypassing panel.
EI - (new) Edit Immediately bypassing panel.

IQ002550:
Correct a rare 0C4 abend at SDEFWIN2+x'848' which occurs when scrolling through records displayed in SDE single record (zoomed) view having previously performed a CHANGE command.

IQ002552:
The following prefix command has been added for use in DB2 List of Tables:

XL - List indexes.

IQ002553:
For DB2 List windows, garbage text displayed to the right of data in a single (zoomed) view is removed.

IQ002554:
Following execution of a DB2 list prefix command that results in open of a new window, then subsequent execution of PF3 to close the window now positions the cursor back at the original list entry from which the prefix command was issued.

IQ002555:
The single entry display (zoomed view) of a list window now support edit macro commands.

IQ002556:
For DB2 edit where option EDITPRIMEKEY is *not* specified, then entries in columns that are identified as being the primary key are protected and connot be updated by the user.

For inserted rows, the primary key column may be updated regardless of whether EDITPRIMEKEY is specified. This specification has now been extended to include duplicated table rows.
i.e. rows inserted using the 'R' prefix command.

IQ002557:
The following prefix command has been updated for use in a DB2 List of Indexes:

CL - List columns for that particular index.
(Previously displayed all columns for the associated table.)

IQ002558:
Correct problems relating to minimising IPO panels whereby the minimised icon was the same width as the restored panel display and, once minimised, the system menu items were unresponsive.

IQ002559:
DB2 Edit display of primary key column data is highlighted when FORMAT TABLE is current. (This makes it easier to identify the protected primary key columns.)

The same highlighting has been applied to data displayed in FORMAT SINGLE mode.

IQ002560:
DB2 Create VIEW panel input field for 'Full Select' has been extended from 96 bytes to accomodate input up to 1024 bytes in length.

IQ002563:
For all List windows, including DB2 object lists, the zoomed list entry window, to display all fields for a single list entry, has been enhanced to support all features of list windows. (e.g. Primary commands SELECT, WHERE, SORT, TEXT, etc.)

This also addresses the problem whereby a long field entry in a zoomed view did not wrap or scroll. The contents of these fields may now be scrolled left and right.

IQ002566:
Miscellaneous enhancements to the display and maintenance of Maximised and Restored windows.

  1. Maximsed/Restored mode is maintained across SELCOPY/i sessions. Independent Maximsed/Restored mode settings are maintained for CBLe child windows and SELCOPY Debug child windows. This feature utilises the following INI option variable:
       <windowclass>.InitialState=MAX.
    
  2. When in Restored mode, The 'CBLe' parent window title bar is removed so that user gains an extra line in the display area.
  3. When a CBLe child window is in Maximised mode, the minimise and restore buttons are no longer displayed in the title bar. This is so the user doesn't accidentally restore the CBLe parent window when restore of the CBLe child window is intended.
  4. The prefix displayed in the title bar of a Maximised CBLe child window has been updated to be 'SELCOPY/i' instead of 'CBLe'.
  5. When operating in Maximised mode, the 'Wr' button (executes WinX), MW and SZW commands and SET WINPOS/SIZE edit commands no longer switches the window out of Maximised mode. These window manipulation features now only affect windows in Restored mode.
  6. The SELCOPY Debug application no-longer rigidly starts in Maximised mode if window width<=80. The message box to this effect removed.
  7. The SELCOPY Debug application default window arrangement has been improved.
  8. Problems fixed that relate to unintended switching between Restored and Maximised mode.

IQ002568:
Correct potential 0C4 abend at SDEFFOB4+03EC when starting edit/browse of a DB2 table.

IQ002572:
IPO DROP <iponame> drops all IPO objects rather than just the named IPO.

Note: IPO DROP is not a published command and its use is not recommended.

IQ002573:
Support INI variables of the format:

  <windowclass>.PFn<n>DELAY=YES/NO
  <windowclass>.PFn<n>BEFORE=YES/NO

This allows the PFKeys set for particular window classes to be maintained across SELCOPY/i sessions.
Default values are "NO".

IQ002577:
Problem fixed whereby SDE commands INSERT and REPLACE ignored the first VALUE parameter entry when operating on a DB2 table.

IQ002578:
DB2 List Tables window prefix command "D" now correctly opens the DROP TABLE dialog.

IQ002579:
IPO panels for which there is no stored position now default to display at (2,2) rather than (1,1) so that the MDI child window border is visible.

IQ002580, IQ002584:
DB2 DROP dialog panels now support "Enter>" field to govern the default action of the <Enter> key. Options are: CMX (new default action), RUN, JCL or NOP.

This gives the user control of the <Enter> key and so protect against accidental execution of a DROP statement.

IQ002583:
Include SDE support for zoned decimal fields defined using COBOL copybook syntax SIGN IS LEADING|TRAILING (SEPARATE).

Additionally, direct definition of these types of field is supported via additional sub-parameters to SIGNED. e.g.

  <sd create struct                                 \
                  CBL.CBLI.SDO(IQDI2583)            \
    ( DIRECT-01  struct                             \
      (                                             \
       PROD           char(3)                       \
      ,SIGN-XXXX      zoned(13,2)                   \
      ,SIGN-LEAD      zoned(13,2) signed(lead)      \
      ,SIGN-TRAI      zoned(13,2) signed(trail)     \
      ,SIGN-LEAD-SEP  zoned(13,2) signed(lead,sep)  \
      ,SIGN-TRAI-SEP  zoned(13,2) signed(trail,sep) \
      )                                             \
    ) rep names(cobol)

See ammended help for SDE command CREATE STRUCTURE.

IQ002585:
LDTAB (macro) to List DB2 Tables, when invoked with no parameters no longer implies "LDTAB *.*". A List Tables window is now opened without overriding existing input fields.

IQ002586:
Prevent 0C7 at SDEFDVO0+2DC when a CHANGE command affecting a zoned decimal field is executed from an SDE single record (zoomed) view.

IQ002589:
SUBMIT of jobname containing '#' no longer causes loss of jobname from the prompt to enter SDSF.

IQ002593:
Prevent 0C4 at SDEFRTO0+01D6 on a CREATE STRUCTURE command to directly define an SDO (i.e. not using COBOL/PL1 copybook) which includes a 'USE <rectype> WHEN <cond>' clause.

IQ002595:
SDE eidt/browse RIGHT/LEFT <n_cols> works when using a structure in FORMAT TABLE since in this case they scroll <n_cols> fields.

In character (unformatted) view these commmands now scroll <n_cols> columns.

IQ002597:
Issuing LD, LV, LP commands without parameters now positions the cursor on one of the input prompts and so that subsequently hitting <Enter> popuplates the list.

Previously, cursor was positioned within the list display area and so immediately hitting <Enter> did nothing. Commands LL and LJQ (i.e. those that have only one input prompt) do not suffer the same problem.

 
z/OS Service Bundle SMP/E SYSMOD Component Op Sys APAR Publish Date Description
X0000003 RS00006 SELCOPY/i z/OS IQ002513
IQ002499
IQ002520
IQ002521
IQ002524
IQ002525
IQ002526
IQ002528
IQ002532
IQ002533
IQ002534
IQ002537
IQ002538
IQ002539
IQ002543
IQ002544
IQ002545
IQ002546
2011/02/15
IQ002520, IQ002524, IQ002525
IQ002526, IQ002532, IQ002533:
Support record length changes in SDE EDIT.

Previously, altering the length of a record using SDE EDIT was deliberately prohibited in order to preserve record data structure.

This restriction has been removed so that the length of a record may be altered if the following conditions are true:

  1. File contains variable length records.
  2. The SDE Edit technique in use is Full Edit, Auxiliary Edit, KSDS Edit or Read-Only Edit.
  3. No record structure (RTO) is associated with the record or the record display is unformatted.

If all these conditions are met, then the length of a record may be altered via the following methods:

  1. Overtype the Length field in the Record Information area.
  2. Execute SDE command SET LENGTH.
  3. Execute SDE command CHANGE where the replace and search strings are of a different length.

In order to support this feature, the following changes have been introduced:

  • SDE CHANGE command now supports mutually exclusive keyword parameters, DATA and TEXT, to control the effect of the change operation when the replace and search strings are of a different length.
    CHANGE TEXT will cause the change to operate as for ISPF style text edit with blanks being absorbed or added as appropriate.
    CHANGE DATA will simply change the data with no special treatment of blanks.
  • Re-evaluate the record type (RTO) associated with a record if either of the following conditions occur:
    1. A field included in a "USE WHEN" condition is updated (by overtyping it or as a result of a CHANGE command.)
    2. The record length is altered.
  • Introduce support for the SDE SET/QUERY/EXTRACT PAD option to maintain the pad character used when the length of a variable length record is increased or a new record is inserted.
    
      Syntax:
    
       }}-+-------+- PAD ---+- NUll ----+--------}{
          |       |         |           |
          +- SET -+         +- BLank ---+
                            |           |
                            +-- char ---+
                            |           |
                            +- 'char' --+
                            |           |
                            +- "char" --+
                            |           |
                            +- hexstr --+
                            |           |
                            +- binstr --+
    
      where:
        char  is a single character.
       'char' is a single character in apostrophies.
       "char" is a single character in quotes.
        hexstr is a hexadecimal string (x'00'-x'FF')
        binstr is a binary string b'00000000'-b'11111111'
    
  • Rename the record length column heading from "Lrecl" to "Length".
  • Introduce the SDE RECLEN command to control display of the record Length column. This is a synonym for SDE SET RECINFO ON/OFF LENGTH.
  • Introduce support for the SDE SET/QUERY/EXTRACT LENGTH option to update/display the length of the record occupying the focus line.

IQ002499:
Errors in the input length calculated for DB2 variable length columns when the trailing blanks stripped option is not in effect.

IQ002521:
Where windows are in a MAXimised state, the windows are restored to their original dimensions and maximised mode is unset following display of an IPO panel EXPAND window (assigned to PF2.)

IQ002528:
0C4 occurs at IOSFSQL0+0AE when starting the DB2 primary panel display and no default DB2 SSN is defined in either the System or User INI file.

IQ002534:
Correction to SYSMOD RS00004 which stated... In SDE Edit/Browse using a copybook, if FORMAT CHAR is in effect then PF2 to Zoom in single record mode should use formatted version. i.e. with copybook applied. FORMAT SINGLE behaves differently depending on whether the data is formatted or unformatted. SDEZOOMW updated to format the record data prior to switching to FORMAT SINGLE. FORMAT SINGLE operates correctly regardless of data formatting. SDEZOOMW corrected again to use FORMAT SINGLE instead of ZOOM.

IQ002537:
SDE command SET OFFSET, which defines the offset within a record at which the associated record type structure will begin mapping the data, now operates without a current edit object or view. This enables SET OFFSET to be used in a batch environment.

For batch execution only, changes made to strucutures are now saved automatically without requiring a specific SAVESTRUCTURE command.

IQ002538:
The CBLe EDIT prefix (ISPF line) command "TFnn" has been corrected so that it no longer fails to flow the text if the length of the record text is longer than the TF flow value, nn.

IQ002539:
Prefix command repetition factors are now properly interpreted by both the CBLe and SDE editors when one or more blanks exist between the prefix command and the repetition factor.

IQ002543:
Issuing SDE command FORMAT CHAR should always force multiple record view. Currently if issued from FORMAT SINGLE, the result is FORMAT CHAR in ZOOMed mode.

IQ002544:
Implement an edit primary command TFLOW to give the same functionality as the TF prefix command.

IQ002545:
FSU dialog window updated to include new parameters TEXT and DATA in-keeping with the CHANGE command.

IQ002546:
Only FORMAT TABLE and FORMAT SINGLE should be allowed for DB2 EDIT and browse.

 
z/OS Service Bundle SMP/E SYSMOD Component Op Sys APAR Publish Date Description
X0000002 RS00005 (QS00020 QS00016 QS00015 QS00014 QS00013 QS00012) SELCOPY/i z/OS IQ002530 IQ002522 IQ002517 IQ002523 IQ002511 IQ002510 2011/02/03
IQ002530:
Loop occurs on execution of the SDE CHANGE command which involes a field reference in parentheses. e.g.

  CHANGE  10  16  (#3)  all

IQ002522:
SDE Edit of a non-existant dataset using the Upd-In-Place option can result in error ZZSD015E urging the user to contact CBL because of an internal error.

"ZZSD219E File <fname> does not exist" should be the immediate response.

IQ002517:
SDE Edit on an unstructured record should causes the user to be prompted for the LRECL of any newly inserted records.

IQ002523:
Using the IEBCOPY dialog to create JCL job stream of execute IEBCOPY in the foreground gives a Control Card error pop-up window with message text "No message."

IQ002511:
SQLCODE=-519 attempting a DB2 List function following an earlier list that ran out of available storage.

IQ002510:
Message ZZSZ008W is returned on every connection to a DB2 subsystem for release of DB2 prior to V9R1M0. This message has been deemed an unnecessary irritation and so has been withdrawn.
RS00004 (QS00019) SELCOPY/i z/OS IQ002534 2011/02/03
IQ002534:
In SDE Edit/Browse using a copybook, if FORMAT CHAR is in effect then PF2 to Zoom in single record mode should use formatted version. i.e. with copybook applied.

FORMAT SINGLE behaves differently depending on whether the data is formatted or unformatted.

SDEZOOMW updated to format the record data prior to switching to FORMAT SINGLE.

RS00003 (QS00018) SELCOPY/i z/OS IQ002531 2011/02/03
IQ002531:
Compare File and Compare Library utility fix. STRIP option (to ignore trailing blank differences) was ignored.

RS00002 (QS00017) SELCOPY/i z/OS IQ002506 IQ002507 IQ002518 2011/01/19 SDE Panel Fixes:

IQ002506:
Handle HFS RECFM=V specification of offset, length and origin in the "V-Fmt/EOL:" entry field.

IQ002507:
Prevent error ... "Command EDITV SET userpfx %user...% ended with rc=20" which could occur after initiating the SDE panel from another SDE browse/edit document window.

IQ002518:
Prevent error ZZSD290E... "Operand REUSE is incompatible with operand FROM for command Edit" occurring when FROM was specified for Edit without selecting any of the options Allow Ins/Del, Upd-In-Place or Read-Only.

 
z/OS Service Bundle SMP/E SYSMOD Component Op Sys APAR Publish Date Description
X0000001 RS00001 (QS00001 QS00002 QS00003 QS00004 QS00005 QS00006 QS00007 QS00008 QS00009 QS00010 QS00011) SELCOPY/i z/OS IQ002487 IQ002490 IQ002491 IQ002492 IQ002493 IQ002494 IQ002495 IQ002497 IQ002500 IQ002502 IQ002503 2011/01/17
IQ002503:
DSNT408I SQL=-104 on save of an updated DB2 column when SELECT(colname1,colname2, ...) was used to exclude one or more columns for edit.

IQ002502:
FSU and FCOPY can become unresponsive if the edit main window is exited (user sees the SELCOPY/i logo screen) then restarted, e.g. using the 'Home' menu item.

IQ002500:
Only the first character of a VARCHAR field is displayed on DB2 BROWSE when the VARCHAR column is the last selected on a BROWSE SELECT clause.

IQ002497:
DB2 edit errors possible when saving changes to VARCHAR columns if the updated column's length exceeds the maximum length minus 2.

IQ002491:
FCOPY dialog prompts to allocate new "To" dataset if required and successfully uses "From" dataset as model, except when "From" dataset is a load library.

IQ002493:
When using the "Allocate NonVSAM" dialog to create a DSORG=PS dataset by specifying "SEQ" in the Type entry field and a non-zero value is also specified for Directory Blocks, then the file is created as DSORG=PO.

IQ002495:
Command "DB2 SSN=xxxx" at the DB2 prime menu fails to open new prime option menu for the specified subsystem.

IQ002494:
0C4 at SDEFSQX3+0532 in SDELIB where structured data EDIT or BROWSE of two DB2 tables with the same owner id and name but existing in different DB2 sub-systems.

The 0C4 occurs when one of the SDE edit views are closed and processing is continued in the SDE edit view for the other DB2 table.

SYSMOD QS00004 causes a unique temporary structure (SDO) to be generated for each SDE BROWSE or EDIT of a DB2 table.

IQ002492:
0C4 occurs at WINFIPW2+073A in CBLDLL when the DB2 command is issued so that the fieldname and value parameters of the fastpath sub-option is longer than 256 characters.

IQ002490:
IOSLIB function CreateListFromSQL() calls SQXLIB function AllocateCursor() to prepare the SELECT statement. Because this cursor was not specified as read-only a FOR UPDATE clause was appended which conflicted with the ORDER BY clause supplied by the user.

IQ002487:
Use of FSU to execute a list of CHANGE commands separated by the AND operator resulted in subsequent CHANGE commands being ignored following the first hit per record.
RI00001 (QI00001 QI00002) SELCOPY z/OS SQ011899 SQ011900 2011/01/17
SQ011899:
Loop can occur when a DB2 UPDATE is issued for a table opened using "READ fname TAB=my.table" style syntax, and there is no current row to update i.e. then logical file is no longer open.

SQ011900:
Incorrect LRECL leading to possible ERROR 546 when the last column of a DB2 input table row is a VARCHAR field containing a NULL value.

This fix ensures that a VARCHAR length field is set to zero for NULL values.
Same problem in previous release.

 
Top FaceBook Twitter LinkedIn © 2013 Compute (Bridgend) Limited
http://www.cbl.com/selcsupp.html
2012/10/04 12:24:20