TTP output file not getting zipped when .gz is used as file extension

Tools & Utilities

TTP output file not getting zipped when .gz is used as file extension

Hello All,

We are trying to create a zipped text file extract from a Teradata table using TPT script. We have named the file as <file_name>.dat.gz but for some strange reasons the out file does not get zipped (in Prod). Though the output file name reads as abc.dat.gz the file is not zipped. Interestingly the same script works fine in Dev environment.

I have provided the tpt version details below for your reference.

            ATTRIBUTES

           (

                  FileName = abc.dat.gz,

                  Format = 'DELIMITED',

                  OpenMode = 'Write',

                  IndicatorMode = 'N',

                  TextDelimiter = '|'

            )

Dev Version:

Teradata Parallel Transporter Version 13.10.00.09 

Teradata Parallel Transporter DataConnector Version 13.10.00.09  

Teradata Parallel Transporter Export Operator Version 13.10.00.05 

Prod Version:

Teradata Parallel Transporter Version 13.10.00.01 

Teradata Parallel Transporter DataConnector Version 13.10.00.01 

Teradata Parallel Transporter Export Operator Version 13.10.00.05 


Could the version difference be a reason for this issue?

Apprecaite your time and help.

Thanks,

Senthil Bathirappan

Tags (1)
1 REPLY
Enthusiast

Re: TTP output file not getting zipped when .gz is used as file extension

The zip/gzip support was added to 13.10 in efix 08.

Their were some additional fixes in efix 020.   Please upgrade to the currentlatest 13.1o efix.

Thanks