I have a scenario where a same VSAM file will be accessed by multiple Jobs at the same time in read mode. Is it possible to access or it will fail for accessing problem.
if you will access the file in the edit mode it will fail (exclusive use in the edit mode) however if you will access this in the view or browse mode no problem at all..
First u choose the method of communication with db2 which could be one of these
Static SQL
? Embedded dynamic SQL
? Open Database Connectivity (ODBC)
? JDBC application support
Then u declare all the tables and views required in the w-s section/linkage section
U then declare host variables and host structures.These are required for holding the data that is being retreived from the table something similar to the w-s variables we have in a cobo pgm.
then follows the precompile ,bind process after u finished writing the complete program