StacyStacy
Programmer
Hi.
I need help. I am joining 2 tables together by whereby I need at lease 75 fields just from one table. After writing the code, I received an error msg, "Required clause not present in command". So as a result, I am re-writing the code, line by line, sometimes, code by code and testing it. I have been successful up until the end when I now receive the following error message: "Compiled code for this line too long"? Why is this happening and what should I do? Here's a sample:
select jt1.ssn, jt1.wia_area, jt1.entertdte1,jt1.lastname, jt1.firstname, jt1.initial, jt1.appdate, jt1.address, jt1.city, jt1.county, jt1.state,;
jt1.zipcode, jt1.areacode, jt1.phone, jt1.age, jt1.birthday, jt1.sex, jt1.citizenshp, jt1.selectserv, jt1.education, jt1.highgrade, jt1.ethnic,;
jt1.indalaskan, jt1.asian, jt1.black, jt1.pacisle, jt1.white, jt1.hispanic, jt1.offender, jt1.limitedeng, jt1.homeless, jt1.runaway, jt1.teenparent,;
jt1.veteran, jt1.vietnamvet, jt1.disablevet, jt1.recsepvet, jt1.laborstat, jt1.grossfminc, jt1.numinfamly, jt1.hourlywage, jt1.wageatdisl, jt1.dislocdate,;
jt1.familystat, jt1.basiceduc, jt1.metroresid, jt1.ssi, jt1.afdc, jt1.refugeasst, jt1.fosterchld, jt1.foodstamp, jt1.inddisable, jt1.econdisadv,;
jt1.jobspartic, jt1.displahome, jt1.rcvdnrpay, jt1.titletype, jt1.needsbased, jt1.certifdate, jt1.ythaddasst, jt1.pellgrant, jt1.adult, jt1.dislworker,;
jt1.oldyouth, jt1.yngyouth, jt1.fromrresp, jt1.fromjtpa, jt1.inadult, jt1.locdworker, jt1.locyouth, jt1.stateyouth, jt1.statedhome, jt1.incumwork,;
jt1.otherswide, jt1.rapidresp, jt1.addrapresp, jt1.natemgrant, jt1.natgrannum, jt1.adulteduc, jt1.jobcorps, jt1.farmworker, jt1.natamerprg,;
jt1.vetprogram, jt1.tradeadj, jt1.naftataa, jt1.voceduc, jt1.vocrehab, jt1.wagpeyser, jt1.welf2work, jt1.csbgprog, jt1.hudprg, jt1.ucclaimant,;
jt1.othnonwia, jt1.titlevact, jt1.itaestabl, jt1.firstcore, jt1.firstinten, jt1.firsttrain, jt1.treadsklev, jt1.tmathsklev, jt1.termreason, jt1.recsuppsrv,;
jt1.recnrpstip, jt1.complwia, jt1.recfupserv,jt1.termdate,jt1.tkeyedby, jt1.tdatekeyed;
from jt1,jt2;
where (jt1.ssn=jt2.ssn and jt1.wia_area=jt2.wia_area and jt1.entertdte1=jt2.entertdte1);
into table partdata
Thanks,
I need help. I am joining 2 tables together by whereby I need at lease 75 fields just from one table. After writing the code, I received an error msg, "Required clause not present in command". So as a result, I am re-writing the code, line by line, sometimes, code by code and testing it. I have been successful up until the end when I now receive the following error message: "Compiled code for this line too long"? Why is this happening and what should I do? Here's a sample:
select jt1.ssn, jt1.wia_area, jt1.entertdte1,jt1.lastname, jt1.firstname, jt1.initial, jt1.appdate, jt1.address, jt1.city, jt1.county, jt1.state,;
jt1.zipcode, jt1.areacode, jt1.phone, jt1.age, jt1.birthday, jt1.sex, jt1.citizenshp, jt1.selectserv, jt1.education, jt1.highgrade, jt1.ethnic,;
jt1.indalaskan, jt1.asian, jt1.black, jt1.pacisle, jt1.white, jt1.hispanic, jt1.offender, jt1.limitedeng, jt1.homeless, jt1.runaway, jt1.teenparent,;
jt1.veteran, jt1.vietnamvet, jt1.disablevet, jt1.recsepvet, jt1.laborstat, jt1.grossfminc, jt1.numinfamly, jt1.hourlywage, jt1.wageatdisl, jt1.dislocdate,;
jt1.familystat, jt1.basiceduc, jt1.metroresid, jt1.ssi, jt1.afdc, jt1.refugeasst, jt1.fosterchld, jt1.foodstamp, jt1.inddisable, jt1.econdisadv,;
jt1.jobspartic, jt1.displahome, jt1.rcvdnrpay, jt1.titletype, jt1.needsbased, jt1.certifdate, jt1.ythaddasst, jt1.pellgrant, jt1.adult, jt1.dislworker,;
jt1.oldyouth, jt1.yngyouth, jt1.fromrresp, jt1.fromjtpa, jt1.inadult, jt1.locdworker, jt1.locyouth, jt1.stateyouth, jt1.statedhome, jt1.incumwork,;
jt1.otherswide, jt1.rapidresp, jt1.addrapresp, jt1.natemgrant, jt1.natgrannum, jt1.adulteduc, jt1.jobcorps, jt1.farmworker, jt1.natamerprg,;
jt1.vetprogram, jt1.tradeadj, jt1.naftataa, jt1.voceduc, jt1.vocrehab, jt1.wagpeyser, jt1.welf2work, jt1.csbgprog, jt1.hudprg, jt1.ucclaimant,;
jt1.othnonwia, jt1.titlevact, jt1.itaestabl, jt1.firstcore, jt1.firstinten, jt1.firsttrain, jt1.treadsklev, jt1.tmathsklev, jt1.termreason, jt1.recsuppsrv,;
jt1.recnrpstip, jt1.complwia, jt1.recfupserv,jt1.termdate,jt1.tkeyedby, jt1.tdatekeyed;
from jt1,jt2;
where (jt1.ssn=jt2.ssn and jt1.wia_area=jt2.wia_area and jt1.entertdte1=jt2.entertdte1);
into table partdata
Thanks,