DSXchange

Welcome aboard. :D When the file system on which the project is installed becomes full, or on which a hashed file exists becomes full, it is highly likely that some kind of corruption has occurred as an update has been taking place. This is not that easy to diagnose - search the forum for uvbackup f...

Try putting the Trim(TPRTNLOC_01.STREET_NUMBER,"0","L") into a stage variable, and replacing that part of the expression with a reference to the stage variable.

WHY can't they be deleted? What's the permission on them? What's the permission on the parent directory? Are they still in use (use fuser to find out)? What error message is generated if you try to delete one of them?

Hi I am reading a seq file, applying business rules, inserting the correct records into the sybase correct data table, creating an exception data seq file(by using the rejects option in the transformer) and also inserting the source row, load dtm and exception error message into the sybase log tabl...

There is no scope to use environment variables in the parallel configuration file. This is the file whose pathname is specified by the APT_CONFIG_FILE environment variable.

Lest there be any confusion, dsjob does exist on Windows servers. However the dsenv script does not exist on Windows servers.

Inplace upgrade is possible. Have backups.

Read the chapter on Custom stages in the DataStage Advanced Parallel Developer's Guide - it will give you full information about how to construct these and some examples of when you might want to use one.

sanjay wrote:Hi Ray

what is Federation Server . is it to access multiple database at a time.


Thanks
Sanjay

Searching on the IBM web site will give you full facts, and save me from having to type them in. It's not part of DataStage - it's another service supported on IBM Information Server.

There is no guarantee that your step using Notepad will successfully translate all characters. What character map is used for encoding the original Korean characters?

Even (especially) sparse lookups only do equi-joins.

There is/will be a White Paper called "IBM Information Server: What's New in IBM Websphere DataStage 8.0". Thus far it does not appear in the IBM Library though there are some papers there dated as recently as October 15, 2006 describing other aspects if IBM Information Server. I have (in hard copy ...

Don't think any Windows patch will help - the OP is on UNIX. This message sometimes occurs when you don't have a compatible, or compatible version of, the C++ compiler. Check the values of the four environment variables that govern what compile and link options exist. In particular, you can specify ...

A search on IBM Developer Works would be no bad thing.

Etiquette Note Please don't "shout" (use all upper case), as it is offensive. I do not have the benefit of being able to see what you're doing, so am perforce obliged to ask questions in what I believe to be a systematic diagnostic process. Your failure to answer reasonable questions does not help....