DSXchange

Sreeni, but in this case a sort on a sequential file is going to be more efficient that loading the sequential file into a database table and then doing a select distinct on that table and bringing the data back out of the database. There is no possibility of the database solution being faster, whet...

Craig, r u txtng abt my gud frnds @ the "Korova" Milk Bar? Anthony Burgess came up with almost a completely new language and slang language for his book, based mainly on Russian words inducted into English; so your comment fits in perfectly with this subject. I used to call my friends "droogs", I'd ...

In this case I was curious if he really wanted us to post a way to crack IBM/Ascential's licensing security, so I responded quickly. It seems that my suspicions were incorrect; more likely Wolfgang's interpretation was correct. The ways the post was phrased put me in mind of people walking into our ...

The daemon will traverse all running DataStage processes and make a complete list of locks that they hold - if one holds a lock that another process is waiting on and the other process is waiting on a lock that the first happens to hold it detects a deadlock. It will also go through the locks and se...

Craig, you have a good point about the distinction - from the user point of view a link that is too small to see is equivalent ot being invisible. It does work out to the same thing... I suppose the correct clarification would be "DataStage does not allow links between stages to be hidden". p.s. I c...

Since you can define a single hashed file stage (by this I mean the graphical object in the designer) to have multiple output links with multiple hashed files, each of the output link attributes needs to be defined; so if you have 2 links to the same file you will need to click on the drop-down list...

"Hangs" as you described are most often caused by locks held from other processes. If you killed the job from UNIX instead of from the director then some of those locks are probably from defunct or killed processes as well. You will need to locate the cause of the hang. Does your stage show any rows...

Koolnitz, those links are artefacts of deletion and their start and end points are not attached to any stages plus their length is just one pixel - they aren't really invisible, just too small to see. Compiling and then clicking on the "more" button will highlight them for deletion. Sometimes these ...

Wolfgang, this is a private "pet peeve" of mine as well. Posters should be ashamed of flaunting their inability to communicate by using such contractions! Unless you are posting from your cellular phone you will most likely have a full keyboard at your disposal and there is absolutely no reason to u...

You can have multiple output streams from a hashed file stage as well as multiple reference streams AND even several input streams, too. Just draw a link in the appropriate direction to/from the hashed file stage.

This looks like a duplicate post to your other thread with the same job referenced. Is it the same? If so, please ask the moderator to remove this thread, if it is different you will need to give some more information - just as with your other thread you should try to reset the job and look at the l...

This does not look like a hashed file error, just an error in a job sequence that has "hash" as part of the name. The error occurred calling up the job/instance "DrgStandardProcHashLoad.625" and you should also look into the status and log file of that job and instance. Can you reset the master sequ...

Cool, can you tell us a bit more about Version 9 ? (the current version is 7.5)

What is your issue exactly, you normally can go from a sequential file to an XML stage, even at versions < 9.

As Wolfgang has already pointed out, the ASCII() and EBCDIC() functions will convert strings to/from the different representations. This can be done in a derivation on a per-column basis. The Complex file stage will also let you do this - the method you choose is up to you and might depend upon how ...

I'm not sure I understand what you are asking?

Do you want to know how you can get around those pesky license restrictions imposed by your license key combination bought from Ascential or do you have or another type of user restriction that you wish to change?