DSXchange

Finally it worked after I made few changes according to your suggestions:

Changed my netsted condition trigger expressions:

From
----------
PATH='I'
PATH='D'

To
---------
'I'
'D'
---------
without the PATH=

Thank you very much for your help.

FINAL_SEQUENCE_VER2..JobControl (@Coordinator): Summary of sequence run 20:30:33: Sequence started 20:30:33: Sequence finished OK ================================== I have three jobs under the nested condition sequence (final_seq) with incremental and destructive. First job grabs Max_TS from staging...

You were absolutely right . It worked perfectly once I deleted the # signs. Thanks :D

I was able to compile it after I deleted my parameters (#Path#=D) and just kept my sequence unconditional with only one condition (incremental- as simple as possible). I still need to investigate more on this to find the actual problem but for now it works. Thanks for your help. I learned to pay mor...

My final join Job also gives me an error on validation. It's loads the Data OK without any problem but when I try to validate, it gives me following error: Attempting to Cleanup after ABORT raised in stage FINAL_JOIN1..Dynamic_RDBMS_0 DataStage Job 22 Phantom 356 Program "DSP.Open": Line 1...

You pin pointed the problem. I had copied this job from other project and the parameter setup came with it. I deleted that parameter but now I recieved this error. Do you have any clue what's going on? ================================================ Compiling: Source = 'RT_BP24/JOB.112016544.DT.140...

I had similar problems with ODBC so I switched to Dynamic RDBMS stage. It worked fine after the switch. I encountered problem using ODBC on any table with timestamp but after I switched to Dynamic RDBMS stage, everything seem to work fine. I have read some articles about ODBC and it's connection to ...

WARNING: Variable 'Routine_Activity_32.$ReturnValue' never assigned a value. 2 Errors detected, No Object Code Produced. (FINAL_SEQUENCE) I haven't been lucky compiling this sequence. I have DS 7x (PX) on Win XP. I am trying to load a simple incremental data into the staging table. This is a netsted...