Re: Urgent: LOAD problem

In article <34999813.27054722@netnews.upenn.edu>, Al Wang <alwang@NOSPAMdoubt.com> writes >Hi, > > >I'm in the eleventh hour of a project here, and I've hit a snag, so >any help, preferably by email (alwang@doubt.com), would be >appreciated. > >If you are using LOAD to insert records in a text file, how do you >represent a Null value in the last item in the row? You can't just >end with a delimiter. I know you can use the fixed-length format with >dbload, but my schema uses a lot of complex datatypes, so that won't >work. create table a ( a int, b char(10) ) load into this table the following file 1|| Load files have a | AFTER EACH FIELD. The first field is loaded with '1' and the second becomes NULL!!. I think '' becomes ' '. (' ' CLIPPED = '' and since 4gl variables have trailing spaces unless clipped you can't tell the difference in 4gl!!). > >If anyone else has had any experience importing ASN.1 data into IUS, >I'd appreciate your comments. > >Thanks, >Al >Al Wang >http://www.seas.upenn.edu/~alwang >remove NOSPAM to reply -- David Williams