Lets Hide some Line data!

Previous topic - Next topic

htees

I have been asked to OMIT/Hide the index data that is sent over in a line data report.  The first thirty characters of each line contains index data, and our customer wants us to exclude it from the stored report.  My problem: I can't create AFP output as the customer desires the report to remain as line data as they want to be able to download the report into a text file, so using a pagedef/format to exclude the index fields isn't really an option as the report would then be converted to PDF.  A sample of how the file comes over:

1201407019545829201CP         1CP1CP10IPPOLITO\RONALD\R\               2014010103
  201407019545829201CP          1CP1CP40IPPOLITO\CHRISTINE B \          2014010103
  201407019545829201CP          1CP1CP10HARLAN\CHARLES\D\                2014010131
  201407019545829201CP          1CP1CP40HARLAN\CATHRYN O\                2014010131
  201407019545829201CP          1CP1CP20VAZQUEZ-LUGO\DIANA\L\        20140501AS
  201407019545829201CP          1CP1CP20VAZQUEZ-LUGO\DIANA\L\        20140501DH

Anyone done some fancy hiding of index fields?

Thanks

Harold Thomas (HT)

Justin Derrick

This isn't really something CMOD does.  OnDemand strives to ensure document fidelity -- what goes in is what comes out. 

You'll likely have to build some sort of input exit that works in conjunction with your indexing, or build your own indexer that reads the file, excludes the index data, and produces a generic index file for the load. 

-JD.
Call:  +1-866-533-7742  or  eMail:  jd@justinderrick.com
IBM CMOD Wiki:  https://CMOD.wiki/
FREE IBM CMOD Webinars:  https://CMOD.Training/
IBM CMOD Professional Services: https://CMOD.cloud

Interests: #AIX #Linux #Multiplatforms #DB2 #TSM #SP #Performance #Security #Audits #Customizing #Availability #HA #DR