I am working on a project in which I use the IBM JDBC driver to execute SQL statements on the database.
The issue I am running into involves empty fields in a physical file. My project is aiming to modernize/replace a few programs that are currently in use now; one of them being an old DFU program to update employee numbers for a given station/shift.
If the station did not run they are currently just clearing the employee number out of the field in the DFU program and saving the changes which results in field appearing blank (even though it is numeric) in the file when I pull it up in DBU.
I can't seem to figure out how I would achieve a similar result using SQL. I would really prefer to avoid going with a default value since it is hard for me to know exactly how many older programs we have that access the file and might possibly rely on them being blank for whatever reason.
I've tried using NULL but that does not play nice with these DDS described physical files
The issue I am running into involves empty fields in a physical file. My project is aiming to modernize/replace a few programs that are currently in use now; one of them being an old DFU program to update employee numbers for a given station/shift.
If the station did not run they are currently just clearing the employee number out of the field in the DFU program and saving the changes which results in field appearing blank (even though it is numeric) in the file when I pull it up in DBU.
I can't seem to figure out how I would achieve a similar result using SQL. I would really prefer to avoid going with a default value since it is hard for me to know exactly how many older programs we have that access the file and might possibly rely on them being blank for whatever reason.
I've tried using NULL but that does not play nice with these DDS described physical files
Comment