OLEDB read failed SQL SELECT * FROM EMP

[#1]

Hi All,

When I use the below code, getting the error:

EMP:

LOAD*,text(EMPNO) as EMP_NBR_Char,text(MGR) as MGR_NBR_Char,

SQL SELECT * FROM EMP;

OLEDB read failed

SQL SELECT * FROM EMP

But when I rename the ailas names, working fine.

EMP:

LOAD*,text(EMPNO) as EMP_NBR_Char1,text(MGR) as MGR_NBR_Char1,

SQL SELECT * FROM EMP;

Why?

Any idea? Thanks in advance.

[arulsettu · Accepted solution]

HI

try like this

EMP:

LOAD*,text(EMPNO) as EMP_NBR_Char1,text(MGR) as MGR_NBR_Char1;

SQL SELECT * FROM EMP;

[SunilChauhan]

indication of end of load should be ; inplace of '.

see below code

EMP:

LOAD*,text(EMPNO) as EMP_NBR_Char,text(MGR) as MGR_NBR_Char;

SQL SELECT * FROM EMP;

if you have same field name twice the this erro will occur and when you rename then it will execute.

so make sure EMP_NBR_Char and MGR_NBR_Char not exist in  SQL SELECT * FROM EMP;

hope this helps

[#4]

arulsettu,Actually I tried that method only.