Issue in Downloading Large Files using Download Tool

[sveerakutty]

I am trying to download dataset from IBM Mainframe which has a 6 million records with 100 character width. When selecting 

String as Output, I get error message as it hits the maximum size of string: 2147483648 bytes. But, if I download as File, I am not able to encode the data (IBM EBCDIC) to text. I would appreciate if anyone could help me. Thx.

[MatthewO]

Hi @sveerakutty:

You may have found a solution already but I have a few recommendations for you.

• Download the data to a Blob field, then convert the data to text using the Blob Convert tool.
• Rather than downloading to a field, write the data to a file then read it in using a Dynamic Input tool.

I hope this is helpful for you!