DSXchange

the data is as such DSLink2.f1 = 1 DSLink2.f2 = aaaaabbbbb my job contains: stage var: char(10) -- svSeparator DSLink2.f2[6,5] -- svText Derivation DSLink2.f1 -- col1 DSLink2.f2[1,5] :svSeparator: svText -- col2 if i don't have the col1 in the target i get what i need aaaaa bbbbb but if i put col1 i...

hi,

when i add other fields to the multiple lines question the format seems to go wrong, any ideas.

i.e. col1,col2

1, aaaaabbbbb

which i want to be

1 aaaaa
bbbbb

ends up as

1 aaaaa
bbbbb

thanks

thank you, i shall have a look into that

Hi, I have a single 100 char field, and i have values that needs to go into this that can be greater than 100. if the values go over 100 char i need it to break on to the next line and so and so on.. grouping done via sortnum ex. using a 10 char field sortnum, text 01 Dstage Ser 01 ver 02 Posting ne...

thanks for the advice, i'll give that a go

hi, yes i do, i have got it working for the following from (materialnum, seqnum, text) 1 01 a 2 01 a into 1 01 a 2 01 but i also need to incorporate concatentaion of text values for the same seq num, as below, im sure it can be done in the stage variables from (materialnum, seqnum, text) 1 01 a 2 01...

hi, yes i do, i have got it working for the following from (materialnum, seqnum, text) 1 01 a 2 01 a into 1 01 a 2 01 but i also need to incorporate concatentaion of text values for the same seq num, as below, im sure it can be done in the stage variables from (materialnum, seqnum, text) 1 01 a 2 01...

sorry original problem still exists

from
(materialnum, seqnum, text)
1 01 a
2 01 a
3 01 a
4 02 w
4 02 w
5 03 c

into

1 01 a
2 01
3 01
4 02 w
4 02
5 03 c

hi i got it working but its just the ordering i.e.

from
(materialnum, seqnum, text)
1 01 a
2 01 a
3 02 s
4 03 q
5 03 q

into

1 01 a
2 01
3 02 s
4 03 q
5 03

hi, i have 3 fields (materialnum, seqnum, text) the issue i have is: 1) If two text values in a Sequence number are the same, i need to take only the 1st text value but still pass the other row through but with a blank value for the text column. from (materialnum, seqnum, text) 1 01 a 2 01 a into 1 ...

hi guys, thanks for all your advice. i got it working by creating it in the stagevariables and keeping the last row as suggested.

thanks again

hi,

quite large as possibly 50 plus.

thanks for all the information

Hi, i am trying to concatenate multiple rows from the same column based on a number into a single coulmn. rows per number can be quite large. Ex from: col1 col2 1 aa 1 bb 1 cc 1 dd 2 ww 2 er into this 1 aa bb cc dd 2 ww er any pointers would be greatly appreciated. thanks

Hi, thanks for that.

the server was rebooted and that seems to have cleared up any gremlins and its now ok.

Thanks again

Hi I am using datastage V8 server and when i try to link a sequential file to a Merge stage i experience the following error message : '(40503) a call to OLE server has failed, or a runtime error occured within the OLE server itself' Any ideas as to why this occurs. could this be a bug or incorrect ...