Do while with variable

[kris_vliegen]

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

[marcus_sommer]

You could use peek('BoekLib', $(vFileNo), 'Lib') to run and read your Lib-Table.

- Marcus

[alexandros17]

After your FOR iinstruction write:

LET TMP = Peek('BoekLib',$(vFileNo)-1,'Lib'');

then replace your yellow BoekLib with $(TMP)

Let me know ...

[kris_vliegen]

Thanks for te response.

I've made this script but I get an error (see below)

Error:

[marcus_sommer · Accepted solution]

$(TMP) is a string and need to write with quotes: '$(TMP)'.

- Marcus

[alexandros17]

LET vFileName = 'S0678ADT.X62FIL$(TMP)=.PBP'

[kris_vliegen]

Thanks!

But I was expecting he was only giving the yellow records...

[marcus_sommer]

It seems that in your Lib-Table are more/other values as you expect - perhaps you need to extend your where-clause.

- Marcus

[kris_vliegen]

It's working fine. I was linking some data in the table that wasn't matching.

[kris_vliegen]

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