DSXchange

Ray is not a speaker this year but will be around for the whole conference.

Vincent is also attending, I don't know if he's speaking.

No. You can use the Administrator client, but you can't script commands to be run through that interface.

There should be no problems with views. Have you granted SELECT privilege to the view for the IA user?

Generate a column containing the length and aggregate preserving MAX.

1. Convert to String.
2. Decompose into components (date, time). Use Field() function.
3. Convert date format. Oconv(Iconv()) with appropriate format strings.
4. Append space and time component (including fractional seconds).

Use Len() functions to compare lengths.

This one is on Windows. Which SMTP client are you using?

Can you please determine whether your project (account) has enties called LOGIN, ON.EXIT or ON.ABORT in the VOC file?

Welcome aboard. Their reason may be purely political or it may be a bad experience they once had where two huge jobs swamped the server or locked rows, pages or tables in the database. You need to discover the reason. DataStage has no limits on the number of jobs running simultaneously except that a...

One of the few good aspects to working in Defence is that enforcement of standards is not a problem. At least once the standards have been established and everyone has agreed that they're the right ones to use! But that's done up front, so it's all good.

Assuming a default installation, C:\IBM\InformationServer\Server\DSEngine\bin\dssh.exe

I don't believe that there is a report template for least frequent formats.

However these can easily be seen in the Column Analysis workspace by clicking on (sorting) the Count column header. Click again to sort in the other order (ascending vs descending).

Perhaps using some of the IKEA product names?

Actually probably not in this particular forum, which is devoted to WebSphere Transformation Extender (which used to be called DataStage TX, but which is no longer a part of DataStage).

Look in the job log. Are they being skipped, or are they experiencing import failures and being rejected/dropped?