iq reload schema

[Former Member]

I have performed iqunload -n and have extracted the reloadschema, now all my view procedures are all upper case including the text in the views & procedures. its supppose to be lower case. how do I change it. Also, how do you put the empty data back instead of NULL values with the load table. Much appreciated my dear IQ friends and gurus.

[tayeb_hadjou]

Hi Seetaram,

Regarding the 1st question, what are source and target IQ versions?

2nd question: To controle how empty string fileds are loaded, use option LOAD_ZEROLENGTH_ASNULL.

By default it is OFF in IQ16, which means zerolength (empty) strings will NOT loaded as NULL, but empty strings as they are.

Regards,