DSXchange

Welcome aboard. You have posted in the incorrect forum. The moderator will be along shortly to place your query correctly, then you have to give us more information about the version and platform that you are using.

By detecting the exit status of the sqlplus command in your script and making sure that your script doesn't exit with status 0 if the sqlplus command doesn't.

Disabling indexes that support the join can only make your SELECT statement run FAR slower...

Yes. Exactly as you say.

There's nothing special about the script - implement it as you would for any other application. Standard FTP techniques/commands are all you need (and maybe a way to handle the password "nicely").

We have a fairly new installation of BG, using a hybrid. Yes, workflow is in use, but they've decided to publish some Candidate terms so that they don't get lots of emails suggesting the same thing. There are over 30,000 users in the organisation.

Even so youd've thought it would have nailed ON for the province Ontario. Ah well.

will yield 2012-08-08 format from 20120808.

"D-DMBY"

The Sequential File stage can readily handle multiple input files, provided that they have the same record structure. The Sequential File stage can use a Filter command. In this case the filter command should be TYPE file1 file2 (or COPY file1 file2 ). (If you were on UNIX, the command would be cat ...

SO, not substrings but "delimited substrings".

An equivalent to the Field() function would be square brackets notation.

Make sure that the script returns a non-zero exit code if it "fails".

The Administrator GUI only allows you to create new environment variables in the User Defined folder. It does however let you see environment variables created by editing DSParams file.

Craig's syntax is correct. I usually do that in a user variable, which means that I have a delimited list to pass to the StartLoop activity. Note that the final line terminator will mean that you have an empty line at the end. You may like to adjust for this either in the command itself (for example...

They shouldn't impact DS performance too much until the lock table fills.
But we will need to see some examples, as Arnd requested, before we can comment cogently.