Emmitt, I think GATEWAY re-reads the RBwhatever.CFG file when you start it. But the DIALOG version has a checkbox for Export as Blanks. Seems like there should be an "OPTION" to match, like BLANK_IF_ZERO, only BLANK_IF_NULL
Bill On Tue, Jun 22, 2010 at 1:32 PM, Emmitt Dove <[email protected]>wrote: > Folks, > > > > I’m using 7.6 to do a GATEWAY EXPORT to an XLSW. Our databases run with > the NULL character set to a single dash, or (CHAR(45)). > > > > In the worksheet I need null columns to be completely empty. > > > > Here’s what I’ve tried: > > > > SET NULL ‘’ -- two quote marks, nothing between them > > GATEWAY EXPORT ….. > > SET NULL ‘-‘ > > > > The problem is that the worksheet still contains dashes where the column > was null. > > > > How do I get those columns to be truly empty? > > > > > > Emmitt Dove > > Manager, Converting Applications Development > > Evergreen Packaging, Inc. > > [email protected] > > (203) 214-5683 m > > (203) 643-8022 o > > (203) 643-8086 f > > [email protected] > > > > > > >
