DSXchange

My preference is to use Data Connectors that have associated Parameter Sets. This means that the Parameter Set is stored in the same folder as its Data Connector. Then, within the Parameter Set, I like to use values files for different environments.

kkmreddy wrote:I changed the default format to %mm%dd%yyyy .. but still same ..

When you convert your input string, you must have "-" characters in the format string, as Arnd indicated. There is no indication that you have done this.

Each of these is the same number. Float numbers are stored in binary format - there is no need for redundant leading or trailing zeroes. When displayed, " " is used as the sign character for positive values.

The only way to re-generate the zeroes is to convert to a string.

Why does a communication error on your system constitute a bug?

Jobs run from the client pick up their engine credentials from a setting made by an Administrator in the Web Console for Information Server. It seems that your administrator has taken the easy approach of mapping all users to dsadm. This prevents capture of information about who actually submitted t...

Wherever you heard it, it's wrong.

Explain to the DBAs that the client is on UNIX and therefore does not have any way of generating a Windows authentication.

It's a server job, so there's no partitioning.

DataStage jobs can generate operational metadata (various ways to implement this, including an option in the Job Run Options dialog). This is able to be captured and accessed using Metadata Workbench. Once you get version 8.7 there's an even better way, called the Operations Console. I never recomme...

This is not actually a pivot.

Do it with stage variables and you won't have any issues with the number of rows.

Output the company name only when it changes.

Use the client-side command line dscmdexport.

Even better if you share the answers you discover!

I don't believe it is possible.

The New York State Identification and Intelligence System Phonetic Code, commonly known as NYSIIS, is a phonetic algorithm devised in 1970 as part of the New York State Identification and Intelligence System (now a part of the New York State Division of Criminal Justice Services). It features an acc...

Welcome aboard. Your question is more complex than you probably realise. The first issue is that there's no process, therefore no log, for the DataStage Engine. Each job has its own, individual, log which you can read using the Director client. Other parts of the Information Server suite, such as th...