DSXchange

Hi, Everyone Can anyone suggest a solution to the following scenario. I have more than 100 csv files as my sources. all of them are of same structure. I need to extract the data from all these files into a table with the file name as an added field. Number of files in the folder are not constant. an...

Hi!
Can anyone please post the contents of the core developer training program, conducted by IBM or any other?

Thanks

BAsically my question is, How can we call a stored procedure repititively with different arguments?

Using a stored procedure stage, how can we pass a dynamic parameter?

How can we implement this in DS?

Hi! Evryone, I have a table/file containing a list of policy_nos and I have a stored procedure, which takes this policy_no as a parameter to generate some output. so, my question is, how can I implement it in DS? I Need to call the procedure for ecah policy_no in the list. Any suggestions? Thanks Ka...

Hi Evryone Can any one give me an idea to get the previous mentioned day's(eg,.Sunday) date from current date. I found a function 'PreviousWeekdayFromDate', but, i didn't understand the functionality. Example: todays date is 19-09-2006 i need the last sundays date which is, 17-09-2006 Thanks in adva...

I tried without MQ..
I mean.., i took a file zipped it(GZip), passed through the transformer with the data type binary and wrote to a file with extension .gz.

it does not recognise it as gzip format..

Any clues!!!!

Thanks
Kalpna.

ArndW wrote:I'm at loss in that case; I don't know why you are getting mangled data. Can you work around it by copying and gunzipping outside of DataStage? ...

Tried in Unix, tried in windows (as gzip and win zip are compatible)
works fine..
but, not the output from datastage...??

Kalpna.

Naveen!
try using like operator.

Cheers
Kalpana.

compressed data is binary. The first bytes of the file determine what the type is, so in your case the first packet (and most likely all subsequent ones) are being mangled. Can you output the mqseries compressed data straight to a unix file without using datastage? I am willing to bet that it isn't...

abha.kalra wrote: i also checked that data is breaking after each 999 charater. my queue length is 8000

Hi! abha
what is the max mesaage length of ur queue..?
how did u place the message on to queue?
and what is your message type?

Kalpna

Can you uncompress the same file using the mentioned command from command prompt with out any issue? i am passing the compressed file(using gzip) to the quque from command line only..(for testing) MQ does not change the content... but, when i get the same message from the queue, (there i need to de...

adding to that..

when i use bit datatype and try unzipping it..
it says..
unexpected end of file..
does that mean it recognised the format..now.
same with unknown datatype.

DSguru2B wrote:Probably there is a seperate utility to Unzip MQ compressed XML files.

No! its not MQ compressed data..its of gzip.

kumar_s wrote:How about VarBinary or LongVarBinary ?

No! tried both!! it doesn't work

Thanks
Kalpna

Hi!
Can anyone tell me what is the sql datatype for compressed data??

Thanks
Kalpna.