DSXchange

One of my colleagues is preparing a paper for Insight 2015 on extracting information from emails into DataStage. Not sure if it addresses attachments, and it's in a very early phase.

You cannot change the fact that NLS is installed.

However, the NLSMODE parameter in the uvconfig file determines whether NLS is enabled or not.

The usual caveats apply, such as the need to reconfigure shared memory during a restart of the engine having changed the uvconfig file.

You do have a scheduler. It's called the Information Server scheduling service.

What are the permissions to the RT_BP3 directory? When you use the SET.FILE.MAP command, it has to write a hidden file called .nlsmap into the directory. If you don't have write permission to the directory, then the command will fail.

Best is to get the provider of the file to give you a correct file.

The substring operator is generous in that you can specify an ending position beyond the end of the token and it will return only up to the end of the token. In your case, something like the following should work, assuming a numeric token. ; Numeric token beginning 001 or 011 - remove IDD code from ...

There is, and how that is done depends on whether or not you have NLS enabled. If you have NLS enabled, then the ordinal day number settings are specified in your locale. Without NLS there is, if I recall correctly, an undocumented setting in the uvconfig file. Or you could simply subtract 1 from th...

Convert your date string into an internal format date using StringToDate() function, then to the number of days from a given day zero - from which you can perform "day arithmetic".

Try changing it to 0x20, at least for this job. That changes it from a NUL to a space character, which will be handled by your Trim() functions.

What is the value of APT_STRING_PADCHAR environment variable in your project?

To answer your first question, "no".

Why have Extract Date if it's not permitted to be used? Resist stupid requirements!

If every load is uniquely identified (perhaps with a run ID, perhaps with a created timestamp) you can use these identifiers to roll back to a known good point in the event that you need to re-load.

Perhaps the char2 columns are padded to length? Because they are different lengths, that could result in mismatches occurring.

Server jobs don't have a timestamp data type. Try reading it as a Char or VarChar data type. You may need a CAST in your SQL, but try it without that first.

Set the Table Action property value to Append.
Note that this may use function calls via the OCI to specify to append to an existing table, rather than using hints in the generated SQL.