Unloading and loading a table with NULLable columns
Posted:
Mon Jul 15, 2019 7:10 pmby Mohanesvar_97
I have NULLable fields in my table. I need to create unload file for that table with the help of JCL, and load it again in another mainframe region. Can anyone assist me in handling the NULL values, both during unloading and loading phases, using DFSORT utility?
Re: Unloading and loading a table with NULLable columns
Posted:
Tue Jul 16, 2019 3:30 pmby NicC
If you want a sort solution why post in the DB2 forum? JCL has next to nothing to do with the problem - yes, you will need it to run your solution in batch but it will not help you define what your program is to do.
Why not use the DB2 unload/reload utilities?