DSXchange

The current soft limit on the data segment (heap) size (805306368) is less than the hard limit (2147483647), consider increasing the heap size limit. I am getting this error in aggregator stage.

Hi, I have seen the same issue as above. The problem is that the table load job that i ran was running fine for the last 15 runs. Recently it started giving troubles. It aborts sometimes with the -3025 SQLCODE and i wont be able to simulate the same error after 3 days. Still not able to figure out w...

Hi i was working on DataStage 7.5.0 previously.

I need info about the enhancements and upgrades in
DataStage 7.5.2.

Details of additional features.

Please help me.

Hi all, I am facing a problem generating 14 digit surrogate keys . using surrogate key gen. I guess it supports max 10 digit keys. I know that i can use row generator to generate sequence of numbers. But row generator works in sequential mode. Even transformer can be used in sequential mode. Can i u...

Hi all, I have a scenario to remove duplicates. there are 257573 records coming in from source table and when i am trying to remove duplicates a) either in sort stage. b) using remove duplicate stage only 41 records are exported. While i write a select distinct query in sql i get all 257573 as disti...

Has any one used a generic stage.
What is an Orchestrate Operator?
how do i use a generic stage?


If at all there are any methods to write code at Orchestarte level, where will i find help for that.

hi man do you know how to use TX map Stage.

I want to know why i am not able to compile jobs when i place a constraint on the links based on stage variables.

Examples of datastage provided parallel routines are in Datastage installation CD. this is according to the manual/help in Datastage.

I am facing was facing a problem in handling variable length column in exporting data to sequential file. i used field width=120 and padchar=Space to solve it format tab of the stage. But i am concerned about performance. What is the field width i need to use to make my job perform better? the varia...

this is the error when using job parameter with the remaining code being same. ##W TCOS 000049 04:18:28(000) <main_program> Parameter specified but not used in flow: DSPXWorkingDir ##W TFCP 000000 04:18:28(002) <transform> Error when checking composite operator: The number of reject datasets "0...

1) as before requested i am pasting the complete compilation out put. Not able to use IsNull and IsNotNull functions in parallel transformer stage and also not able to use job parameters in derivation part of transformer. neither in stage variables nor in output column derivations. Output from trans...

The compilation error is shown below. This kind of error also comes when using jobparameter in the transformer stage. Infact was not able to use any of the NULL Handling functions. once i remove the job parameters and null handling functions from the transfomer stage its compiling without any errors...

Not able to use IsNull function in derivations of transformer.

chulett wrote:Check here for thompsonp's response, see if that helps. ...

I have given remote server ip still its not running.
Connect failed.
:TNS no listener and also i am able to access the table metadata for the same database