Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Experts
I ahave a table with two coloumns
Val and Pub
if my values are
Val pub
1212121 1212121
I need to load the data from Data_7.txt
if in case my values
Val pub
1212121
I need to load the data from Data_0.txt
Usulally the Data_$(len).txt have to cotain the lenghth of the field PUB
My table will have always only one entry
Please suggest a way to achieve this
Something like this:
LOAD pub FROM ValPubSourceTable;
LET vLen = len(trim(peek('pub')));
LOAD * FROM Data_$(vLen).txt (txt, ....);
Something like this:
LOAD pub FROM ValPubSourceTable;
LET vLen = len(trim(peek('pub')));
LOAD * FROM Data_$(vLen).txt (txt, ....);