Batch update using script

[rupali_23]

Hi Everyone,

Anyone can help me on this.

I need to do batch update like 100 records then commit, using shell script withput using EIM or sqc.

[Patrick Wallek]

>>I need to do batch update like 100 records then commit

Where are these records?  In a text file?  KSAM / ISAM file?  Database?  If a database, what kind?

Most databases have ways to do this.  You may need to ask your DBA.

[rupali_23]

Records are in txt file and DB that we are using is DB2. In DB, we have a .sh script file that we need to process.

[Bill Hassell]

>> Records are in txt file and DB that we are using is DB2. In DB, we have a .sh script file that we need to process.

There are two parts to this question: 
..A knowledge of DB2 and the database schema
..A knowledge of shell scripting and how to edit a script file.

Do you have DB2 administrators? Perhaps they could help you.