DSXchange

You mean a Primary Key. A Primary Index is how the data gets hashed across AMPS in a Teradata DBMS. They can be two very different things. The Pimary Index is indeed how data is hashed across the amps, but a Unique Primary Index gives the same benefit (and better performance) as a primary key. Most...

That brings up another good question - when is IBM going to help DataStage join the 64-bit world? Most, if not all, of the databases it talks to (including its own repository in v8) are 64-bit. There's untapped power there for the taking!

Brad.

I checked with our Infrastructure group. It was IBM ecase 87332 that resolved the issue.

Brad.

It is only -8 F here. A few days ago it was -13. That's what hot coffee is for.

The dsjob.exe should exist on your Windows client as well. I found it in the same location as the Client software itself: C:\Program Files\Ascential\DataStage7.5.2>dir ds*.exe DSDesign.exe dscmdexport.exe dsimport.exe dssearch.exe dsadmin.exe dscmdimport.exe dsjcwiz.exe dsviewer.exe dscc.exe dsexpor...

By 'macros', I assume you are talking about C macros (using #define)? yes, these work just fine. You can also create functions to handle complex transformations or business rules that are not native to DataStage. For example, we have a function for converting a Hogan date to a standard date in the f...

We had this same issue. I believe there was a patch that we had to get from IBM to make it work properly. I was not involved in the setup, but I'll check with our Infrastructure group to see if I can get some info. In the meantime, you may want to ping your IBM rep and see if they can look into it. ...

How about DS 8.0.1? Will that be supported on Linux when 8.1 is?

Does anyone know what flavors of Linux are supported and recommended? Where is a good resource for researching this?

Thanks!

Brad.

We update the dsenv profile and bounced DataStage. The jobs ran successfully. We'll be migrating this same change to the rest of our environments after another week or so to prove that no other Teradata jobs are negatively impacted. Tom did not expect any negative repercussions of the change. Hope t...

Upon further review, here is a more complete picture of what is going on: Node 0 has a rejected buffer write warning, followed by a Error Code = 350. Nodes 0-7 each process 100,000 records and then fail. The Error Code 350 is repeated, then a return code of 311. The final error message is an error c...

I am posting this as an informational posting, not as a question. We ran into this problem recently and since I didn't find information on DSXChange we pinged Teradata and IBM directly. Now that it is resolved, I am posting the problem and resolution. I'll use multiple posts to make it easier to fol...

Unfortunately, I am not able to check these now. We were able to validate through other means that the projects were not in use, so I deleted the directories and rebuilt the projects. That worked fine. However, since I have now run into this twice in 2 days, odds are 'good' that I'll run into it aga...

For the second time in as many days, I have been asked to create a new project that developers thought already existed. I attempt to the create the project and sure enough, the project already exists. The problem is that it does not show up in a project list when connecting, you cannot find it with ...

There is a string function available for buildops that returns the standard C-type string array for an input datatype APT_String: const char buffer[]; buffer = in.myStrField.terminatedContent(); You can get the length of buffer using the following: int len = strlen(buffer); Hope this helps. Brad.

We are in the process of setting up a new server for DS v8. This is our SIT environment. It has the same version of AIX, DS v8 (and patches), Teradata utilities, etc. and talks to the same database. About the only differnence (that I know of) is the number of players in the config (2 nodes vs. 4 in ...