Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
My problem is an error message is coming up saying Field not found - <PROJECT_ID>. I don't understand why it is not found. Any help would be grateful to resolve the problem.
OP_SUMMART:
Qualify *;
unqualify PROJECT_ID;
LOAD CONTRACT as PROJECT_ID ,
COMPANY_ID,
LABOUR_NO,
PART_NO,
REAL_FINISH,
DELAY_IN_DAYS,
PCT_NOT_APPVD,
QTY_HRS_PLANNED,
QTY_HRS_ACTUAL
FROM
(qvd)
WHERE (LABOUR_NO = 'ASSY RWORK') OR
(LABOUR_NO = 'ASSY ADDS') OR
(LABOUR_NO = 'TEST MODS')
AND
(PROJECT_ID = 'S07050720' OR PROJECT_ID = 'S07050721' );
Because at the load time of the statement there is no PROJECT_ID field. There is a CONTRACT field. After that you can use the PROJECT_ID field.
How do i write it in the syntax to overcome the error.
Are you kidding? Who is writing SQL for you?
All what you need is just replace PROJECT_ID in where clause by CONTRACT.
OP_SUMMART:
Qualify *;
unqualify PROJECT_ID;
LOAD CONTRACT as PROJECT_ID ,
COMPANY_ID,
LABOUR_NO,
PART_NO,
REAL_FINISH,
DELAY_IN_DAYS,
PCT_NOT_APPVD,
QTY_HRS_PLANNED,
QTY_HRS_ACTUAL
FROM
(qvd)
WHERE (LABOUR_NO = 'ASSY RWORK') OR
(LABOUR_NO = 'ASSY ADDS') OR
(LABOUR_NO = 'TEST MODS')
AND
(CONTRACT = 'S07050720' OR CONTRACT = 'S07050721' );