Unloading and loading a table with NULLable columns



IBM's flagship relational database management system

Unloading and loading a table with NULLable columns

Postby Mohanesvar_97 » Mon Jul 15, 2019 7:10 pm

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?
Mohanesvar_97
 
Posts: 1
Joined: Mon Jul 15, 2019 7:00 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Unloading and loading a table with NULLable columns

Postby NicC » Tue Jul 16, 2019 3:30 pm

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?
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 3025
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisies (almost)
Has thanked: 4 times
Been thanked: 136 times


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post