DSXchange

Hard to tell without knowing your data. Keep edging it up till the problem goes away. You may need to increase precision also, if scale gets too close to it.

The error message has nothing to do with null - it has to do with your metadata, in which you have specified VarChar(0). This is not permissible.

"not working" and "giving some issue" are too imprecise for diagnosis, particularly remote diagnosis.

Help us to help you. Provide concise, yet precise, descriptions of the symptoms you are observing, including the exact text of any error messages being thrown.

Your first value has 12 digits following the decimal placeholder, but your Decimal data type's scale only allows for 10. DataStage is alerting you to the fact that the least significant digits have probably been lost.

Please mark this thread as Resolved

Stopped usually only means through operator intervention - a stop request was issued. This might have been through a Terminator in a sequence. In that case, there will be an entry in the sequence log indicating that stop requests were issued. Further, the individual job logs should have an entry ind...

You import five table definitions.

You can construct a join query if you like.

Well, yes there are. There is a line-based text editor (ED) that can be used from within the Administrator client command window. There is also the Alternative Editor (AE, the original Unidata line editor) but that requires some setup. On UNIX platforms there is an interlude to vi called UV.VI (but ...

I too prefer UltraEdit. You can access files on the server (transfer to and from the client).

It's probably an ODBC limitation. Search DSXchange for MAXFETCHCOLS

These applications that you're already running won't be nearly as resource-hungry as IBM InfoSphere Information Server (complete with WebSphere Application Server).

No idea, because it's not my file.

ROFLMAO!!! 30 users on Windows XP ?!! What is the capacity of this alleged "server"? As far as I can recall the maximum amount of memory that Windows XP can access is 3GB. That's barely enough for two users! Get serious. If you're going to use Windows for this many users, you need Windows ...

It's picked up the name of your SMTP server (a property of the Notification activity or DSSendMail function argument) but is unable to find an SMTP server of that name. Which SMTP server do you have installed and where is it installed? Is this findable using your command search list (PATH environmen...

Was the job open in Director at the time? Or in someone else's Designer or Director? Do you bother to check these things before deleting?