/PADBYTE - Connect_ETL - 9.13

Connect ETL Data Transformation Language (DTL) Guide

Product type
Software
Portfolio
Integrate
Product family
Connect
Product
Connect > Connect (ETL, Sort, AppMod, Big Data)
Version
9.13
Language
English
Product name
Connect ETL
Title
Connect ETL Data Transformation Language (DTL) Guide
Copyright
2023
First publish date
2003
Last updated
2023-09-11
Published on
2023-09-11T19:01:45.019000

Purpose

To specify the value of the character or byte for padding shortkeys and short records. This pad character or byte is also used for padding a variable length character field to fixed length in fixed position reformats.

Format

/PADBYTE pad_char

where

pad_char = {"a" } {X"xx"}

Arguments

a the pad character.
xx the hexadecimal value of the pad byte.

Location

The option may appear anywhere in the task definition.

Notes

When you specify a pad character or byte through the /PADBYTE option, Connect ETL uses that to pad short keys and short records encountered during the task as well as to pad character fields to the specified fixed length in fixed-position reformats. Key fields are padded only for the duration of the task but record padding and padding in fixed-position reformats survive in the records output from Connect ETL.

Padbyte can only be a single byte ASCII characher or Hex byte. When a target record requires padding, ASCII characters are converted to the target record encoding.

If you do not specifythe /PADBYTE option, Connect ETL uses the null byte X"00" to pad short keys, fields, and records.

Examples

/padbyte "a" 
The lowercase a will be used to pad short keys, fields, and records.
/PADBYTE x"20" 

The byte whose hexadecimal value is 20 will be used to pad short keys, fields, and records.