DSXchange

MS 1252 is the standard Latin-1 code page and will be present on your windows machine. The error message might result from mis-spelling of the name. From the problem description it sounds like you have a PX job and are doing a "view data" on a source stage. If that is the case, let us keep...

DataStage still utilizes a version of the UniVerse engine, it was split off from the current software (also owned by IBM) years ago. While it is now a little bit different with some functionality removed and other added, it is still essentially identical to UniVerse. While IBM does not document the ...

While I haven't seen this message, it is a Java error relating to file activity so in all likelihood you have a permission problem in the directory where you are creating this new project.

Devesh, many of the people here have spent years learning DataStage and coming to understand the world of Data Warehousing. For this reason those who know the most are very reluctant to offer interview questions and answers, since we feel that is cheating and ultimately a disservice to the employer ...

As already suggested, output "Trim(Out.DecimalColumnName)" and declare it as a VarChar() string.

I cannot check right now, but can you not set the NLS attributes for the whole BASIC transform stage in the stage properties tab? Also, the character will be translated going into the stage but also when going out, so the net effect will be transparent to you; i.e. the character might get translated...

You can put a job level or project level handler to demote this warning message and suppress it from the log; but as you can see from the reactions of the other posters, this is not a good idea and the best (and correct) solution is to avoid this truncation problem by either making the fields approp...

The "permission denied" gives the clue; your DataStage userid doesn't have sufficient rights to the hashed file directory and contents.


[edit] Craig was just a minute faster on the trigger than I was, sorry for the duplicate response[/edit]

I'm not at a DS client now, but in the monitor there is either a click-box or if you right-mouse-click you will get an option where you can have the monitor display each instance separately.

Yes, you can do this via DataStage. Could you explain what you tried, and how that didn't work and then you might be able to get a detailed explanation.

What tool are you using to see this extra character? In the sequential file output stage, what have you set in the format for line, field and record terminators?

Lak4u - it is more helpful to choose a more appropriate subject than "error". Also, have you checked to see if this file is actually missing on the system? Are there other files in this directory (there should be)?

If you are reading the file with READSEQ after doing a successful OPENSEQ then those 2 extra characters are actually in the file. You can check this if you use an editor to look at this file, or a UNIX utility such as "od".

It looks like your development project was NLS enabled, but the one you are importing to is not.

If by "folder" you mean a category in DataStage then no, there is no way to track this. If you mean the actual UNIX folder then you might have a way, several file systems store a "date-time created" for files and directories, and the owner will be the userid who created it.