•  
  • Home
  • Message
    Lookup    Lookup for MQ and our program messages
    • ASL Program Messages
    • MQ Reason Codes
    • Documentation
  • Our
    Products    List of some of the products we offer
    • Mainframe (z/OS)Products for the mainframe
      • Free SoftwareFree software that we offer
        • ASLCOPYGenerate IEBCOPY control statements
        • ASLDELDeletes a dataset passed as a parameter
        • ASLIPVLDValidate the format of an IP Address
        • ASLPARMCWrites passed parameter to output file
        • ASLVTOCTSO command to produce a VTOC list
        • ASLWAITWaits for an ECB to be posted that will never post!
        • BSLBR14IEFBR14 replacement with additions
        • ENQWATCH (ISGECMON)Report on dataset enqueues
        • MQVERDisplay Websphere MQ version information
        • QMSTATDisplay Websphere MQ Subsystem information
        • Q2VSAMSample MQ to VSAM Application
        • SUPERXMTTSO TRANSMIT command wrapper
        • ZAPVTOCVTOC Update Utility
        • Rexx ExecsRexx EXECs for z/OS
        • ISPF Edit MacrosFree ISPF Edit Macros
        • XMT FacilityXMT Facility for creating XMIT files
        • TESTKSDS FacilityTESTKSDS Facility for checking a VSAM KSDS for tuning
      • Program ProductsFree Program Products
        • ASLCOPYGenerate IEBCOPY control statements
        • ASLDATERAbbydale Systems LLC. Standard date routine.
        • ASLDAYCCSet condition code based on the day of the week
        • ASLVTOCTSO command to produce a VTOC list
        • ASLWAITWaits for an ECB to be posted that will never post!
        • BSLBR14IEFBR14 replacement with additions
    • iPad/iPhone
  • Free
    Software
    • ASLCOPYGenerate IEBCOPY control statements
    • ASLDATERAbbydale Systems LLC. Standard date routine.
    • ASLDAYCCSet condition code based on the day of the week
    • ASLDELDeletes a dataset passed as a parameter
    • ASLIPVLDValidate the format of an IP Address
    • ASLPARMCWrites passed parameter to output file
    • ASLSUBCMIssue a subsystem start or stop command
    • ASLVTOCTSO command to produce a VTOC list
    • ASLWAITWaits for an ECB to be posted that will never post!
    • BSLBR14IEFBR14 replacement with additions
    • ENQWATCH (ISGECMON)Report on dataset enqueues
    • SUPERXMTTSO TRANSMIT command wrapper
    • WebSphere MQ Code
      • MQERRORAsk operations what to do about an MQError
      • MQVERDisplay Websphere MQ version information
      • QECHOInformation on the free program QECHO
      • QMSTAT Display Websphere MQ Subsystem information
      • QUEPUTInformation on the free program QUEPUT
      • QMGRWAITAsk operations what to do for a quiescing QMGR
      • Q2VSAMSample MQ to VSAM Application
      • Defining Triggered ChannelsSample code for defining triggered channels
      • WebSphereMQ ChannelsDiscussion on WebSphereMQ Channels
      • WebSphereMQ Coding
        Considerations        Discussion on WebSphereMQ good coding practices
    • ZAPVTOCVTOC Update Utility
    • Rexx ExecsRexx EXECs for z/OS
    • ISPF Edit MacrosFree ISPF Edit Macros
    • Excel Spreadsheets & CodeFree Sample Excel Spreadsheets and sample code.
    • Windows Backup ScriptSample script for backing up Windows directories
    • XMT FacilityXMT Facility for creating XMIT files
    • TESTKSDS FacilityTESTKSDS Facility for checking a VSAM KSDS for tuning
  • Microsoft™ Software
    Hints, Tips and Sample Code
    • Excel"
      • Excel Hints and TipsSome useful Excel hints and tips
        • Quickly Replicate a WorksheetQuickly replicate a worksheet
        • Snap an object to the grid linesAutoalign an object to the grid lines
        • Autofill CellsAutofilling cells.
        • Changing the default MsgBox buttonHow to change the default button on a VB MsgBox
      • Connecting an Access
        Database to Excel        How to connect an Access database to Excel demonstration.
      • Selecting and grouping
        worksheet tabs by color        How to group and display worksheets based on tab color.
      • Printing Multiple
        Worksheets        How to print multiple sheets in one operation.
      • RandomizerRandomize Spreadsheet Columns
      • Coin CollectionKeep track of your coin collection
      • Preventing Workbook CorruptionHow to prevent dropdown lists corrupting workbooks
      • Implement a Progress ScreenHow to implement a progress screen for long running excel programs
      • Fill a ListBox UserformHow to fill a ListBox on a Userform
      • S4 Hana CodeSample code for SAP S4 Hana
      • Eliminating #DIV/0! errorsHow to eliminate a #DIV/0! error from a spreadsheet
      • Hide all Worksheets except OneHide all the worksheet tabs except the one.
      • Getting the Last WordHow to get the last word of a String
      • Using Filters and "Go to Special" to Delete Selected RowsUsing filters to delete only selected rows
      • Merging Worksheets in VBACode to merge worksheets
      • Merge Worksheet into a TableCode to merge a worksheet into a table on another worksheet.
      • Public Holiday Schedule GeneratorGenerate the annual holiday schedules.
      • Sending an Email from ExcelHow to send an email from within an Excel workbook.
      • Financial Year FunctionsFinancial year calculation functions
    • Access"
      • Enforce Numeric Data EntryForcing numeric input from a form
      • Flashing Form TextHow to make a control or text flash on a form
      • Checking For a TableHow to check to see if a table exists or not.
      • Linking an External TableLinking an external (or internal) table using VBA.
    • Windows
      • Recommended Windows Software A list of recommended Windows software
      • Windows Backup Script Sample script for backing up Windows directories
      • Maintaining Rolling Directory BackupsSample script for maintaining rolling backups of a Windows directories
      • Bulk Rename of FilesHow to rename multiple files in a directory in one fell swoop
      • Scheduling a TaskDemonstration of how to schedule a task
      • Recommended Windows SoftwareList of recommend free Windows software
  • Sample
    Code
    • Assembler
      • Assembler MacrosAssembler Macros
      • Easy AbendHow to generate a SOC3 abend...and why!
      • Swap RegistersHow to swap the contents of two registers
      • Perform OnceHow to execute a piece of code only once
      • Printing HexHow to print hexadecimal data
      • Printing Hex 2How to print hexadecimal data
      • Write To ProgrammerHow to write a message to programmers
      • Fold a string to UPPER caseHow to fold text to upper case
      • Generate a random numberGenerates a random number between two values
      • Check for a DD nameChecks a JCL stream for a specified DD card
    • Cobol
      • Passing ParmsPassing parameters
      • Obtaining Job Infofinding the executing jobname
      • Listing DD Namesddnames and associated dataset names.
      • Obtain UseridDisplay Userid of User Running a Program
    • ISPF Edit Macros
      • RUNJCLEdit macro RUNJCL
      • Other Edit MacrosMore edit macros
    • Rexx
      • Rexx Execs
      • Validate a Dataset NameQuickly and easily validate a dataset name
      • Find our LPAR nameFinding the LPAR name
      • Find our jobnameFinding the executing JOB name
      • Find our job numberFinding the executing JOB number
      • Replacing a stringString replacement
      • Finding the executing Rexx exec nameFinding the executing exec name
      • Convert month number to month nameConvert a month number to month name.
      • Calculate day of the weekCalculate what day of the week a date is.
      • Delay a calling ExecBuild in a delay for a calling Rexx Exec
      • Convert a string into proper name formatConvert a string to proper name format
      • Dropping the Last Level From a Dataset NameHow to drop the last level from a dataset name
      • Obtaining the Current TSO PROFILE PREFIXHow to obtain the current TSO PROFILE PREFIX
      • Count the Occurances of a stringCount the occurnce of one string in another
      • Sorting ann Array
        Demonstration        Demonstration of sorting an array
    • Java ScriptJava Script Tips
      • Right Click ProtectionProtect pictures/code from being downloaded
    • JCL
      • Avoiding Symbolic Parameter JCL errorsAvoid symbolic parameter JCL errors
      • Using ASLPARMCHow to use ASLPARMC
      • Reloading an IEBUPDTE unloaded datasetHow reload an IEBUPDTE unloaded dataset
    • Visual Basic
      • Access"
        • Enforce Numeric Data EntryForcing numeric input from a form
        • Flashing Form TextHow to make a control or text flash on a form
        • Checking For a TableHow to check to see if a table exists or not.
        • Linking an External TableLinking an external (or internal) table using VBA.
      • VB for Excel
        • Changing the default MsgBox buttonHow to change the default button on a VB MsgBox
        • Check for existence of a spreadsheetCheck to see if a worksheet exists or not
        • Check for valid worksheet nameCheck to see if a worksheet name is valid
        • Check for existence of a fileCheck to see if a file exists or not
        • Unhiding Hidden SheetsHow unhide all hidden spreadsheets
        • Disabling/Enabling FeaturesHow to enable/disable Excel features
        • Filling a Drop Down ListFilling a dropdown list
        • Sorting WorksheetsHow to sort Excel spreadsheets
        • Create an Index of WorksheetsCreating a worksheet index
        • Placing a Graphic in an EXCEL HeaderAdding graphics to headers/footers
        • S4 Hana CodeSample code for SAP S4 Hana
        • Drop the First Word From a StringHow to drop the first word from a string
        • Eliminating #DIV/0! errorsHow to eliminate a #DIV/0! error from a spreadsheet
        • Comparing Two DatesHow to compare two dates
        • Last Date of a Particular Day of the WeekFinding the Last Date of a Particular Day of the Week
        • Separating Date and Time from a cellHow to split date and time out of a cell
        • Formatting Minutes to Hours and MinutesHow to format minutes in hours and minutes with one instruction
        • Checking to see if a cell is mergedChecking a cell to see if it is merged
        • Counting Non-Blank RowsCounting non-blank rows in a column
        • Deleting Duplicate RowsEasy deletion of duplicate rows
        • Copying Data to the ClipboardCopying Data to the Clipboard
        • Getting the last wordHow to get the last word of a string
    • Windows
      • Windows Backup Script Sample script for backing up Windows directories
      • Maintaining Rolling Directory BackupsSample script for maintaining rolling backups of a Windows directories
      • Bulk Rename of FilesHow to rename multiple files in a directory in one fell swoop
      • Scheduling a TaskDemonstration of how to schedule a task
    • PHP
      • Blocking IP AddressesHow to block IP addresses from your website
      • Adding Last Modified Date to a WebpageHow to add a last modified date to a webpage
      • Automatically Update Copyright YearHow to automatically update the Copyright notice when the year changes
      • Adding a guestbook
        to a website        How to add a guestbook to a website using our supplied code
  • Usermods
    & Zaps
    • ZapsAMASPZAPs
      • Making IEBPTPCH print alphabeticallyChange how IEBPTPCH prints
      • Enable TSO option 3.8 to view any outputView any job output using option 3.8
      • Add Date and Time to IEBUPDTE Output LogZap to add a date and time stamp to IEBUPDTE output log
    • User ModificationsUser modifications
      • Save volser in ISPF 3.4How to save the volser in ISPF 3.4
      • Save input and output datasets for ISPPREPHow to save the input and output datasets used by ISPPREP
      • Modifications to ISPPREP (program) and ISPPREPA (Panel)Modify ISPPREP to use user defined names.
      • Eliminate IBM ISPF Copyright MessageHow to eliminate the IBM copyright message from the ISPF startup
      • Arranging SDSF columnsHow to arrange SDSF columns
  • JES
    Exits    JES exit information
    • JES Exit
      Information      JES Exit Information
    • Activating JES exitsHow to activate JES exits
      • Permanent activationHow to permanently activate JES exits
      • Temporary activationHow to temporarily activate JES exits
  • SMF
    Exits    SMF exits
    • SMF Exit
      Information      SMF Exit Information
    • IEFU29SMF dataset switch exit
  • Mellon Bank
    Modifications    Mellon Bank JES exits
  • Message
    Processing Exits    Message Processing Exits
    • Stop an external writerShutdown an external writer when it is waiting for work
    • Issue a Start command for a printer ($Sprtx)Issue a start command for a JES printer
    • Reply "Y" to shutdown a zFS serviceIssue a reply of "Y" to close a zFS service
    • Reply "D" to delete a dumpReply "D" to delete a dump if there was an issue
    • Issue a LLA RefreshIssue the command to refresh LLA
    • Issue a LLA Refresh (Secured Version)Issue the command to refresh LLA (Secured Version)
    • Change the text IKT002IXChange the text of IKT002I to be more meaningful
    • Write an SMF Record at CICS start/endCut an SMF when CICS starts or ends
  • User
    CVT    How to define and use a user CVT
  • Zeller's
    Congruence    Zeller's Congruence Explained
  • S4 Hana
    Code    Sample code for SAP S4 Hana
    • Bypass
      SAP Dates
      Prompt      How to bypass the date prompt for SAP updating
    • Converting
      SAP Dates      Sample of how to convert SAP dates to Excel format
  • Links
    • Link Database
      Statistics      Statistics from the Links database
    • LinksDatabase of external links
  • Sponsored
    Sites
    • AncestryGenealogy databases and free spreadsheets.
    • FaithOur Faith Website
    • PhotographySome of our favorite photographs
    • Presidential GravesLocate graves of dead presidents
  • Technical
    Articles
    • Closing the Batch WindowUsing WebSphere MQ to close the batch window
    • WebSphereMQ ChannelsDiscussion on WebSphereMQ Channels
    • WebSphereMQ Coding
      Considerations      Discussion on WebSphereMQ good coding practices
    • The Paging GameThe old Paging Game explanation
    • Dynamic SORTWORKSUsing dynamic SORTWORKS.
    • New Tabs in Edge™How to change the
      landing page when
      opening a new tab in Edge
    • Generalised Job Flow
      Schematic      Generalised Job Flow
      Schematic