DSXchange

A question with the answer!
Yes the option 'reset if required and run' will help you to reset the aborted job if the sequence made to rerun.
Do a search on this topic or go through the Datastage Designer manual.

Was your server overloaded?
How many jobs were triggered parallely at that moment?

Queries used from OLAP tools used for Business Analysis purpose might require would become costly. Sometimes not feasible. Queries need to trace hell lot of informations for getting a very simple answer for a business question. You can save lot of money, material , man power and resource in spending...

What is the error you get when you try to view from the client?
What you mean 'view data on server' is it you are trying from the client where the server resides?

Unhandled String truncation should through out an waring. Was the message been handled?

Is it for HP-UX or AIX?

What is the Object type you specified.
Object or Library?
Assign to Object and give you object file with the path in the library path.

dssiddu wrote:Hi all

Could you please tell me how to install Parallel extender on standalone machine having Windows Env. And also know which are the other softwares(c++ complier or else vb.net) required for this.

treat urgent..

Advance thankfull

Its quite cheap. 500$ per instant installaion

'dscc' from client end can be used for the automated purpose.
It would be enough to get the status of the jobs which are in 'running' state and recompile only those.

For such case, the following command can be used.



It gives the file without trailer.

tail +1 gives file with out header. Both commands can be piped.

First try to load into a sequential file and make sure that you dont have any constraints set in your jobs. Like 'Abort after' or 'Read first n'... If no, check the database if you can able to load the same set of data manually . Make sure after 5000 records, it doesnt violate any referntial constra...

Use MantissaFromDecimal or need to pad the string of 0s to the left of the existing number manually after calculating the length (digint) of the existing number.

Sorry! In fact is substring() like that record_type:string[1] = substring(record_data,1,1) and I have this message : Error parsing modify adapter: Error in binding: Parsing parameters "" for conversion "string=substring[0,0](string)": Expected integer, got: <eof> Expected destination field selector...

May I know is TZ environmential variable for PX?
Also I guess System() function is not a PX funciton.

Try
record_type:string[1] = substring[1,1](record_data)