DSXchange

Hello Everyone!! Anyone worked with segmentation before?? What are the properties do we need to set in the MQ Stage apart from the usual parameters? Please refer to my 1st post.. Anyone tried this before? i got rid of the new lines in the compressed message retreived from the MQ and tried to unzip i...

Thanks Craig!!

[quote="DSguru2B
If you are using one sequential file stage, you will get one file created at your target path.[/quote]

No!..we can create more than one file using one stage..(one file per link)

meena!..what your log file says?
does it warns anything?
give us some information.

kalpna

Not being all that familiar with MQ - if all segments are read as a single message, why segment? When you write out the results to a file, do you get one single file that contains all the segments in the proper order? :?. Because, MQ has a limit on the size of the message. we are segmenting the mes...

Thanks for ur responcse craig!!
Iam reading the message from MQ using WebSphere MQ stage.
which just reads all segments as a single message.
so, i am not doing anything to concatenate..!!
and writing the retreived data to a file.

kalpna

let me put my questn this way!! say my file is somethign like this... <lostDemand> <extractDate>2006-01-20</extractDate> <dcLocation>D985</dcLo cation> <bnqCode>24766418</bnqCode> <e an>5014957128637</ean> <orderQty>00120</orderQty> <issueQty>00090</issueQty> <numLines>0001</numLines> <totalOrderQty...

use an aggregator..
group by key
retreive first(col1)

kalpna

Hello Everyone!! Actually we need to process large xml files( 10MB- 50 MB). we get these files from MQ-Series. but, as these files are very large to handle we are compressing it(gzip utility) and then segmenting it through MQ-Series and then retreiving through datastage. But, in datastage when iam u...

Hi! I was wondering, any one has noticed this before. I was unaware of this premium content stuff. I was wondering, y can't i see the complete matter..then, played with it and found that, i could see the content by clicking 'reply with quote button on that particular post' ????? :P :!: :!: Kalpna

i think u can't acheive this in one job.
Load them into three different files and then use link collector with round-robin algorithm(default) to combine into one.

I think, it works..
Kalpna.

Hi! Veni
what is ur requirement??
is that a record or column??(001,002,003)

Kalpna

Hi! Friends
One of my job gives this warning.
'PRINTER memory segment removed
DataStage Job 491 Phantom 20717'
I don't really understand ,what it says..

its a simple job..
just appending data to the existing one..

any clue!!

Thanks
Kalpna

Thanks.....Chulett!!..

Thanks Ray!!!!..


Cheers
Kalpna

Actually!,.the problem is with my Oracle table.. I tried different date formats . It accepts only 02-Feb-2004 Format..(i confirmed it using sql). I have acheived it using the above mentioned function and then using DownCase.. But, it says, converting string value '02-Feb-2004' to date is unsuccessfu...

Sorry! Arnd
I tried both!...
yes!, I used DownCase...
But, Just like to know the other way...

anyways!..thanks
Kalpna