How to change default settings of Table definition import

rajeshknl · Post by **rajeshknl** » Thu Jul 24, 2008 3:24 pm

By default when you import a sequential file definition the "nullable" columun is set to "NO". I have 800 columns in my table. it is hard to change them manually. Is there a way to change the default setting to "Yes".

ray.wurlod · Post by **ray.wurlod** » Thu Jul 24, 2008 3:34 pm

No. The reasoning behind the default is that, in a sequential file, *something* actually has to be there, even if it is "".

chulett · Post by **chulett** » Thu Jul 24, 2008 4:51 pm

In other words, the columns can be empty but not null. Null means 'Unknown' and is a database concept not applicable to sequential files.

chulett · Post by **chulett** » Thu Jul 24, 2008 10:28 pm

Hmmm... we really frown on hijacking other people's threads around here. You really should start your own conversation, even if it is related to an existing topic. And especially when it isn't.

rajeshknl · Post by **rajeshknl** » Fri Jul 25, 2008 8:38 am

I found a solution. we can export the table definition created. open it in a text editor and find and replace with you want. this works. for example i changed the nullable option to 'yes' in the text file. then you re-import that file.