All Forums Tools
spring78 2 posts Joined 08/09
17 Aug 2009
Mload issue

I have the following mload script where I need to assign a default value for JOB_TTL_NM in .dml. Can any body tell me how this can be done. I tried putting the default value in different formats like 'Non-Associate' , "Non-Associate":JOB_TTL_NM = 'Non-Associate'. But, getting error....logtable UD131.ABC_LT;.logon ABC/XXX,XYZ;.begin mload tables UD131.ABCworktables UD131.ABC_WTerrortables UD131.ABC_ET UD131.ABC_UVsessions 10sleep 10tenacity 4errlimit 1;.layout mylayout;.field ENT_USER_ID * VARCHAR(6);.field EMPL_LST_NM * VARCHAR(80); .field EMPL_FRST_NM * VARCHAR(80);.field EMAIL_ADR * VARCHAR(180);.field LEVEL_DESC * VARCHAR(80);.field JOB_TTL_NM * VARCHAR(50);.field MGR_LST_NM * VARCHAR(80); .field MGR_FRST_NM * VARCHAR(80); ; .dml label mydml;insert into UD131.ABC(ENT_USER_ID , EMPL_LST_NM, EMPL_FRST_NM,EMAIL_ADR, LEVEL_DESC, JOB_TTL_NM, MGR_LST_NM, MGR_FRST_NM, )values(:ENT_USER_ID , :EMPL_LST_NM, :EMPL_FRST_NM, :EMAIL_ADR, :LEVEL_DESC, :JOB_TTL_NM = 'Non-Associate', :MGR_LST_NM, :MGR_FRST_NM, );.import infile myfile.csvformat vartext ',' layout mylayout apply mydml;.end mload;.LOGOFF;

Bhanu 5 posts Joined 04/09
17 Aug 2009

values(:ENT_USER_ID , :EMPL_LST_NM, :EMPL_FRST_NM, :EMAIL_ADR, :LEVEL_DESC, 'Non-Associate', :MGR_LST_NM, :MGR_FRST_NM, );

Raja_KT 1246 posts Joined 07/09
18 Aug 2009

Hi,Did it work that solution? What I feel is that you can define at table level itself.Thanks and regards,Raja

Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.

spring78 2 posts Joined 08/09
18 Aug 2009

Yes, I figured that there was a issue with the layout I defined. I changed it and is working fine now.Anyways, thanks to every one!

You must sign in to leave a comment.