DSXchange

Hi, just a quick and hopefully easy question. Does anyone know whether it is possible to rename a job category? I have tried looking in both Manager and Designer and have not been able to do so. I do not really want to create a new category and then start saving the jobs from the incorrectly named c...

hi can anyone give me an overview of the following in datastage. 'Error control' and 'Reporting of job status'. where and how it would be used.

i know this is very vague. any pointers greatly appreciated.

thanks

hi, somebody posted a while back the difference between a parallel job and a server job. can anyone remember the link. or explain the differences between the two and benefits.

thanks in advance

yes that's the output i require. i shall give that a go. thanks for all your help.

hi, for the id column there is no separator it is just a static value which i need to repeat. the names column has the separator but i have that working. it's the static value of id which i need to create duplicates of. ex: SOURCEFILE id names 1 aaa/bbb/ccc what i require is the following: names id ...

hi, thanks for all you're assistance. i used the following code in the names derivation: Ereplace(DSLink13.names, "/", Char(013) : Char(010):DSLink13.id, -1, 0) but it placed it all into a single column. how would i add a column seperator. not quite sure how to go about that. don't i need ...

hi, thanks for your response. i tried the modified ereplace but the thing is i need 2 columns in my output. at the moment i have 2 source columns of ( name, id) and i require 2 target column populated (name, id). the modified ereplace placed them all into a single column which isn't what i require. ...

hi, the Pivot stage works fine if i have single values in my source column and not delimited data that needs to go into target as separate rows but this is what i have. this can be fixed quite easily. what i require is all additional fields from the source ie 'id field' which is a single value to be...

hi all. i posted a topic last week with regards to a source colmun which is delimited that i require to seperate and create multiple rows in the target colmumn. i.e aaa/ddd/ccc. this was acheived by the char(013):char(010) this worked fine. thanks for all your help. the problem i have now is that i ...

thanks for your suggestions. i shall check out the link and give that a go.

Hi. what if i have varying number of values that i need to split. i need every single value that is in the source field to go into the target field. so if i have say aaaa/bbbb/cccc/ddddd and i require all 4 values on separate rows in my target how exactly would i use the field function. won't the fi...

thanks, that has worked when my source fields contain a single value. however some of my source fields contain multiple values which are separated with a '/'. example key sourcefield1 sourcefield2 sourcefield3 aaa aaa/nnn/mmm bbbbb ccccccc bbb zzzzz hhhh/kkkk/jj nnnnnn where this is the case the piv...

hi i forgot to mention they being grouped by a key:INROWNUM. example: key sourcefield1 sourcefield2 sourcefield3 aaa aaaaa bbbbb ccccc the output i require is as follows: key targetfield aaa1 aaaaa aaa2 bbbbb aaa3 ccccc thanks in advance

hi. example: what i have is 5 source fields that need to go into 1 target field. the reason i said in sequence was that i need each of the 5 source fields on separate lines in the output (which is a single field). concatenation would still have them on a single row but i require each feild on separa...

hi all. i have a job that requires multiple source values to go into a single target field. the issue i have is that i have around 5 source fields per group that require entry in sequence into a traget field. how can this be made easy. any ideas most welcome. thanks in advance.