DSXchange

We were going to do this while at USAA and ultimately decided to stand up new hardware. The installation documentation actually discusses how to do this and I believe the installer also asks for an instance name so it was designed to do just what you want. I know of a few customers who have gone thi...

Hi , I set the value of APT_CONFIG_FILE variable to apt file for the project. I also sourced the dsenv file.I followed the same process while working in Datastage 8.1 environment and that worked perfectly there.I am facing the problem in the 8.5 environment only which is newly set up.Is there any p...

I am going to go out on a limb here and suggest that you do not write a BASIC routine to do this. You will have essentially tied yourself to either a UV stage in a sequencer or implementing a BASIC transform in a parallel job which is generally (won't say never, but want to) a good idea. If you writ...

When er execute the command rpm -qa | grep glibc following is the output. compat-glibc-2.3.4-2.26 glibc-common-2.5-49.el5_5.7 compat-glibc-headers-2.3.4-2.26 compat-glibc-2.3.4-2.26 glibc-devel-2.5-49.el5_5.7 glibc-2.5-49.el5_5.7 glibc-devel-2.5-49.el5_5.7 glibc-headers-2.5-49.el5_5.7 glibc-2.5-49....

I would start with looking at the Unix TZ environment variable and its usage. Then to avoid having all of your times GMT (exported say in your dsenv) I would write a simple C routine that you could call from your job to return a gmt timestamp when you need it. I have included an example that may/may...

Well, your datasets are large likely because the PX framework treats bounded fields as fixed width for performance reasons. No amount of trimming etc... will do away with that. This also holds true for how data are moved between operators - fixed width, again, for performance reasons. There is an en...

On a related note - I would definitely make sure that all of your columns have defined lengths. I know that there is talk that the framework is more efficient if you do not define lengths, but that is only true if the length is greater than 100. Anything less than 100 should be defined especially da...

No we are not using any stored procedure.. Can u tell me what do you mean by "version of glibc" In many cases IBM has suggested that reverting to an older version of the glibc libraries can fix this problem. It does not necessarily happen with all job runs and with all types of jobs. You ...

Craig - be careful - you are dating yourself here :D

So Craig, tell me, what was it like back in the day when you had to actually open the cabinet of the hardware to perform a reboot?

What is the URL you entered that causing you received the HTTP 404 not found? Good point - should be - protocol//host:port/ibm/iis/console where protocol is either HTTP or HTTPS, port is either 9080 or 9443 (ssl) Both 9080 and 9443 are default values so if you happened to have changed them then use...

It has been a long time for me with such things, but did the tool generate the link options for you? Did you have to add dependent libraries?

I ask because I see the .dll and I thought you could not link to a dll, but rather a lib?

Again - fuzzy here, but thought I would throw it out.

Well, characters like that have been called "special" since I started working in IT back in 1984 so I know what you mean and I doubt there is anyone who frequents this forum that did not understand what you meant. You can still use the sed command I gave above and that will work with some ...

Craig has pretty much set you on a course to handle the logic problem. Now, in my opinion, it is up to you to determine how to best handle it in DS. Think of it in terms of any programming language where you will have variables to hold results as you loop through a set of data. This is what you will...

Maybe something like -
or the tr command will work, awk as well, but you will likely have to call a sub process

Again, there are a lot of ways to do this - this is just one of many.

Yes, Auto should work just fine - the framework will put in sorts and repartitioners according to what you have defined as the key. It will almost always do this as a hash even for a single key that is entirely numeric (where modulus might have been a better choice). Auto will also honor what you ha...