Skip to Content
Custom Search

Reply to comment

Joined: 12/26/2011
db2 load from vsam
[quote]I am looking for a better solution, I do not want to create the intermediate flat file.[/quote] I believe you do want the intermediate file - both for dealing with anything "special" and for performance. If you read vsam / insert db2 you will have chosen what is probably the worst possible alternative if performance might be an issue. If the largest table has only 100 rows, this could work, but i've found using the same approach for all of the file-to-table processes is more understandable to others. If you retain the intermediate data in a common backup (adrdssu/dfdss) you can get back to different loads if ever needed. I would use the LOAD rather than some other method.


  • Allowed HTML tags:
      1. Lines and paragraphs break automatically.

    More information about formatting options

    This question is for testing whether you are a human visitor and to prevent automated spam submissions.


Click the +1 button  below to share it with your friends and colleagues


Share this if you liked it!



Number of Registered users 714
Theme by Dr. Radut.