asked on

DB@ Journaling

This command:
STRJRNPF FILE(CMSDAL343/TBLBUDGETCOLUMNHIST) JRN(CMSFIL/QSQJRN)
keeps failing because TBLBUDGETCOLUMNHIST is more than 1o characters. How do I get journaling started for a long table name?

ASKER CERTIFIED SOLUTION

Member_2_2484401

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

rmk

ASKER

I actually worked around it by using the iSeries Navigator GUI to start journaling. But your suggestion now gives me a much needed way to script the journaling for my tables.

Member_2_276102

...a much needed way to script the journaling for my tables.

Is this for starting journaling on tables that have been around for a while? Or are you needing to start journaling for new tables as you create them?

You can set a schema (a 'library') to journal new tables automatically. You can also use tools such as PDM to start journaling for a lot of tables that already exist.

It's not clear what a "script" is needed for.

Tom

rmk

ASKER

Because the database is provided by a 3rd party, every time they do an update we lose any objects we created in their schemas. So we put all of our objects in other schemas. Since our objects sometimes have to change with the 3rd party's object names, it makes it a lot easier to simply edit and re-run scripts.

Member_2_276102

Scripts (I'd normally assume you mean "a CL program") are certainly valuable. But if this is a program, it shouldn't need to be edited. It might be easy enough to let it adapt automatically. CL can use a lot of system features to adapt to changing sets of objects.

Can you give a general example that has two or three objects in the 3rd-party schema and also your in-house schema? Maybe an alternative can be provided that would be helpful in the longer term. It might also be helpful to know what the OS version is.

Tom