DSXchange

Sorry for reapeted posts,

You mean (NextSurrogateKey() + @PARTITIONNUM) + @NUMPARTITIONS

You mean NextSurrogateKey() + @PARTITIONNUM

Thanks Ray for te response.

@PARTITIONNUM
@INROWNUM
@NUMPARTITIONS
@OUTROWNUM

Can you help me in how to use these varibales in Transformer stage to get right sequence.

Thanks
Srimitta

Hi All, Scenario 1. Generating Sequence numbers by using Surrogate key option with NextSurrogateKey() utility in Parallel Transform stage. Scenario 2. calling System varibales @OUTROWNUM in output derivation. in both Scenario's DataStage job is generating even numbers, I know this is because of more...

I checked Data Set management / Schema Window and APT Configuration file in Output, EFFECTIVE_FROM_DATE is existing in all.

Any idea


FYI:
In DataStage v8.0 IBM is not offering DataStage Manager client component, IBM moved all Manager functionality to DataStage Designer.

Hi Ray, It is not that I want to trouble you by pasting job OSH, but I am trying to make sense out-of it where I am going wrong. Below is the OSH from 3 source DataSet's in the job and I find EFFECTIVE_FROM_DATE is existing. Any idea how can I fix this error. ########################################...

Thanks Ray for the response, would you please help me with little bit more info

(that is, rather than in the record schema associated with the link with which you are attempting to read from the Data Set).

Hi All,

I have TONS of these error messages, any clue where can I fix this error in Change Capture stage.

Change_Capture_320: When checking operator: Defaulting "CITY_NAME" in transfer from "beforeRec" to "outputRec".

Thanks
srimitta

Hi All, I was able to create DataSet sucessfully but while reading I have below error and when I checked EFFECTIVE_FROM_DATE is existing. Error executing View Data command: ##E IIS-DSEE-TOPK-00007 11:15:06(008) <_PEEK_IDENT_> Input dataset does not have field: "EFFECTIVE_FROM_DATE". Any id...

Hi Mhester, I don't see APT_DISABLE_COMBINATION in job log. Ok..let me see if I can give you more info, here is the log. When APT_DISABLE_COMBINATION is set to False -Transformer_45,1: Failure during execution of operator logic. -APT_CombinedOperatorController,0: Internal Error: (start <= end): surr...

Hey Craig, I found your posting. This is what with you are trying to help in resloving 'gdb' and 'sed' If you run them separately, do they run without this error? Edit - nm, I see you already said they did. To me, that would imply you could have overloaded your database. There is typically a paramet...

I have tried using your method, GREAT, but still I have same error APT_CombinedOperatorController,1: Internal Error: (start <= end): surrkey/keystate.C: 73 Traceback: Could not obtain stack trace; check that 'gdb' and 'sed' are installed and on your PATH what does check that 'gdb' and 'sed' are inst...

I could find your posting thanks.

I am running one single simple DS job with Surrogate key generator stage to read value from a flat file.

I could find your posting.

I am running one single simple DS job with Surrogate key generator stage to read value from a flat file.

Hi Ray I also tried to use Stage but job Aborted with below warning: Surrogate_Key_Generator_48,0: Internal Error: (start <= end): surrkey/keystate.C: 73 Traceback: Could not obtain stack trace; check that 'gdb' and 'sed' are installed and on your PATH When checked from command line 'gdb' and 'sed' ...