DSXchange

Ray - I bet you do British crossword puzzles, too... Roy - at present I tend to put questions by posters who use more abbreviations than real words at the back of my list and usually don't respond. Of course others more knowledgeable than I do end up answering, but I don't like people treating any l...

You should have no problem installing a 7.5 server on the same machine as your current 4.2 version. The new version will need a different memory segment addres as you have already noted, plus the clients will have to connect using a port number after the node name/IP address. Fortunately the documen...

The key is stored separately from the data. A hashed file only has one unique key string. Multiple or compound keys as used in DS jobs are actually stored as one string with a specific separator.

DataStage hashed file don't have datatype based limitations. Everything in the record is stored as one long noncontinguous string. The data types and lengths you specify in the metadata are mainly for use in other stages. So there is no reason to modify your Hashed file metadata to reflect accurate ...

vigneshra,

is your DB/2 server on the same machine as the DataStage server? If not, you will need to make sure that the file is readable by all users on both machines.

Sreeni, it is very easy for you to reproduce both scenarios, please do so to remove your doubts. That way we aren't dealing with theories or suppositions but cold, hard facts. I look forward to hearing your results. p.s. This reminds me of my high-school chemistry teacher. I was doing lab work and t...

Please do a reset-job and then see if there is a log entry for "from previous run".

What stages does this job use? Could it be an add-on plugin or package that you had installed on your Windows site and don't in your your installation? Try to do a view-data on the sources and targets.

DataStageCnu, "truncate" and "drop table with recreate" are high-speed methods of getting rid of the entire table contents as quickly as possible. This is very different from what you want to do! Each database has different methods of speedily removing rows, and the method used also depends on the e...

No, there isn't. Any scripts executed directly from DataStage would be run on the DS server, not on the DB server. There are various ways to execute remote shell scripts from UNIX (rsh for example), but nothing in DataStage to do so.

The error message you are getting should contain a bit more information than what you posted, could you perhaps add some more detail to the error so that we can see the actual library causing the error and what type of error was encountered?

Poorna, this is a case that looks like a bug. Have you tried re-installing the client software and is the problem the same on all your client PCs? If the answers to both questions are yes then you will need to seak with your support provider and get a fix. There are some known issues with patches fo...

Naren, you can do this at a field level. Go to the column and field name, right mouse click and "edit row", then you will have a section for null handling and a couple of options to let you do exactly what you specify. I don't have a PX installation here or access to the documentation, but once you'...

It seems that PX has a bug with string and timestamp with millisecond portion conversions. Please take a look at this thread

This looks like an APT_CONFIG file error. Has this installation worked before? Have you made changes to your configuration file? Could you post your config file to this thread?

DataStageCnu, you request that this forum doesn't ignore your question is even worse than asking for urgent help. No posts to this forum are ever ignored - if you don't get an answer it means that nobody has an answer to give you! In this case the answer isn't found in DataStage, but in PL/SQL. The ...