DSXchange

if you go to a DOS (command shell) window can you 'telnet {hostname}'? If you cannot -> Have you rebooted since the install and which DS processes are running (if any)? If you can successfully login (give your userid, password and use the account 'UV' and exit using the command 'QUIT') then post tha...

Do you get the same message if you use the IP address instead of host name? Is this as part of the installation or after the install completed?

Loobian,

you can control whether the hashed file used in a lookup is loaded to memory or not, and can also control the locking for updates.

Hello Loobian, hashed file keys are unique; so every time you do a write to the hashed file with the same key the system does an update of all columns and overwrites the old data. This is the way that the system works and it cannot be changed, so in your case you would have to add another column wit...

One of the options in the hashed file stage lets you not only create the file but also specify what type to create - dynamic or one of the static types. In the Hashed file stage you also can specify a path to the hashed file location or the option of putting it in the project directory. The differen...

vUser and DSJobName are not DataStage environment variables.

Can Ascential/IBM actually legally prevent screenshots from being used? I had no idea that they could be "coprighted" as such; just that there are restrictions on the use (i.e. using them to pretend to be the author or having the same icons and screen in a competing product). There go all my plans o...

Funny thread - I've been toying with the idea of getting a "DataStage for Dummies" book out. The publisher wants a guaranteed minimum sales figure far in excess of the number of DS users out there though, so it would remain a niche player. The problem is really not putting together a good book (whic...

Mimi, the Progress documentation will tell you. I looked at what was on the WWW and it only shows their ODBC driver to access external sources, not the opposite direction. There is no "progress file stage" that can write directly to this system, so it will have to be some type of pull mechanism from...

I wrote a 1-liner with your code, replacing "Input Link" with my routine variable and it worked as expected. If you cut-and-pasted your original line then you have a problem with the embedded blank between Input and Link.

I didn't know that DB/2 also used a 'heap' - normally when I see that word I know it's happening on the DS side of things. If this does pan out to be a database error I'll have learned something new & important

Hello Asoka, this is a common type of transformation; but before anyone can suggest an answer you must tell us what the target database is going to be. You can also look up the documentation for the ICONV and OCONV functions and the "D" conversion code and also use the search facility shown above to...

When a job fails it always prints out some sort of an error message. What is it in your case?

I think in this case you are running out of disk space in DS. If you change your load method to upsert it will be a lot slower but I am fairly certain it will run to completion. If it does run correctly, then you need to look on the DS server and find some more space. Also, is your filesize limited ...

The problem is (almost) the same on busy PX sites - the last one I was at had similar wait times for compilation of jobs with transform stages. I think the approach DS takes is the same in both implementations, so hopefully by making the compile quicker on native unix it will also speed up the virtu...