DSXchange

To read it as a vector of subrecords from a file, You MUST do away with the enclosing brackets '[' or ']' , and add another column to your schema and define it as a link field for variable length vector - which will store the count of beginning brackets or closing brackets - this will effectively be...

Not very sure about how internally duplicates are identified , but duplicate lookup keys will resolve to the same Byte Sequence , so probably there is an internal structure which has some ordering. If you have access to version 8.x documentation , Id suggest you take a look at the parallel job advan...

version 7.5 . I worked around the issue by calling the sub job in Run mode ( using a zero length file) till data starts flowing in.

Thanks for validating my fears. Im going to continue using convert(). Effectively we are tokenizing a regular language sentence into a set of delimited 'words' and pivoting them , looking up with one table to eliminate 'useless' words & text noise ( prepositions, articles etc) and scan significa...

Column 2 in your input looks like a variable length ""Vector of Subrecords." You can use restructure stages . Let me know what you data source is. I have done similar work using "Promote Subrecord " stage Convert a variable length vector of subrecords to subrecords - in fact...

If you are doing an insert , Can you try the "Delete Before Insert" Action in the "Write Mode" property ? That may allow you to use row values ( probably auto generated SQL)

Which column[Xpath] have you tagged as the key column of XML output stage ? It should be the ID tag

Thanks . But I noticed the entry that says Summary of sequence run(...) occurs only if the sequence finished ( Ok or with warnings). The invocation that lead to teh sequence abort does not have teh "Summary of Sequence run (...)" log entry . : :( As a matter of fact , i read each entry tha...

Can you not use a transformer & funnel stage ?
COl1, Col2 Col3 for input link1
Col2 , Col3, COl4 for input link 2
Col3,Col4,Col5 for input link 3
Col4,COl5,COl6 for input link 4
Col5,Col6,NUl for input link 5
Col6,NUL,NUL for input link 6

Combine all input links using round robin in funnel.

1. Ignores duplicates , but issues a warning message about a duplicate key ref found. 2. No - The reference link in a lookup stage does NOT require a sort - nor does it sort internally - but it builds an index out of lookup keys which may be sorted+/hashed 3. You may be able to speed up a lookup mer...

Is there any function in Basic similar to String tokenizer in java or strtok in c/c++ ? Im trying to parse a list of text values ( like a regular language sentence) and replace all Non Alpha numeric characters with a single Non Alphanumeric character(per occurence) . Ereplace() is very specific. Con...

Throws an info message and calls DSLogFatal()

We are encountering a strange issue with one of our Job Sequences The Jobs sequence calls many jobs in serial ( tandem) . If any job aborts , it calls an abort routine( behaves similarly to terminator activity , but prints last job's activity variable values to log) One of the jobs was set to run af...

FYI : This security 'hole' has been fixed in Datastage 8.7 .
You can no longer echo encrypted passwords to the job log using a Before after job subroutine that calls the password-storing Job Parameter/Env Variable.

Im not sure if the 'utility' mentioned is of much use with 8.7 and above. LOL

You would also need a supported visual studio C/C++ compiler and a Db2 OR SQL server database on your PC . Not sure if DB2 Express will work .