Hi guys,
I have a question if you can help me please, I have to use a view created with SQL in place of the physical file, I created the view with sql and I don't have dds for this:
create view library.file_view
as select*from library.pysical_file
where some conditions (some_filed of physical_file ='xx' for example)
I have to change the physical file with the view file in a few cobol programs, but I think I don't have key records for this, I supposed that the view is similar to logical file,
the physical file has 2 fields as keys and it is declared as:
select physical_file to database-physical_file
organization indexed
access mode dynamic
record key is externally-described-key
file status physical_file-status.
Please if you can help me with this, I have to make a logical file with dds with declared key?
I have a question if you can help me please, I have to use a view created with SQL in place of the physical file, I created the view with sql and I don't have dds for this:
create view library.file_view
as select*from library.pysical_file
where some conditions (some_filed of physical_file ='xx' for example)
I have to change the physical file with the view file in a few cobol programs, but I think I don't have key records for this, I supposed that the view is similar to logical file,
the physical file has 2 fields as keys and it is declared as:
select physical_file to database-physical_file
organization indexed
access mode dynamic
record key is externally-described-key
file status physical_file-status.
Please if you can help me with this, I have to make a logical file with dds with declared key?
Comment