Then I say with my experience I would do the opposite

SET NULL -0-
UNLOAD ...
SET NULL ' '

But maybe I am not understanding what you try to do!

Gunnar Ekblad

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Charles
Parks
Sent: den 27 juli 2004 19:52
To: RBG7-L Mailing List
Subject: [RBG7-L] - Re: Set Null

I'm doing an unload command so I have

SET NULL ' '
UNLOAD ...
SET NULL -0-

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Gunnar
Ekblad
Posted At: Tuesday, July 27, 2004 12:29 PM
Posted To: RB7-L
Conversation: [RBG7-L] - Re: Set Null
Subject: [RBG7-L] - Re: Set Null


Let me add, maybe everybody already knows this, but be careful to set it
back -0- I would say before or when you exit the database

Gunnar Ekblad


-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Albert
Berry
Sent: den 27 juli 2004 19:22
To: RBG7-L Mailing List
Subject: [RBG7-L] - Re: Set Null

SET NULL ' '
The equals sign is incorrect.

>>
Charles Parks <[EMAIL PROTECTED]> wrote:
Is there a way to set nulls to a space character?

I have tried
SET NULL 
SET NULL = ' '

and neither works.



=====
Albert Berry 
Management Consultant
RR2 - 1252 Ponderosa Drive
Sparwood BC, V0B 2G2 
Canada
(250) 425-5806
(250) 425-7259
(708) 575-3952 (fax)
[EMAIL PROTECTED]

Reply via email to