Error 26184 using external table
Hi Gurus,
I'm running a external table select, unload of tables, some are success but
one is not. I got the below error message:
------WITH the %r it fails ------
SELECT *
FROM table
INTO EXTERNAL table_target
USING ( DATAFILES
(
"DISK:/DIR/DATA/table/table.%r(1..).u"
),
DELIMITER ""
);
26184: Could not parse r macro in filename /DIR/DATA/table/table.%r(1..).u.
111: ISAM error: no record found.
Error in line 9Near character position 9
---------WITHOUT the %r it works---------------
SELECT *
FROM table
INTO EXTERNAL table_target
USING ( DATAFILES
(
"DISK:/DIR/DATA/table/table.u"
),
DELIMITER ""
);
Any idea why it fails? there's just 268K records on the table.
That %r(1..) is missing its upper limit, e.g. %r(1..5).
S.=20
https://www.ibm.com/support/knowledgecenter/en/SSGU8G=5F11.70.0/com.ibm.sql=
s.doc/ids=5Fsqs=5F2065.htm?view=3Dkc=20
for precise syntax.
HTH,
Andreas
From: "RONALD OLAVIDEZ" <ronald.olavidez@gmail.com>
To: ids@iiug.org
Date: 05.04.2017 04:19
Subject: Error 26184 using external table [38854]
Sent by: ids-bounces@iiug.org
Hi Gurus,=20
I'm running a external table select, unload of tables, some are success=20
but=20
one is not. I got the below error message:=20
------WITH the %r it fails ------=20
SELECT *=20
FROM table=20
INTO EXTERNAL table=5Ftarget=20
USING ( DATAFILES=20
(=20
"DISK:/DIR/DATA/table/table.%r(1..).u"=20
),=20
DELIMITER ""=20
);=20
26184: Could not parse r macro in filename=20
/DIR/DATA/table/table.%r(1..).u.=20
111: ISAM error: no record found.=20
Error in line 9=20Near character position 9=20
---------WITHOUT the %r it works---------------=20
SELECT *=20
FROM table=20
INTO EXTERNAL table=5Ftarget=20
USING ( DATAFILES=20
(=20
"DISK:/DIR/DATA/table/table.u"=20
),=20
DELIMITER ""=20
);=20
Any idea why it fails? there's just 268K records on the table.=20
***************************************************************************=
****=20
Forum Note: Use "Reply" to post a response in the discussion forum.=20
Your %r range needs and end point:
SELECT *
FROM table
INTO EXTERNAL table_target
USING ( DATAFILES
("DISK:/DIR/DATA/table/table.%r(1..7).u"
),
DELIMITER ""
);
Art
Art S. Kagel, President and Principal Consultant
ASK Database Management
www.askdbmgt.com
Blog: http://informix-myview.blogspot.com/
Disclaimer: Please keep in mind that my own opinions are my own opinions
and do not reflect on the IIUG, nor any other organization with which I am
associated either explicitly, implicitly, or by inference. Neither do
those opinions reflect those of other individuals affiliated with any
entity with which I am affiliated nor those of the entities themselves.
On Tue, Apr 4, 2017 at 10:18 PM, RONALD OLAVIDEZ <ronald.olavidez@gmail.com>
wrote:
> Hi Gurus,
>
> I'm running a external table select, unload of tables, some are success but
> one is not. I got the below error message:
>
> ------WITH the %r it fails ------
>
> SELECT *>
> FROM table
>
> INTO EXTERNAL table_target
>
> USING ( DATAFILES
>
> (
>
> "DISK:/DIR/DATA/table/table.%r(1..).u"
>
> ),
>
> DELIMITER ""
>
> );
> 26184: Could not parse r macro in filename /DIR/DATA/table/table.%r(1..).
> u.>
> 111: ISAM error: no record found.
> Error in line 9> Near character position 9
>
> ---------WITHOUT the %r it works---------------
>
> SELECT *>
> FROM table
>
> INTO EXTERNAL table_target
>
> USING ( DATAFILES
>
> (
>
> "DISK:/DIR/DATA/table/table.u"
>
> ),
>
> DELIMITER ""
>
> );
>
> Any idea why it fails? there's just 268K records on the table.
>
>
> ************************************************************
> *******************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--001a114974d8cdce5f054c68c374