2

I have created using system i navigator a jounral called abc in schema called TEST.Now i want to journal all the tables in my schema called mySchema how can i do that.I can only journal only one table.Is there any script to journal all the tables at once.

thanks in advance

BenMansourNizar
  • 1,558
  • 4
  • 21
  • 42

2 Answers2

2

Find your journal then right click on it.

Right click menu

Choose start or end table journaling. You'll get this screen:

Start/End Table Journaling

Find and add your tables. I believe you can Ctrl or Shift- click multiple tables at once.

Mike Wills
  • 20,959
  • 28
  • 93
  • 149
  • 1
    unfortunately you can't make multiple selection.Which version do you use Mike? i have tried ctrl and shift click but in vain – BenMansourNizar Nov 01 '11 at 13:44
  • Sorry, I am having other problems trying it out. It was quite a while ago when I tried it so my memory could be incorrect. I thought for sure that the standard shift-click and ctrl-click functionality worked though. – Mike Wills Nov 01 '11 at 14:55
  • I am clueless on Journaling. <-- so cluless I can't even spell it right according to browser auto correct. But I need it for transactions to an as400 database. To Journal a table, do you have to define a Journal? Or do you just have to define the table as Journal.. thanks! – eaglei22 Dec 08 '16 at 22:25
  • You need to select tables one by one. There is not shift-click or ctrl-click. Any solution for this?? – Arashsoft Jan 30 '20 at 14:36
0

If you created a "schema" with iSeries Navigator, then a journal will be created in the schema automatically and all tables created in that schema will be journaled automatically. Automatic journaling can also be set up for simple "libraries", in case you created a "library" rather than a "schema". See Automatically starting journaling for details. (For i 6.1 and later, also look at the STRJRNLIB command.)

user2338816
  • 2,163
  • 11
  • 11