DSXchange

Hi all, Thank you for following up. We have raised a PMR with IBM to help us with the issue. Meanwhile we have been suggested to try using the DRS connector with LongVarBinary datatype for the BLOB column using the DataDirect drivers. Let us see what other solutions, IBM PMR team comes up with. Than...

Not sure but this is a scenario that I have noticed as well. I have noticed in cases where we have duplicates in the source (after), the first record gets identified as a copy (assuming the data is available in the reference/before as well) and the second record gets identified as an insert. Not sur...

Thank you for your response ramesh. I have tried using the LongVarBinary option and I always seem to be getting the below error message at the target. ODBC Function "SQLBindParameter" reported SQLSTATE = HY090: Native Error Code = 0: Msg = [DataDirect][ODBC lib] Invalid string or buffer le...

To my understanding a wrapper stage is one that passes data through to an external executable or script and reads the response from said program/script. As such your support team would still need to maintain that. Assuming I am correct in my assumption :wink: , you should be able to parse the data ...

Hi everyone, Hope you are all doing well ? Request your expertise for the below scenario. I am trying to create a custom Parallel Stagetype - Wrapped. Need your help with the below queries. 1. Is it possible to design such a stage and then make it work for each and every record from the source ? 2. ...

Hey everybody, Hope everyone is doing good.. Request your expertise in helping me with this query. Currently we are trying to reverse engineer a few projects and extract the functionality. This is to be done with DataStage 7.5 and 11.5. Is it possible to extract the description from the columns tab ...

Dear all, Another day, another query.. We have a requirement to convert a string to a decimal/integer value. Of course it is not a straight forward conversion. We have few rules to apply say if the last character matches 'XYZ' then negate the value and add something else if..... Also if the scale is...

Hey Hi Craig, Thank you so much for your response. The reason I have to change the Generate SQL option to 'No' is that (my intended requirement) all the fields except the Create Id and create date have to be updated whenever we encounter an update. So for the first time encounter a new set of keys, ...

Dear all, This is regarding a query which has been discussed a few times, but the exact fix seems to elude me. Scenario: We are trying to load a HANA table with the write method as "Insert Then Update". The HANA table belongs to a package. Hence the table name shows up as "SCHEMA_NAME...

I am trying to configure the subscription manager to get basic notification of IGC governance events particularly IGC_BUSINESSTERM_EVENT. I am following the configuration steps as given in this link. http://www.ibm.com/support/knowledgecenter/SSZJPZ_11.5.0/com.ibm.swg.im.iis.bg.doc/topics/t_enabling...

Dear all, Hope everyone is doing well. I need some information regarding the CheckSum Stage. BackGround: My scenario goes something like this. 1. A source file having over 280 Columns and a target table with the same number of columns. 2. We need to perform CDC operation to capture the delta. 3. We ...

hi jweir,
I think Craig meant that the DSJS.RUNWARN definitely needs the job to succeed and have warnings to pass through.

If the job had aborted with warnings, there is no way for the trigger to get activated.

Can you please re-validate your trigger conditions ?

Hi Franklin, Actually we are not picking up the value file within the job. What we are doing is identify the hostname in the script, then based on its output have the value file name captured. Step 1 : Say for example (Just representation) if $varHostName is 'xyz' then varEnvId='DEV' else if $varHos...

Thank you so much for your response Franklin. We have designed the sequencer in such a way that only on the successful completion of an activity we move to the next activity. In case of certain execute command stages which return a specific values we have handled them with appropriate trigger values...

Dear All, Another day, another request for suggestions and help. I am trying to create a UNIX script to trigger the jobs. These scripts would then be scheduled to run as per the requirements. I have encountered some trouble with certain scenarios and would like the advice of the experts here. Please...