DSXchange

Do connections using the Designer/Director/Manager also freeze? If so, then it is certainly a network connection related issue, otherwise it is the Administrator. Also, have you tried connecting from another client using the Administrator?

What is your Oracle NLS_CHARACTERSET?

The error messages look like log entries for an Oracle job and normally have nothing to do with the engine itself. What command did you issue that generated that output?

The only trial versions that you can get for DataStage are directly from your distributor or from IBM/Ascential.

I usually do this kind of processing using "states". I will use stage variables to store state information and other relevant values. In your processing you could create a stage variable such as "CurrentType" which is set when a record begins with BEGIN and set to the value of the 2nd word (i.e. fie...

<getting on my soapbox and ranting a bit> Many, if not most, of the DSXchange forum users are not native English speakers (that includes myself). It is very disconcerting to see so many recent posts making use of SMS-type abbreviations or codes to such and extent that the question or answer only be...

DataStage BASIC programs are case-sensitive, so in addition to translating the SMS shorthand "chk out" to "check out", remember that you need to use DSJ.LINKROWCOUNT and DSGetLinkInfo()

I'm not Ray but feel confidant in answering your question anyway. TX is a completely separate and distinct product from Server , which is also a distinct product from PX . IBM/Ascential sales will, when requested and they feel it useful, issue the software with a temporary license for trial use. All...

Hello Kartheek and welcome to DSXchange! The information that you want to put in the sequential file is available after a job completes by using calls to builtin routines such as DSGetJobInfo() , DSGetLinkInfo() and DSGetStageInfo() . You can also access quite a lot of this information from the dsjo...

Sure you can, it is quite easy. One easy way (but not necessarily the fastest for huge data volumes): Do a lookup from the target to the source; if the lookup is not successful then output to a stage which deletes those rows from the target.

Johannes,

what error message are you getting from the routine when you try to open the file? A dynamic hashed file is created as a directory with the file name and it has 3 files - a .Type30, DATA.30 and OVER.30 so it looks as if the create portion was successful.

This is a duplicate post, please follow this thread

You mean the whole OS freezes and you have to power down or do a reset to get going again or just the admin client and perhaps DS would hang?

Unfortunately you need the installation CD to re-install, the DSEngine alone is not sufficient. Part (but not all) of the reason is that the IP address is stored inside the installation. You will be much better off actually getting 7.1 from IBM/Ascential/Support provider. An active service contract ...

There is no trial version that can be downloaded off the web. If you contact IBM/Ascential sales they might be able to arrange an official demo version of any of their product suite.