Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hieee
appp:
LOAD * INLINE [
eid, cid, name1, salay1
1, 555, aa, 64754
2, 666, ss, 4553
3, 856, uu, 45
4, 559, tt, 56
5, 425, oo, 878
6, 578, jj, 369
];
this is my script and i want to load any two fields from above inline table using resident load. Can i do this
help me
Tab:
LOAD * INLINE [
eid, cid, name1, salay1
1, 555, aa, 64754
2, 666, ss, 4553
3, 856, uu, 45
4, 559, tt, 56
5, 425, oo, 878
6, 578, jj, 369
];
Noconcatenate
Tab1:
Load eid,cid Resident Tab;
appp:
LOAD * INLINE [
eid, cid, name1, salay1
1, 555, aa, 64754
2, 666, ss, 4553
3, 856, uu, 45
4, 559, tt, 56
5, 425, oo, 878
6, 578, jj, 369
];
Load eid,cid resident appp;
Hi Akash,
Instead of using * in LOAD statement you can specify columns
appp:
LOAD *
INLINE [
eid, cid, name1, salay1
1, 555, aa, 64754
2, 666, ss, 4553
3, 856, uu, 45
4, 559, tt, 56
5, 425, oo, 878
6, 578, jj, 369
];
Test:
LOAD
eid, cid
Resident appp;
Or you can once again reload from inline like this
appp:
LOAD eid,
cid
INLINE [
eid, cid, name1, salay1
1, 555, aa, 64754
2, 666, ss, 4553
3, 856, uu, 45
4, 559, tt, 56
5, 425, oo, 878
6, 578, jj, 369
];
Hope this helps you.
Regards,
Jagan.
inline_tab:
LOAD * INLINE [
eid, cid, name1, salay1
1, 555, aa, 64754
2, 666, ss, 4553
3, 856, uu, 45
4, 559, tt, 56
5, 425, oo, 878
6, 578, jj, 369
];
res_tab:
LOAD eid as eid1,cid as cid1
RESIDENT inline_tab;