Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
This is my script:
PODetail:
LOAD
company & '-' & vendornum as vendorlink,
baseqty as podetailbaseqty,
baseuom as podetailbaseuom,
company & '-' & ponum & '-' & poline as porellink,
company & '-' & partnum as podetailcompany,
ium as poium,
poline as popoline,
ponum as poponum,
pum as popum,
unitcost as POunitcost ;
SQL SELECT baseqty,
baseuom,
btoordernum,
company,
ium,
partnum,
poline,
ponum,
pum,
unitcost,
vendornum
FROM epicor904.dbo.podetail
WHERE btoordernum=0;
PORel:
Inner Keep (PODetail)
LOAD
baseqty as porelbaseqty,
baseuom as porelbaseqty,
company & '-' & ponum & '-' & poline as porellink,
date(duedate) as PODue,
porelnum as poporelnum,
receivedqty as POreceivedqty,
relqty,
smircvdqty,
xrelqty;
SQL SELECT
baseqty,
baseuom,
company,
duedate,
openrelease,
poline,
ponum,
porelnum,
receivedqty,
relqty,
smircvdqty,
xrelqty
FROM epicor904.dbo.porel Where openrelease=1;
This is the error:
OLEDB read failed
SQL SELECT
baseqty,
baseuom,
company,
duedate,
openrelease,
poline,
ponum,
porelnum,
receivedqty,
relqty,
smircvdqty,
xrelqty
FROM epicor904.dbo.porel Where openrelease=1
My eyes do not see any issue with my script, but it is probably something simple that I am just missing.
Found the issue.
PORel:
Inner Keep (PODetail)
LOAD
baseqty as porelbaseqty,
baseuom as porelbaseqty,
company & '-' & ponum & '-' & poline as porellink,
date(duedate) as PODue,
porelnum as poporelnum,
receivedqty as POreceivedqty,
relqty,
smircvdqty,
xrelqty;
SQL SELECT
baseqty,
baseuom,
company,
duedate,
openrelease,
poline,
ponum,
porelnum,
receivedqty,
relqty,
smircvdqty,
xrelqty
FROM epicor904.dbo.porel Where openrelease=1;
Found the issue.
PORel:
Inner Keep (PODetail)
LOAD
baseqty as porelbaseqty,
baseuom as porelbaseqty,
company & '-' & ponum & '-' & poline as porellink,
date(duedate) as PODue,
porelnum as poporelnum,
receivedqty as POreceivedqty,
relqty,
smircvdqty,
xrelqty;
SQL SELECT
baseqty,
baseuom,
company,
duedate,
openrelease,
poline,
ponum,
porelnum,
receivedqty,
relqty,
smircvdqty,
xrelqty
FROM epicor904.dbo.porel Where openrelease=1;