Where clause is too long to run in TDM mainframe, how to break it in multiple lines

Products

• CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

The default LRECL is 256, where clause longer than that will fail.

Resolution

1. Increase LRECL
2. Build the MAPCSV like this:

Sample SQL has too long where clause in MAPCVS: 

   AVTALE_CATDM,,WHERE,"UPPER(disponent_navn) not like 'AS %' AND UPPER(disponent_navn) not like '% AS %' AND UPPER(disponent_navn) not like 'ASA %' AND UPPER(disponent_navn) not like '% ASA %' AND.......and upper(disponent_navn) not like '%ENTRE%'",,,,,,,,,,,,,

Try to build the MAPCSV like this:

AVTALE_CATDM,,WHERE,"UPPER(disponent_navn) not like 'AS %'",,,,,,,,,,,,,  
AVTALE_CATDM,,AND,"UPPER(disponent_navn) not like '% AS %'",,,,,,,,,,,,,  
AVTALE_CATDM,,AND,"UPPER(disponent_navn) not like 'ASA %'",,,,,,,,,,,,,  
AVTALE_CATDM,,AND,"UPPER(disponent_navn) not like '% ASA %'",,,,,,,,,,,,,  
AVTALE_CATDM,,AND,"UPPER(disponent_navn) NOT LIKE '%BANK%'",,,,,,,,,,,,,  
AVTALE_CATDM,,AND,"UPPER(disponent_navn) NOT LIKE '%UNION%'",,,,,,,,,,,,,  
AVTALE_CATDM,,AND,"UPPER(disponent_navn) NOT LIKE '%SECUR%'",,,,,,,,,,,,,  
AVTALE_CATDM,,AND,"UPPER(disponent_navn) not like '%A/S'",,,,,,,,,,,,,  
AVTALE_CATDM,,AND,"UPPER(disponent_navn) not like '%SOCIET%'",,,,,,,,,,,,,  
AVTALE_CATDM,,AND,"UPPER(disponent_navn) not like 'SA %'",,,,,,,,,,,,,  
AVTALE_CATDM,,AND,"UPPER(disponent_navn) not like '% SA %'",,,,,,,,,,,,,

... (repeat for each AND in the clause)

AVTALE_CATDM,,AND,"upper(disponent_navn) not like '%ENTRE%'",,,,,,,,,,,,,

AVTALE_CATDM,DISPONENT_NAVN,HASHLOV,FULLNAME,,,,Y,,,,,,,,,
(finalize the clause with the function name etc)