DSXchange

Start by looking into the Field() function but... clarify your rules / requirements for us.

Ray could retire and I'd still never catch up.

And as I've noted before, this is the only website on my 'visit regularly' list where the forums don't maintain your unread posts. Elsewhere if I haven't read something, when I come back they are still unread as well as are any new posts. Here, when you come back all you find unread are any new post...

You are correct, that function in the Modify stage only supports 'begin' and 'end' as portions of the string that can be trimmed. I'm not aware of anything in the Modify stage that does what you want. Why the aversion to the Transformer function, one you know does exactly what you need? If it is any...

As noted in your other post perhaps in the Operations Console but failing that... no, not that I'm aware of.

If you enabled the 'Trigger Column' option, turn that off.

Your script is the automation. It can get a list of all projects, then jobs in the project and then check each one to see when last it ran. Gather whatever stats you need for any that qualify.

First off, nothing is happening 'simultaneously'. They happen one after the other in a serial fashion based on link order. If the order matters (for example because of RI) then ensure that you have that correctly specified. As to what might be hanging, I'd start by having a DBA monitor the session f...

Open up your Parallel Job Developer's Guide and search for "year_cutoff", it is part of the format mask and will get rid of all those if-then-else shenanigans.

Work with whomever gave you the xsd, it sounds like it may actually be invalid.

dsjob -jobinfo

Download this IBM Redbook. Chapter 2.14 is dedicated to the SCD stage.

Start with the official documentation if you haven't already.

If "referenced" means "read" then no. Start by posting the failure message(s) if you'd like some help tracking it down.

Andy has a comprehensive post on 'istool' here, it should help.