search cancel

Fetching the huge size excel/csv file from ITPAM

book

Article ID: 225712

calendar_today

Updated On:

Products

CA Process Automation Base

Issue/Introduction

Is it possible to fetch large excel/csv file from ITPAM file operators?

Environment

Release : 4.3.X

Component : Process Automation

Resolution

ITPAM can only store 2 MB of data in a dataset variable, so it is not possible to extract more than 2MB data and store into the dataset variable with a single get transaction.

As a workaround, you might use a xls JDBC connection to do select queries to limit the data up to 2MB with each transaction and loop it till the whole data completes.