Library View Topics Framed Contents Revised Topics Previous Topic Next Topic Search Search ResultsPrevious Topic MatchNext Topic Match Notes List Notes Print Download No PDF Handheld DisconnectedHandheld ConnectedHelp

6.2.39.1 DELIMITED BY Phrase



This phrase specifies delimiters within the data that control the data transfer.

If the DELIMITED BY phrase is not specified, the DELIMITER IN and COUNT IN phrases must not be specified.

identifier-2
identifier-3
Each represents one delimiter.

Each can be either of the following:

  • An alphanumeric data item
  • X A DBCS data item
    
    

    X If any are DBCS items, then all must be DBCS items. Figurative
    X constants SPACE and SPACES are allowed for DBCS items.
    
    
literal-1
literal-2
Each represents one delimiter.

Each can either of the following:

  • A nonnumeric literal
  • X A DBCS literal
    
    

    X If any are DBCS literals, all must be DBCS literals. Figurative
    X constants SPACE and SPACES are allowed for DBCS literals.
    
    
Each can be any figurative constant except the ALL literal. When a figurative constant is specified, it is considered to be a 1-character nonnumeric literal.

ALL
One or more contiguous occurrences of any delimiters are treated as if they were only one occurrence; this one occurrence is moved to the delimiter receiving field (identifier-5), if specified. The delimiting characters in the sending field are treated as an
X elementary alphanumeric or DBCS item and are moved into the current delimiter receiving field, according to the rules of the MOVE statement.

When DELIMITED BY ALL is not specified, and two or more contiguous occurrences of any delimiter are encountered, the current data receiving field (identifier-4) is filled with spaces or zeros, according to the description of the data receiving field.

Subtopics:



Previous Topic Next Topic © Copyright IBM Corp. 1991, 1998

IBM Library Server Copyright 1989, 2005 IBM Corporation. All rights reserved.





Return to library:   z/OS | z/OS.e | TPF | z/VSE | z/VM | IBM Hardware | IBM System z Redbooks
Glossary:   IBM terminology
Publications:   How to order publications
Readers:   Download IBM Library Reader | Download IBM Softcopy Reader | Download Adobe® Acrobat® Reader®
Library management:   Download IBM Softcopy Librarian
Contacts:   Contact z/OS


Adobe, the Adobe logo, Acrobat, the Acrobat logo, and Acrobat Reader are registered trademarks of Adobe Systems incorporated.