Crossbow Release Notes Version 6

• Added support for automatic input file handling in zTrieve JOB processing. (Ticket 1159397676)

• Added support for virtual files when executing zTrieve from JCL. (Ticket 1159405856)

• Improved zTrieve processing by avoiding unnecessary clearing of entire blocks. (Ticket 1159394048)

• Improved file sharing behavior by temporarily allowing read/write file sharing. (Ticket 1159352806)

• Improved VsamSql handling to preserve the current record position during WRITE operations. (Ticket 1159392866)

• Added support for SQL Server table synonyms. (Ticket 1159372366)

• Improved data movement handling to preserve byte values when moving COMP-3 data to string fields. (Ticket 1159371472)

• Fixed page size calculation errors in zTrieve reports. (Ticket 1159372506)

• Fixed unsupported handling of multiple UPDATE clauses. (Ticket 1159378636)

• Fixed IMSql PTR processing when empty elements are present. (Ticket 1159362040)

• Improved zTrieve handling of numeric-edited output and report generation to better align with Easytrieve behavior. (Ticket 1159374754)

• Fixed CICS browse processing to correctly allow START to be omitted when using the AT clause. (Ticket 1155274294)

• Developed support for the SNAPAID utility. (Ticket 1159322872)

• Improved zTrieve handling to allow writing to retained virtual files. (Ticket 1159374656)

• Improved JCL logging by standardizing return code reporting using a consistent RC and HighestRC format. (Ticket 1159362014)

• Fixed negative offset handling in zTrieve reports. (Ticket 1159372506)

• Fixed support for input host variables in zTrieve SQL processing. (Ticket 1159359646)

• Fixed a JobPrintQueue NullReferenceException occurring when a completed-step DD has no associated RuntimeDataSet. (Ticket 1159380798)

• Added support for providing a SYSNULL file. (Ticket 1159352728)

• Implemented EZTPX01 support in zTrieve. (Ticket 1159291264)

• Extended FileAid support for RDW processing. (Ticket 1159323680)

• Added support for preserving the volume of temporary datasets across steps that reuse them. (Ticket 1159357648)

• Added support for using the last CONNECT AT target when no current Oracle connection is defined. (Ticket 1159337618)

• Improved zTrieve handling of alphanumeric-to-numeric comparisons. (Ticket 1159352806)

• Added support for an undocumented zTrieve grammar rule used by client applications. (Ticket 1159343722)

• Added timeout support during LOAD bulk copy operations. (Ticket 1159344356)

• Fixed a SORT looping issue that could cause execution to hang. (Ticket 1159353916)

• Fixed return code handling so that RC=4 is correctly applied for CTE queries. (Ticket 1159346972)

• Fixed an off-by-one position calculation error in SORT IfTrail processing. (Ticket 1159355408)

• Fixed a memory leak in VsamSql by properly disposing write commands. (Ticket 1159303544)

• Fixed concurrency issues by adding missing synchronization locks. (Ticket 1159282862)

• Implemented the z/OS COBOL socket API entry point in EZASOKET. (Ticket 1159290592)

• Added support for fixed binary literals. (Ticket 1158562674)

• Added support for OUTREC VLFILL. (Ticket 1159246068)

• Added support for the DCBLNGQS field in the HLASM DCBD macro.

• Improved DSNUTILB partition handling when query rewriting is enabled. (Ticket 1159095792)

• Improved FTP processing by reporting transfer sizes with EZA1617I messages, applying SITE command attributes to local datasets, and refining FTP output handling. (Ticket 1159297512, Ticket 1159297490)

• Improved DD name resolution by avoiding repeated exceptions in FindKnownDDName processing. (Ticket 1159327318)

• Enhanced connection dictionary accessibility and management. (Ticket 1159337618)

• Improved SORT processing by preserving the search path when E15 and E35 exits invoke subprograms. (Ticket 1159284528)

• Added support for MODEL parameters in IDCAMS DEFINE ALTERNATEINDEX and VOLUME(*) definitions. (Ticket 1159320890)

• Improved LISTCAT processing and handling of GDG and PDS datasets. (Ticket 1159190494, Ticket 1159061126, Ticket 1159068552)

• Fixed inconsistent DLL and PDB file naming. (Ticket 1159317346)

• Fixed handling of negative bases raised to fractional powers by generating the appropriate exception. (Ticket 1159317488)

• Fixed SCANONLY processing when referenced procedures are missing. (Ticket 1158858100)

• Fixed SORT user exit processing issues. (Ticket 1159317656)

• Fixed stored procedure execution issues related to Active Directory authentication and plugin support in RaincodeStoredProcedureRunner. (Ticket 1159268520)

• Fixed VSAM SQL write cache handling by properly disposing of the cache when flush operations fail. (Ticket 1159314610)

• Fixed IMSql session cleanup by removing abandoned sessions after unexpected termination. (Ticket 1159290592)

• Fixed file access to allow files to be opened in shared mode. (Ticket 1159287562)

• Fixed crashes caused by certain invalid input values. (Ticket 1159289536)

• Fixed SORT work file validation to prevent erroneous checks when work files are opened. (Ticket 1159282886)

• Fixed DSNTIAUL handling by removing hardcoded CHAR null-check behavior. (Ticket 1159029364)

• Added support for reading PDS members more reliably. (Ticket 1159252326)

• Added ZIP390 JCL utility support.

• Added authentication support to the Raincode Console.

• Improved SORT handling of explicit continuation statements. (Ticket 1159266764)

• Improved PDS member resolution by supporting member lookup with file extensions. (Ticket 1159252326)

• Improved IDCAMS support for multiple REPRO operations using DISP=OLD. (Ticket 1159252568)

• Improved DSNTIAUL processing to use QueryTranslation without requiring PARMS('SQL'). (Ticket 1159247834)

• Improved FileAid processing for record length management and file handling, including support for IN=0 and automatic metadata updates. (Ticket 1159221998)

• Fixed SYSOUT statistics reporting where WER055I READ IN and OUT values were incorrectly reported as identical. (Ticket 1159238840)

• Fixed detection of missing GDG generations in concatenated datasets. (Ticket 1159239702)

• Fixed FileAid VB output processing by trimming records before writing. (Ticket 1159239658)

• Fixed error handling when attempting to write to input files. (Ticket 1159075772)

• Fixed dual SQL runtime behavior by keeping SQL connections open across COMMIT and ROLLBACK operations. (Ticket 1159242722)

• Fixed metadata cleanup when COPY operations fail for newly created files. (Ticket 1159205492)

• Fixed FileAid execution flow to return RC=8 and terminate processing when required. (Ticket 1159227264)

• Added IfTrail functionality to SORT processing. (Ticket 1159182424)

• Improved FileAid processing to allow IN=0 to process the entire file. (Ticket 1159221998)

• Improved handling of table hints in SQL explicit table expressions. (Ticket 1159148218)

• Improved DSNTIAUL SYSPUNCH generation to better align output with mainframe behavior. (Ticket 1159105162)

• Fixed FileAid execution flow to return RC=8 and stop processing when required. (Ticket 1159227264)

• Fixed handling of FBA files in Assembler DCB processing. (Ticket 1159065766)

• Fixed UNION ALL handling involving INTEGER and DECIMAL data types. (Ticket 1159189968)

• Fixed an arithmetic overflow error occurring during SYSPUNCH generation when converting numeric values to NUMERIC data types. (Ticket 1159100166)

• Implemented CEEGMT support. (Ticket 1159186546)

• Added support for PART clauses in DSNUTILB UNLOAD statements and partition-related metadata handling for TLP1103. (Ticket 1159095792)

• Added support for the YREGS macro in HLASM.

• Improved zTrieve output generation by using zero-padding instead of space-padding when writing values. (Ticket 1159183290)

• Improved repository handling to correctly overwrite existing repository entries. (Ticket 1159184328)

• Improved ISRSUPC processing to ensure temporary copies of PDS datasets are created successfully. (Ticket 1159170656)

• Fixed DD override handling for SYSOUT when using procedures from SYS1.PROCLIB. (Ticket 1159069572)

• Fixed an issue where concatenated DDs and DD overrides did not work correctly together. (Ticket 1159192626)

• Fixed PROC CALL COND processing that incorrectly overwrote all step-level COND conditions within the procedure. (Ticket 1159187386)

• Added test coverage for SYSNULL AutoDD card handling. (Ticket 1159100166)

• Fixed missing SQL semantic analysis for explicit table expressions. (Ticket 1159148218)

• Fixed program mask handling to correctly support its 4-bit length. (Ticket 1159057138)

• Added support for BIT-OF. (Ticket 1158245656)

• Added support for EXAMINE TALLYING. (Ticket 1159155208)

• Added support for CONSTANT in DSNUTILB UNLOAD. (Ticket 1159087206)

• Improved IDCAMS support by accepting BUFFERSPACE, IMBED/NOIMBED, and REPLICATE/NOREPLICATE parameters in ALTERNATE INDEX definitions. (Ticket 1159148722)

• Improved QixMultiStatement processing by accumulating outputs before writing them back into the address space. (Ticket 1159127990)

• Fixed ICETOOLS COUNT processing. (Ticket 1159172220)

• Fixed COBOL START behavior on DUMMY files to match Micro Focus COBOL V5 expectations. (Ticket 1159060572)

• Added support for CONSTANT in DSNUTILB UNLOAD. (Ticket 1159087206)

• Improved QixMultiStatement processing by accumulating outputs before writing them back into the address space. (Ticket 1159127990)

• Improved record size computation by using the minimum upper bound. (Ticket 1159155166)

• Fixed COBOL preprocessor behavior to correctly match directories when including or copying copybooks. (Ticket 1159155540)

• Enabled configuration of CTM prefix in CatalogConfiguration (ctmPrefix). (Ticket 1158875114)

• Improved CEEDATE handling to support WWWW date masks and proper parsing of full month and day names. (Ticket 1159060710)

• Improved ISRSUPC performance by reducing memory footprint, speeding up execution, and fixing OutputSection handling. (Ticket 1159115760)

• Improved DSNTIAUL SYSPUNCH generation to support SMALLINT, INTEGER, and BIGINT types. (Ticket 1159105162)

• Fixed OPEN behavior to correctly return RC=05 when DD is optional and missing. (Ticket 1158853902)

• Fixed JSON PARSE handling of null values. (Ticket 1159086902)

• Fixed error handling when writing to input files. (Ticket 1159075772)

• Fixed SORT input counter handling. (Ticket 1159064890)

• Fixed GDG handling to prevent MOD(,DELETE,DELETE) from resetting the current generation. (Ticket 1159086828)

• Fixed IDCAMS DELETE for GDG datasets when catalog is stored in the database. (Ticket 1159101522)

• Fixed COBOL status 44 behavior to be raised only for WRITE operations. (Ticket 1159089978)

• Fixed handling of UNICODE_STR function calls. (Ticket 1159078980)

• Added TLSImplicit option to FTP to start encryption from the connection stage. (Ticket 1159051794)

• Added support for UNICODE_STR. (Ticket 1159078980)

• Refactored CEEDATE parser to support concatenated datetime masks. (Ticket 1159060710)

• Implemented parsing support for DSNUTILB STATISTICS control statements. (Ticket 1159070426)

• Improved DSNUTILB handling for LOAD table names with spaces. (Ticket 1159069922)

• Improved DSNUTILB handling by providing the correct schema for TLP1103. (Ticket 1158998844)

• Improved SORT behavior to display IBM-like statistics. (Ticket 1159064890)

• Improved SORT handling to correctly load E15 and E35 exits from libraries. (Ticket 1159057212)

• Improved parsing of DEFAULT OUTPUT and updated SYSOUT parameters handling. (Ticket 1159078744)

• Improved handling of subquery column qualification. (Ticket 1159057378)

• Fixed SQL DROP VIEW returning incorrect RC 100. (Ticket 1159040652)

• Fixed COBOL handling to detect implicit RECORDING MODE V. (Ticket 1159074916)

• Fixed SYSIN instream dataset termination when using //* markers. (Ticket 1159038606)

• Fixed DD override issues for SYSOUT. (Ticket 1159069572)

• Fixed SORT processing for PROC steps where XXX.StepName replacement incorrectly copied DSN into DUMMY. (Ticket 1159067758)

• Fixed casting issues in CastSubstrings implementation. (Ticket 1159059306)

• Fixed handling of ROWID as a SQL predefined expression. (Ticket 1159029364)

• Fixed restart handling issues for GDG datasets, including unplug and deadlock scenarios. (Ticket 1158183966)

• Fixed DSNTIAUL return code when multiple statements are present. (Ticket 1159013992)

• Fixed JCL handling to allow PARM.StepName to override PARM in PROC steps. (Ticket 1159063368)

• Implemented LIST=YES/NO feature in IEBCOPY. (Ticket 1158981034)

• Added support to modify encoding while exporting in Record Editor.

• Added support for datetime masks containing Julian days in CEESECS. (Ticket 1159048590)

• Improved handling of COBOL datetime masks, including support for MMM tokens and ignoring unsupported WWW tokens. (Ticket 1159060710)

• Improved SQL binding behavior for multipart identifiers. (Ticket 1159024536)

• Improved handling of quoting for table names and aliases conflicting with SQL Server keywords. (Ticket 1159040640)

• Improved SORT assembly exit loading to use RC_EXECUTABLE_PATH. (Ticket 1159057212)

• Improved SORT handling to ignore VTF when input is fixed size. (Ticket 1159017320)

• Improved COBOL record reading to truncate records exceeding buffer size by default, with option to enforce error behavior. (Ticket 1159023176)

• Improved DSNTIAUL handling by correcting exit codes for SELECT statements. (Ticket 1159013992)

• Improved DSNUTILB LOAD handling for DECIMAL fields where position takes precedence over length and added support for UPDATE clauses in LOAD statements. (Ticket 1158998844)

• Improved precision handling for POWER DECIMAL(15,12). (Ticket 1159040614)

• Improved handling of SUBSTR in CASE expressions. (Ticket 1159018774)

• Improved semantic handling and rewriting rules for POSSTR. (Ticket 1159021250)

• Fixed DSNUTILB load execution failures. (Ticket 1159024276)

• Fixed IDCAMS REPRO syntax issues. (Ticket 1159028518)

• Fixed issue where EODAD routine was not called on DUMMY input. (Ticket 1159008970)

• Added support for datetime masks containing Julian days in CEESECS. (Ticket 1159048590)

• Added support for cloning COBOL RealLiteral values. (Ticket 1158998928)

• Added support for multiple DELETE statements within a DSNTEP2 step. (Ticket 1158988878)

• Added support for MSGDDN parameter in SORT. (Ticket 1159006786)

• Added timeout handling for DSNTEP2 execution. (Ticket 1159004798)

• Improved stored procedure parameter naming handling. (Ticket 1158961378)

• Improved DSNTEP2 and DSNTIAUL processing to translate queries consistently and updated Linux test coverage. (Ticket 1158915864)

• Improved SQL binding behavior for multipart identifiers. (Ticket 1159024536)

• Improved handling of CHAR(FLOAT(53)) semantic rules. (Ticket 1159009164)

• Improved handling of COALESCE function. (Ticket 1159001040)

• Improved handling of SUBSTR for Decimal(3,0). (Ticket 1159005584)

• Improved precision handling for POWER DEC(31,27). (Ticket 1159005610)

• Improved handling of buffer pool configuration errors. (Ticket 1159011972)

• Improved parsing of SYSTSIN content based on DSN length. (Ticket 1158998688)

• Improved OUTFIL FILES= parsing to accept any valid DD name characters. (Ticket 1158853592)

• Improved zTrieve behavior by removing reserved keyword conflicts while preserving MOVE precedence. (Ticket 1158998762)

• Improved zTrieve CASE handling to allow empty consequences in WHEN clauses. (Ticket 1158998794)

• Added missing validation for INSPECT statements. (Ticket 1159008508)

• Fixed an issue where DAYOFMONTH was not recognized as a built-in function. (Ticket 1159037324)

• Fixed DSNUTILB LOAD failures caused by incorrect FORMAT handling. (Ticket 1159004792)

• Fixed parsing errors in FILEAID statements. (Ticket 1159029128)

• Fixed incorrect handling of the NULLIF function. (Ticket 1159026174)

• Fixed SQL syntax errors involving incorrect comma placement. (Ticket 1159021846)

• Fixed DSNUTILB load execution failures. (Ticket 1159024276)

• Fixed SYSPRINT output differences in IDCAMS compared to mainframe behavior. (Ticket 1159022366)

• Fixed SYNCSORT requiring SYSOUT handling. (Ticket 1159024216)

• Fixed DSNTEP2 SYSPRINT handling to support FB and FBA formats. (Ticket 1158997442)

• Fixed divide-by-zero errors occurring with SQL tolerance parameters. (Ticket 1158987888)

• Fixed default COPY statement handling in FILEAID. (Ticket 1159010848)

• Ignored TITLE in IDENTIFICATION DIVISION for WBA processing. (Ticket 1154556550)

• Added missing SYSPRINT messages in DSNTIAUL. (Ticket 1159007360)

• Added RC_SQL_REWRITE_OPTION_APPEND to QueryTranslation. (Ticket 1159004600)

• Fixed persistence of DCB=*.xxx changes across execution. (Ticket 1158956944)

• Fixed array dimension validation issues in DSNTIAUL. (Ticket 1158946788)

• Fixed incorrect handling of LTRIM with integer values. (Ticket 1159005386)

• Fixed INSERT FROM CTE handling in SQL execution. (Ticket 1159000772)

• Fixed missing SQLCODE -803 warning in result.db3. (Ticket 1156868842)

• Fixed POWER function evaluation issues. (Ticket 1158979774)

• Fixed IDCAMS LISTCAT ALL to display GDG member information. (Ticket 1158979798)

• Fixed SQL execution failures caused by literals in GROUP BY clauses on SQL Server. (Ticket 1158918366)

• Fixed NULL date handling in CAST and substring expressions. (Ticket 1158946052)

• Fixed execution issues for global temporary tables with UPDATE rewriting. (Ticket 1158915864)

• Improved support for DB2 VARCHAR_FORMAT and CHAR(TIME, FORMAT) functions in COBOL DB2 programs. (Ticket 1158910134)

• Fixed handling of SYSOUT print files defined with OUTPUT= only and no SYSOUTCLASS. (Ticket 1158937272)

• Fixed an issue when using DCB=(EROPT=ACC) in JCL definitions. (Ticket 1158911428)

• Fixed an issue where query execution failed due to an invalid rewritten column name (SRT). (Ticket 1158919684)

• Fixed an issue where temporary files were created using ISO‑1252 encoding instead of UTF‑8. (Ticket 1158927746)

• Fixed lack of support for GDGs with multiple record lengths. (Ticket 1158911524)

• Fixed an issue where DIRDEL did not work when EnableFileCaching=true, with missing diagnostic messages. (Ticket 1158867460)

• Fixed an issue where AutoDD cards still generated metafiles for SYSOUT when SysoutMetaKeep=false. (Ticket 1158868024)

• Support for passing data in containers from COBOL to Csharp.

• Added support for VSAM KSDS, ESDS, RRDS, and LDS definitions via DD parameters RECORG, KEYLEN, and KEYOFF. (Ticket 1158931366)

• Implemented support for the DB2 statement SET CURRENT SQLID. (Ticket 1158907896)

• Improved SQL rewriting rules for Raincode.CHAR_FROM_DATE to require exact matches. (Ticket 1158946754)

• Added support for index creation on the session table. (Ticket 1158915864)

• Allowed empty values for AVGREC in JCL definitions. (Ticket 1158863824)

• Added support for TEMP PDS files using DSN=&&TEMP(member) in IKJEFT01. (Ticket 1158886154)

• Improved BPXCOPY handling in JCL by ignoring the EXEC TIME option when running in scan‑only mode. (Ticket 1158888934)

• Applied additional fixes to DF2Sync as part of enhancement improvements. (Ticket 1158334126)

• INZUTILB - Fixed an issue where INZUTILB returned RC03 without producing output. Ticket 1158888934

• Stored Procedure - Resolved the platform compatibility error involving Microsoft.Data.SqlClient. Ticket 1158853564

• PLUS / ReportsKeyword - Corrected issues with unresolved PLUS statements and unsupported ReportsKeyword clauses. Ticket 1158841618

• SQL Module: Fixed an unimplemented feature. Ticket 1158817256

• SQL Resolution: Fixed errors resolving both unqualified and qualified “*”. Tickets 1158817316, 1158817340

• Function Rewriting: Corrected unexpected usage of CONCAT and LAST_DAY(VARCHAR(4)). Tickets 1158817120, 1158817154

• Raincode Console: Fixed an issue where connection strings were displayed in plain text. Ticket 1158823554

• SQL Variant / CTE: Fixed handling of unsupported type sql_variant in multiple CTE scenarios. Ticket 1158824852

• IMSql: Corrected current‑position behavior after a GE operation when SSA contains a unique sequence. Ticket 1158873912

• Dataset Metadata: Fixed incorrect reading of dataset metadata from .meta files. Ticket 1158816626

• IDCAMS: Improved optimal removal of datasets using mask patterns. Ticket 1157286726

• DF2Sync: Applied fix for enhancement request. Ticket 1158334126

• JCL SFTP Utility: Added clearer error messages.

• SFTPAUTH: Improved logging and added keyfile= parameter support.

• JCL: Added the new FILEBKUP utility.

• RadaR: Updated documentation and corrected execution and installation scripts.

• zTrieve: Added new DATECONV macro and documentation.

• Removed dependency on Microsoft.IdentityModel.Tokens.

• Ticket 1158805008: [Record Editor] - Importing files into catalog doesn't save the file content

• [QIX.Cmd] - Delay password rewrite

• [QIX] - Add passwordMapping to processing server

• Ticket 1158822682: Error parsing Statement LABEL= or EXPDT= DCB= without sub parameters

• [zTrieve] - DATECONV macro in C#

• Ticket 1157575936: Fix COBOL TITLE statement

• Ticket 1151882384: Fix compilation Error

• Ticket 1158839266: [IEBCOPY] - Catch the unsupported parm in the db instead of throwing an error

• Ticket 1147373592: Structure containing fields with the same name not properly initialized

• Ticket 1158838908: [ISRSUPC] - Ignore extraneous pipe added during serialization in scanonly mode

• [VSPlugin] - Add registry handling for VS2026

• Ticket 1158817142: TIMESTAMPADD rewriting rule

• Ticket 1158817136: SUBSTR with DECIMAL SQL rewriting

• Ticket 1158802720: To_char Datetime2 SqlRewriting

• Ticket 1158819042: Recognize structure as sql varchar

• Ticket 1158829672: Fix stored proc gen when parameters are structure WIP

New features and improvements

• Support for .NET 10.0 and SQL Server 2025 across the board.
• The Visual Studio plugin now supports Visual Studio 2022 and 2026, with improved support for JCL debugging.
• Support for the File-AID JCL utility.
• Support for TLS encryption on QIX and IMSql TN3270 terminal servers.

RcDbConnections.csv format

• RcDbConnections.csv file
  • The RcDbConnections.csv file used to define plans in Raincode JCL is now properly parsed as RFC 4180 compliant comma-separated CSV, with an exception for comments (lines starting with `#` or `//` are ignored).
  • This implies that database connection strings must now be (double) quoted if they contain commas.
  • This change may require updates to existing RcDbConnections.csv files to ensure proper parsing.

Removal of obsolete features

• .NET Framework
  • No longer supported.

• .NET 6.0
  • No longer supported.

• Microsoft Host Integration Server (HIS) for Db2
  • No longer supported.

• 32-bit executable generation
  • No longer supported.

Compiler breaking changes

• :Target=NetCore and :Target=NetFramework
  • Options are no longer supported. Supported values are now net8.0 and net10.0.

• :M32 and :M64
  • Options (used for executable generation, as opposed to DLL generation) are no longer supported. 64-bit code generation is now the only supported mode for executables and is implied by the :EXE option.

• :SQL=db2his
  • Option is no longer supported. Users depending on the generation of Db2 bind files can use a new flag instead: :GenerateHISStaticSQLPackageXML and will have to provide an alternative :SQL option, such as :SQL=db2ibm.