DSXchange

Precious, if the OS or hardwar word width is 32 bits you can still have a 64-bit pointer; it just spans the internal work boundary and is somewhat less efficient. The file system pointers need to be bigger than 32bits to support that 2Gb limit; and if you use the NTFS file system on any of the newer...

ewartpm, the distributed hash file mechanism works well, but as you have seen from the other posters, it does invalidate the caching mechanism. That said, if you choose your partitioning algorithm carefully, you can read and write to the individual "partitioned" files directly and use them in normal...

Madhav_M,

try just entering "dsjob -run" on your command line, you will get a short help list. The "-wait" option exists and is heavily used, so it will work; you might be making a simple syntax error when calling it.

What does the "LD_ICES_IMPACT_T2_PERSON_AID_J..X_ClientSeparations " stage do? Perhaps you have a UNIX permissions issue on either hash or sequential files - could it have been created by another userid and your access settings aren't set up appropriately?

If you have stopped UniVerse (i.e. can't start the designer), then you can do a "kill -9 pid>" on those processes that are still running [you won't be able to enter that administrator if DS isn't running). This method of stopping processes is not recommended, but as your engine is stopped you have l...

Precious, NLS is a very powerful portion of DataStage. It is quite complex and will make your jobs go slower than before; it might also introduce errors in existing jobs (not compile-time but run-time). Unless you absolutely need to: - Automatically map from one character set to another - Manipulate...

snassimr, The answer to your query is something that is covered in the tuturial. I feel that this forum is not intended to be used as a substitute for an initial training or walk-through or tuturial. Most likely you will get someone who thinks differently about the use of the forum to explain how to...

snassimr, I think you are best served by installing and using the tutorial; the basic methodology of how to use a hash file as a reference lookup is covered therein. The .pdf as well as the online help also works quite well but does assume that you have a grasp of the basic functioning of the design...

I have a job which uses a total of 11 different references in a lookup stage. I use normal .ds datasets have changed them in a copy of the job to lookup filesets (took a while, as the lookup fileset has one less column, the key, and needs to have the same name). Both copies of this job used about 30...

Madhav_M,

the "-wait" option tells the dsjob call not to return until the job has finished; So you need it on your first call as well in subsequent ones.

Although Ascential announced such a program, I don't know how far they have come along. I've now sent 3 separate e-mails to the certification email address and I haven't gotten a reply. The e-mail address they put on their web pages is "Certification@AscentialSoftware.com." and the blurb on ADN read...

Sorry, I just took a quick look at the dsjob options and you need to specify the "-wait" in order to wait for a completed status on subsequent runs.

Madhav_M,

then you have a timing issue, the dsjob -run command is returning while the status of the job isn't quite finished. Before looking into an elegant solution, just put a "sleep 10" command between the dsjob -run call and see what happens.

Santosh, you posted in the Px forum, so the ICONV/OCONV functions are only available to you from within a BASIC transform stage. There really is no data conversion between a binary field and a structured one, but if your binary field contents are ASCII characters then, in server, you need only chang...

Check your log file in the director for the 1st run; it might have started but it ended up with an "Aborted" status. This is why the subsequent runs did not work.