Urgent: LOAD problem 
Author Message
 Urgent: LOAD problem

Hi,

I'm in the eleventh hour of a project here, and I've hit a snag, so

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.

If anyone else has had any experience importing ASN.1 data into IUS,
I'd appreciate your comments.

Thanks,
Al
Al Wang
http://www.***.com/ ~alwang
remove NOSPAM to reply



Wed, 18 Jun 1902 08:00:00 GMT
 Urgent: LOAD problem



Quote:
>Hi,

>I'm in the eleventh hour of a project here, and I've hit a snag, so

>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!!).

Quote:

>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


Wed, 18 Jun 1902 08:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Urgent: LOAD problem #2

2. Problem Urgent VB5 : Cannot Load MSRDO20.dll

3. *** URGENT - Dump/Load problem ***

4. Urgent Problem with Load Database ASE 11.9.2 /HPUX

5. Delimiter problem/corruption on LOAD function..... urgent

6. Problem Using DDE : URGENT URGENT URGENT

7. Problems loading data: LOAD vs. DTS

8. SQL*Loader problem: Not loading Spaces into NULL column through direct load

9. URGENT --- Installation Problem --- URGENT

10. URGENT --- Installation Problem --- URGENT

11. URGENT --- Installation Problem --- URGENT

12. Urgent :could not load the Merge Replication Provider ??...


 
Powered by phpBB® Forum Software