Home » SQL & PL/SQL » SQL & PL/SQL » External Tables (10g)
External Tables [message #363062] Fri, 05 December 2008 00:12 Go to next message
user71408
Messages: 585
Registered: November 2007
Location: NE
Senior Member

Hi,
I have one external file A.txt and i want to use the external table to read that file.
But I am getting error as below -
select * from III

ORA-29913: error in executing ODCIEXTTABLEOPEN callout

ORA-29400: data cartridge error

KUP-00554: error encountered while parsing access parameters

KUP-01005: syntax error: found "identifier": expecting one 
of: "double-quoted-string, eof, hexprefix, single-quoted-string, whitespace"
KUP-01008: the bad identifier was: X
KUP-01007: at line 3 column 31
ORA-06512: at "SYS.ORACLE_LOADER", line 14
ORA-06512: at line 1
----------------------------------------------------------------------------------------------------------------------------------------------------------------------

Table is -
CREATE TABLE III 
(
 LEADINGSOURCESYSTEMNAME VARCHAR2 (50), 
 ARTEMISSOURCESYSTEMTRADEID VARCHAR2 (50), 
 LEADINGSOURCESYSTEMID VARCHAR2 (50), 
 REPORTINGDATE DATE, 
 TEAMLEVEL4 VARCHAR2 (50), 
 TEAMLEVEL1 VARCHAR2 (50), 
 EMPLOYEELASTFIRSTNAME VARCHAR2 (50), 
 PORTFOLIO VARCHAR2 (50), 
 TRADINGDESKLEOU VARCHAR2 (50), 
 TRADERLASTFIRSTNAME VARCHAR2 (50), 
 PRODUCTLEVEL3 VARCHAR2 (50), 
 BUSINESSHIERARCHYNAMELEVEL6 VARCHAR2 (50), 
 BUSINESSHIERARCHYNAMELEVEL4 VARCHAR2 (50), 
 RAZZAHIERNAMELEVEL7 VARCHAR2 (50), 
 RAZZAHIERNAMELEVEL9 VARCHAR2 (50), 
 XNETCVA NUMBER (22,2), 
 ACREDITCHARGE NUMBER (22,2) 
   )
ORGANIZATION EXTERNAL
 ( type oracle_loader
 default directory EXT_TABLES 
 access parameters
 ( records delimited BY newline
  nologfile nobadfile
 FIELDS TERMINATED BY X'09' TRAILING NULLCOLS
 missing field VALUES are NULL
( LEADINGSOURCESYSTEMNAME VARCHAR2 (50), 
  ARTEMISSOURCESYSTEMTRADEID VARCHAR2 (50), 
  LEADINGSOURCESYSTEMID VARCHAR2 (50), 
  REPORTINGDATE DATE, 
  TEAMLEVEL4 VARCHAR2 (50), 
  TEAMLEVEL1 VARCHAR2 (50), 
  EMPLOYEELASTFIRSTNAME VARCHAR2 (50), 
  PORTFOLIO VARCHAR2 (50), 
  TRADINGDESKLEOU VARCHAR2 (50), 
  TRADERLASTFIRSTNAME VARCHAR2 (50), 
  PRODUCTLEVEL3 VARCHAR2 (50), 
  BUSINESSHIERARCHYNAMELEVEL6 VARCHAR2 (50), 
  BUSINESSHIERARCHYNAMELEVEL4 VARCHAR2 (50), 
  RAZZAHIERNAMELEVEL7 VARCHAR2 (50), 
  RAZZAHIERNAMELEVEL9 VARCHAR2 (50), 
  XNETCVA NUMBER (22,2), 
  ACREDITCHARGE NUMBER (22,2) ,
 )
)
location ('ird.txt')
);

Please look into this and give me the suggestion.

Thank you

[Updated on: Fri, 05 December 2008 00:16]

Report message to a moderator

Re: External Tables [message #363065 is a reply to message #363062] Fri, 05 December 2008 00:21 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
SQL> CREATE TABLE III 
  2  (
  3   LEADINGSOURCESYSTEMNAME VARCHAR2 (50), 
  4   ARTEMISSOURCESYSTEMTRADEID VARCHAR2 (50), 
  5   LEADINGSOURCESYSTEMID VARCHAR2 (50), 
  6   REPORTINGDATE DATE, 
  7   TEAMLEVEL4 VARCHAR2 (50), 
  8   TEAMLEVEL1 VARCHAR2 (50), 
  9   EMPLOYEELASTFIRSTNAME VARCHAR2 (50), 
 10   PORTFOLIO VARCHAR2 (50), 
 11   TRADINGDESKLEOU VARCHAR2 (50), 
 12   TRADERLASTFIRSTNAME VARCHAR2 (50), 
 13   PRODUCTLEVEL3 VARCHAR2 (50), 
 14   BUSINESSHIERARCHYNAMELEVEL6 VARCHAR2 (50), 
 15   BUSINESSHIERARCHYNAMELEVEL4 VARCHAR2 (50), 
 16   RAZZAHIERNAMELEVEL7 VARCHAR2 (50), 
 17   RAZZAHIERNAMELEVEL9 VARCHAR2 (50), 
 18   XNETCVA NUMBER (22,2), 
 19   ACREDITCHARGE NUMBER (22,2) 
 20     )
 21  ORGANIZATION EXTERNAL
 22   ( type oracle_loader
 23   default directory EXT_TABLES 
 24   access parameters
 25   ( records delimited BY newline
 26    nologfile nobadfile
 27   FIELDS TERMINATED BY X'09' TRAILING NULLCOLS
 28   missing field VALUES are NULL
 29  ( LEADINGSOURCESYSTEMNAME VARCHAR2 (50), 
 30    ARTEMISSOURCESYSTEMTRADEID VARCHAR2 (50), 
 31    LEADINGSOURCESYSTEMID VARCHAR2 (50), 
 32    REPORTINGDATE DATE, 
 33    TEAMLEVEL4 VARCHAR2 (50), 
 34    TEAMLEVEL1 VARCHAR2 (50), 
 35    EMPLOYEELASTFIRSTNAME VARCHAR2 (50), 
 36    PORTFOLIO VARCHAR2 (50), 
 37    TRADINGDESKLEOU VARCHAR2 (50), 
 38    TRADERLASTFIRSTNAME VARCHAR2 (50), 
 39    PRODUCTLEVEL3 VARCHAR2 (50), 
 40    BUSINESSHIERARCHYNAMELEVEL6 VARCHAR2 (50), 
 41    BUSINESSHIERARCHYNAMELEVEL4 VARCHAR2 (50), 
 42    RAZZAHIERNAMELEVEL7 VARCHAR2 (50), 
 43    RAZZAHIERNAMELEVEL9 VARCHAR2 (50), 
 44    XNETCVA NUMBER (22,2), 
 45    ACREDITCHARGE NUMBER (22,2) ,
 46   )
 47  )
 48  location ('ird.txt')
 49  );

Table created.

SQL> select * from III;
select * from III
*
ERROR at line 1:
ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error
KUP-00554: error encountered while parsing access parameters
KUP-01005: syntax error: found "identifier": expecting one of: "column, enclosed, exit, (, ltrim, lrtrim, ldrtrim,
missing, notrim, optionally, rtrim, reject"
KUP-01008: the bad identifier was: TRAILING
KUP-01007: at line 3 column 29
ORA-06512: at "SYS.ORACLE_LOADER", line 19

What is at the end of line 45?

Make sure that lines of code do not exceed 80 characters when you format.
Use the "Preview Message" button to verify.
Also always post your Oracle version (4 decimals).


Regards
Michel

[Updated on: Fri, 05 December 2008 00:24]

Report message to a moderator

Re: External Tables [message #363067 is a reply to message #363065] Fri, 05 December 2008 00:24 Go to previous messageGo to next message
user71408
Messages: 585
Registered: November 2007
Location: NE
Senior Member

Micheal,

I have this much bog table . So I am not able to decrease the size. But please give me the solution for this.

Thank you.
Re: External Tables [message #363069 is a reply to message #363067] Fri, 05 December 2008 00:27 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Also:
Quote:
KUP-01008: the bad identifier was: TRAILING


Quote:
I have this much bog table . So I am not able to decrease the size.

I talked about line size: Why do you put so much useless spaces at then end?
ALWAYS remove them.

In addition, you didn't answer one IMPORTANT question:
Quote:
Also always post your Oracle version (4 decimals).


You want help, post the requested, useful and mandatory information.

Regards
Michel
Re: External Tables [message #363070 is a reply to message #363062] Fri, 05 December 2008 00:33 Go to previous messageGo to next message
user71408
Messages: 585
Registered: November 2007
Location: NE
Senior Member

Hi,
I have one external file A.txt and i want to use the external table to read that file.
But I am getting error as below -
select * from III
ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error
KUP-00554: error encountered while parsing access parameters
KUP-01005: syntax error: found "identifier": expecting one 
of: "double-quoted-string, eof, hexprefix, single-quoted-string, whitespace"
KUP-01008: the bad identifier was: X
KUP-01007: at line 3 column 31
ORA-06512: at "SYS.ORACLE_LOADER", line 14
ORA-06512: at line 1

Table is -
CREATE TABLE III 
(
 LEADINGSOURCESYSTEMNAME VARCHAR2 (50), 
 ARTEMISSOURCESYSTEMTRADEID VARCHAR2 (50), 
 LEADINGSOURCESYSTEMID VARCHAR2 (50), 
 REPORTINGDATE DATE, 
 TEAMLEVEL4 VARCHAR2 (50), 
 TEAMLEVEL1 VARCHAR2 (50), 
 EMPLOYEELASTFIRSTNAME VARCHAR2 (50), 
 PORTFOLIO VARCHAR2 (50), 
 TRADINGDESKLEOU VARCHAR2 (50), 
 TRADERLASTFIRSTNAME VARCHAR2 (50), 
 PRODUCTLEVEL3 VARCHAR2 (50), 
 BUSINESSHIERARCHYNAMELEVEL6 VARCHAR2 (50), 
 BUSINESSHIERARCHYNAMELEVEL4 VARCHAR2 (50), 
 RAZZAHIERNAMELEVEL7 VARCHAR2 (50), 
 RAZZAHIERNAMELEVEL9 VARCHAR2 (50), 
 XNETCVA NUMBER (22,2), 
 ACREDITCHARGE NUMBER (22,2) 
   )
ORGANIZATION EXTERNAL
 ( type oracle_loader
 default directory EXT_TABLES 
 access parameters
 ( records delimited BY newline
  nologfile nobadfile
 FIELDS TERMINATED BY X'09' TRAILING NULLCOLS
 missing field VALUES are NULL
( LEADINGSOURCESYSTEMNAME VARCHAR2 (50), 
  ARTEMISSOURCESYSTEMTRADEID VARCHAR2 (50), 
  LEADINGSOURCESYSTEMID VARCHAR2 (50), 
  REPORTINGDATE DATE, 
  TEAMLEVEL4 VARCHAR2 (50), 
  TEAMLEVEL1 VARCHAR2 (50), 
  EMPLOYEELASTFIRSTNAME VARCHAR2 (50), 
  PORTFOLIO VARCHAR2 (50), 
  TRADINGDESKLEOU VARCHAR2 (50), 
  TRADERLASTFIRSTNAME VARCHAR2 (50), 
  PRODUCTLEVEL3 VARCHAR2 (50), 
  BUSINESSHIERARCHYNAMELEVEL6 VARCHAR2 (50), 
  BUSINESSHIERARCHYNAMELEVEL4 VARCHAR2 (50), 
  RAZZAHIERNAMELEVEL7 VARCHAR2 (50), 
  RAZZAHIERNAMELEVEL9 VARCHAR2 (50), 
  XNETCVA NUMBER (22,2), 
  ACREDITCHARGE NUMBER (22,2) ,
 )
)
location ('ird.txt')
);

Version is  10.2.0.4

[Updated on: Fri, 05 December 2008 00:34]

Report message to a moderator

Re: External Tables [message #363072 is a reply to message #363069] Fri, 05 December 2008 00:44 Go to previous messageGo to next message
user71408
Messages: 585
Registered: November 2007
Location: NE
Senior Member

Michael ,

Version is 10.2.0.4
Re: External Tables [message #363074 is a reply to message #363072] Fri, 05 December 2008 00:48 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Did you read my 2 previous entirely?
Quote:
What is at the end of line 45?

Quote:
KUP-01008: the bad identifier was: TRAILING

Which is for you:
Quote:
KUP-01008: the bad identifier was: X

Did you investigate on this?

Regards
Michel
Re: External Tables [message #363082 is a reply to message #363074] Fri, 05 December 2008 01:04 Go to previous messageGo to next message
user71408
Messages: 585
Registered: November 2007
Location: NE
Senior Member

Hi,

I am using Oracle 9i.

I removed the data from line 45 and now it is giving the below error
select * from iii

ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error
KUP-00554: error encountered while parsing access parameters
KUP-01005: syntax error: found "identifier": expecting one of: "double-quoted-string, eof, hexprefix, single-quoted-
string, whitespace"
KUP-01008: the bad identifier was: X
KUP-01007: at line 3 column 31
ORA-06512: at "SYS.ORACLE_LOADER", line 14
ORA-06512: at line 1


Please look into this.

[Updated on: Fri, 05 December 2008 01:05]

Report message to a moderator

Re: External Tables [message #363086 is a reply to message #363082] Fri, 05 December 2008 01:18 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
user71408 wrote on Fri, 05 December 2008 08:04
Hi,

I am using Oracle 9i.

I removed the data from line 45 and now it is giving the below error


What "data" exactly did you remove from line 45?
Why don't you answer Michaels question to show you understand what he's pointing at?
Quote:
What is at the end of line 45?
Re: External Tables [message #363088 is a reply to message #363086] Fri, 05 December 2008 01:21 Go to previous messageGo to next message
user71408
Messages: 585
Registered: November 2007
Location: NE
Senior Member

I have deleted the comma at the end in the line 45.and execute the same. Then I am getting the error what i have posted now.
Re: External Tables [message #363090 is a reply to message #363088] Fri, 05 December 2008 01:30 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I mentioned 2 things you fix one, fix the other one.

Regards
Michel
Re: External Tables [message #363091 is a reply to message #363082] Fri, 05 December 2008 01:32 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And to prevent from other roundtrip.
Verify the syntax for external table access parameters (and SQL*Loader ones).
Are you sure you can use:
...
  TRADINGDESKLEOU VARCHAR2 (50), 
  TRADERLASTFIRSTNAME VARCHAR2 (50), 
  PRODUCTLEVEL3 VARCHAR2 (50), 
  BUSINESSHIERARCHYNAMELEVEL6 VARCHAR2 (50), 
  BUSINESSHIERARCHYNAMELEVEL4 VARCHAR2 (50), 
...

In SQL*Loader control file?

Regards
Michel
Re: External Tables [message #363124 is a reply to message #363091] Fri, 05 December 2008 02:51 Go to previous messageGo to next message
user71408
Messages: 585
Registered: November 2007
Location: NE
Senior Member

Hi,

I have changed the datatype what I mentioned as Varchar2 (50),...

But still am getting the same error.
Re: External Tables [message #363125 is a reply to message #363124] Fri, 05 December 2008 02:52 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I see no change in what you posted.

Regards
Michel
Re: External Tables [message #363129 is a reply to message #363125] Fri, 05 December 2008 02:58 Go to previous messageGo to next message
user71408
Messages: 585
Registered: November 2007
Location: NE
Senior Member

I hav changed as follows.
drop table iii
Table dropped

CREATE TABLE iii (
leadingsourcesystemname VARCHAR2(50),
artemissourcesystemtradeid VARCHAR2(50),
leadingsourcesystemid VARCHAR2(50),
reportingdate DATE,
teamlevel4 VARCHAR2(50),
teamlevel1 VARCHAR2(50),
employeelastfirstname VARCHAR2(50),
portfolio VARCHAR2(50),
tradingdeskleou VARCHAR2(50),
traderlastfirstname VARCHAR2(50),
productlevel3 VARCHAR2(50),
businesshierarchynamelevel6 VARCHAR2(50),
businesshierarchynamelevel4 VARCHAR2(50),
razzahiernamelevel7 VARCHAR2(50),
razzahiernamelevel9 VARCHAR2(50),
xnetcva NUMBER(22,2),
acreditcharge NUMBER(22,2)
)
 
ORGANIZATION EXTERNAL
( TYPE oracle_loader DEFAULT DIRECTORY EXT_TABLES ACCESS PARAMETERS (
RECORDS DELIMITED BY NEWLINE FIELDS TERMINATED BY x'09'
MISSING FIELD VALUES ARE NULL ) LOCATION ( 'ird.txt' ) )
Table created

select * from iii
 
ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error
KUP-00554: error encountered while parsing access parameters
KUP-01005: syntax error: found "identifier": expecting one of: "double-quoted-string, eof, hexprefix, single-quoted-
string, whitespace"
KUP-01008: the bad identifier was: x
KUP-01007: at line 1 column 51
ORA-06512: at "SYS.ORACLE_LOADER", line 14
ORA-06512: at line 1

Re: External Tables [message #363132 is a reply to message #363125] Fri, 05 December 2008 03:08 Go to previous messageGo to next message
user71408
Messages: 585
Registered: November 2007
Location: NE
Senior Member

Michael,
I changed the script but it is giving the same error -
drop table iii;
CREATE TABLE iii (
lname VARCHAR2 (50),
artemi VARCHAR2 (50),
lsystemid VARCHAR2 (50),
reportingdate DATE,
teamlevel4 VARCHAR2 (50),
teamlevel1 VARCHAR2 (50),
empname VARCHAR2 (50),
portfolio VARCHAR2 (50),
leou VARCHAR2 (50),
name VARCHAR2 (50),
level3 VARCHAR2 (50),
b6 VARCHAR2 (50),
b4 VARCHAR2 (50),
r7 VARCHAR2(50),
r9 VARCHAR2(50),
xnetcva NUMBER(22,2),
acreditcharge NUMBER(22,2)
)

ORGANIZATION EXTERNAL
( TYPE oracle_loader DEFAULT DIRECTORY EXT_TABLES ACCESS PARAMETERS (
RECORDS DELIMITED BY NEWLINE FIELDS TERMINATED BY x'09' 
MISSING FIELD VALUES ARE NULL ) LOCATION ( 'ird.txt' ) );

[Updated on: Fri, 05 December 2008 03:44] by Moderator

Report message to a moderator

Re: External Tables [message #363138 is a reply to message #363125] Fri, 05 December 2008 03:39 Go to previous messageGo to next message
user71408
Messages: 585
Registered: November 2007
Location: NE
Senior Member

Michael,

after changes am getting the following error.

select * from iii
ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error
KUP-00554: error encountered while parsing access parameters
KUP-01005: syntax error: found "identifier": expecting one of: "double-quoted-string, eof, hexprefix, single-quoted-
string, whitespace"
KUP-01008: the bad identifier was: x
KUP-01007: at line 1 column 51
ORA-06512: at "SYS.ORACLE_LOADER", line 14
ORA-06512: at line 1
Re: External Tables [message #363139 is a reply to message #363138] Fri, 05 December 2008 03:46 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
For me it works:
SQL> CREATE TABLE iii (
  2  lname VARCHAR2 (50),
  3  artemi VARCHAR2 (50),
  4  lsystemid VARCHAR2 (50),
  5  reportingdate DATE,
  6  teamlevel4 VARCHAR2 (50),
  7  teamlevel1 VARCHAR2 (50),
  8  empname VARCHAR2 (50),
  9  portfolio VARCHAR2 (50),
 10  leou VARCHAR2 (50),
 11  name VARCHAR2 (50),
 12  level3 VARCHAR2 (50),
 13  b6 VARCHAR2 (50),
 14  b4 VARCHAR2 (50),
 15  r7 VARCHAR2(50),
 16  r9 VARCHAR2(50),
 17  xnetcva NUMBER(22,2),
 18  acreditcharge NUMBER(22,2)
 19  )
 20  ORGANIZATION EXTERNAL
 21  ( TYPE oracle_loader DEFAULT DIRECTORY EXT_TABLES ACCESS PARAMETERS (
 22  RECORDS DELIMITED BY NEWLINE FIELDS TERMINATED BY x'09' 
 23  MISSING FIELD VALUES ARE NULL ) LOCATION ( 'ird.txt' ) );

Table created.

SQL> select * from iii
  2  /
select * from iii
*
ERROR at line 1:
ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error
KUP-04040: file ird.txt in EXT_TABLES not found
ORA-06512: at "SYS.ORACLE_LOADER", line 19

SQL> @v

Version Oracle : 10.2.0.4.0

Use SQL*Plus and execute the same.

Regards
Michel

[Updated on: Fri, 05 December 2008 03:46]

Report message to a moderator

Re: External Tables [message #363143 is a reply to message #363139] Fri, 05 December 2008 03:52 Go to previous messageGo to next message
user71408
Messages: 585
Registered: November 2007
Location: NE
Senior Member

Hi,

Error resolved -
Syntax problem in the query.
But now the problem is it is not showing any data. - can u
check the query at your end with the feed file i had send to you.
 
create table aa ( lname VARCHAR2 (50),
artemi VARCHAR2 (50),
lsystemid VARCHAR2 (50),
reportingdate DATE,
teamlevel4 VARCHAR2 (50),
teamlevel1 VARCHAR2 (50),
empname VARCHAR2 (50),
portfolio VARCHAR2 (50),
leou VARCHAR2 (50),
name VARCHAR2 (50),
level3 VARCHAR2 (50),
b6 VARCHAR2 (50),
b4 VARCHAR2 (50),
r7 VARCHAR2 (50),
r9 VARCHAR2 (50),
xnetcva NUMBER (22, 2),
acreditcharge NUMBER (22, 2)
)
organization external (
  type oracle_loader
  default directory ET
  access parameters (
    records delimited by newline
    nobadfile
    nodiscardfile
    nologfile
   )
   location('IRD.TXT')
)
Re: External Tables [message #363144 is a reply to message #363143] Fri, 05 December 2008 03:56 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Syntax problem in the query.

In "select * from iii"? How could it be?

Quote:
But now the problem is it is not showing any data. - can u
check the query at your end with the feed file i had send to you.

Which file?

Regards
Michel
Re: External Tables [message #363148 is a reply to message #363144] Fri, 05 December 2008 04:18 Go to previous messageGo to next message
user71408
Messages: 585
Registered: November 2007
Location: NE
Senior Member

The file is having the follosing data
BULK 10642 BLACKROCK 31-Jan-08 NA INTEREST RATE MARKETS	FIG SVP BRO	MAGNOLIMARC	NONE	0099-002112	HOPAUL	IRD EXO/HYB	GLOBAL RATES EXOTICS & HYBRIDS  559985GYF STRUCTURED FINANCE	STRUCTURED FINANCE	PAUL HO	1058

statement is
Select * from aa; ( table name got changed);

Thank you
Re: External Tables [message #363151 is a reply to message #363148] Fri, 05 December 2008 04:23 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
First change "nobadfile nodiscardfile nologfile" to file names and then investigate the result in these files.

Regards
Michel

Re: External Tables [message #363154 is a reply to message #363151] Fri, 05 December 2008 04:27 Go to previous messageGo to next message
user71408
Messages: 585
Registered: November 2007
Location: NE
Senior Member

Michael,

It was not yet resolved...

[Updated on: Fri, 05 December 2008 04:32]

Report message to a moderator

Re: External Tables [message #363160 is a reply to message #363154] Fri, 05 December 2008 04:44 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And what is in the files?

Regards
Michel
Previous Topic: Count as array
Next Topic: Inserting the Comma Separated Strings into Table
Goto Forum:
  


Current Time: Sat Dec 10 09:07:00 CST 2016

Total time taken to generate the page: 0.08752 seconds