Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello all,
I'm trying to load data from an Iseries.
And every bookyear is in another Company and also an other filepath(accesspath)
I have an excel with Year and CompanyNumber.
Boekjaar, BoekLib
2011 11E
2012 12E
2013 13E
2014 14E
I have only need to refresh the last 2 years (current year and CurrentYear -1)
Now I need to do a select like this
select *
FROM S0678ADT.X62FIL13EO.PBP;
and
Select *
FROM S0678ADT.X62FIL14EO.PBP;
Here is an example of my script where my BoekLib (in Yellow) is empty...
How can I fill up "BoekLib"?
Regards,
Kris
You could use peek('BoekLib', $(vFileNo), 'Lib') to run and read your Lib-Table.
- Marcus
After your FOR iinstruction write:
LET TMP = Peek('BoekLib',$(vFileNo)-1,'Lib'');
then replace your yellow BoekLib with $(TMP)
Let me know ...
Thanks for te response.
I've made this script but I get an error (see below)
Error:
$(TMP) is a string and need to write with quotes: '$(TMP)'.
- Marcus
LET vFileName = 'S0678ADT.X62FIL$(TMP)=.PBP'
Thanks!
But I was expecting he was only giving the yellow records...
It seems that in your Lib-Table are more/other values as you expect - perhaps you need to extend your where-clause.
- Marcus
It's working fine. I was linking some data in the table that wasn't matching.
Hi All,
Everything was working fine.
But if I try to use it for another file I get some strange things...
Fot the file PBD he is filling one table "PBD
If I do the same for the PBP file he is making 2 tables PBP and PBP-1
Why is he doing this
And this is the excel I'm using for both the scripts