Can anyone explaining what's happening !!! 
Author Message
 Can anyone explaining what's happening !!!

Hi!


[snip]

Quote:

>This is my control file

>load data
>infile 'PRODUCT1.TXT'
>Append
>into table PRODMAST_TEST
>(PRODCODE position (01:05)NUMBER
>PRODDESC position (06:25)char,
>LABCODE position (26:29)CHAR,
>LAUNCHMY position (30:35)NUMBER,
>UPDPERIOD position (36:39)char,
>GENERIC_FLAG position (40:40)char,
>DELFLAG position (41:41)char,
>)

It's been a while since i did any SQL*Loader work, but I am quite certain
that you should use "integer external" instead of "number" in the control
file.

HTH,

Roy Brokvam



Sat, 11 Aug 2001 03:00:00 GMT
 Can anyone explaining what's happening !!!


Quote:
>I am facing very unique problem with SQL Loader.
>This is my control file

>load data
>infile 'PRODUCT1.TXT'
>Append
>into table PRODMAST_TEST
>(PRODCODE position (01:05)NUMBER

                                                  ^^^^^^^^^

Since the data in your file are expressed as characters,
you can specify the date type "CHAR" in spite of the column data type, as
following:

    PRODCODE position (01:05) CHAR

Quote:
>PRODDESC position (06:25)char,
>LABCODE position (26:29)CHAR,
>LAUNCHMY position (30:35)NUMBER,
>UPDPERIOD position (36:39)char,
>GENERIC_FLAG position (40:40)char,
>DELFLAG position (41:41)char,
>)
>when I run the control file  I am getting below error

>SQL * Loader 350
>Syntax error at line 5
>expecting valid column specification, or ",")", found "NUMBER"
>PRODCODE position (01:05)NUMBER



Mon, 13 Aug 2001 03:00:00 GMT
 Can anyone explaining what's happening !!!
Hi!

[snip]

Quote:

>Since the data in your file are expressed as characters,
>you can specify the date type "CHAR" in spite of the column data type, as
>following:

[snip]

I think the type specification in the control file is used for value
checking, so there will be a difference to "who" detects an ill-formed
number - sql*loader or the database.

Regards,

Roy Brokvam



Tue, 14 Aug 2001 03:00:00 GMT
 Can anyone explaining what's happening !!!
Hi ,

Remove the "," at the end of the delflag column specification and you should be
OK.

RBG



Wed, 15 Aug 2001 03:00:00 GMT
 
 [ 8 post ] 

 Relevant Pages 

1. Can anyone explain how this could have happened?

2. Can anyone explain 'a grinding halt'?

3. Anyone know of some canned (cheap or free) DB performance testing software

4. if you will promise Allahdad's swamp against cans, it will angrily depart the unit

5. Invalid Login 'sa' - Still Happening

6. Unexpected Error happened on 'Open Table'

7. Has anyone seen this happen???

8. Does anyone happen fail installing MSDE2000?

9. Anyone happen to know why?

10. PROBLEM WITH 'EXPLAIN PLAN'

11. Cost as used in 'EXPLAIN PLAN'

12. Anyone else have this happen?


 
Powered by phpBB® Forum Software