DSXchange

Gurus, I have the below routine in server edition cmd = "cd /opt/isproj/ctl/ && ./ctlAccess" :" " :Arg1 Call DSExecute("UNIX",cmd,Output,SystemReturnCode) Ans = Output Seems like DSExecute is not present available in binary .so for 8.1. I'm searching for the equ...

Thanks a lot :-) it workrd.

Regards

[quote="ArndW"]The Server "@FM" is the equivalent of CHAR(254)[/quote]

Gurus, I wanted to convert my output as below Input column string ABCD qwert Output ABCD~qwert I used the below function Convert(@FM,"~", Output) but in parallel @FM is not been recogonized, i tried to replace it with char(31), char(10) even char(30):char(10) but its not working. Is there ...

Gurus, Initially we were getting the XML string in below format <msg><trans><updateRow> <col name=" SAMPLE "><char>232100905></char></col> <col name=" ID_NO "><char>232100905></char></col> </updateRow></trans></msg> and I was able to parse it correctly by below method /msg/trans/...

Gurus,

I have data as below

1 a
1 b
2 c

I wanted to convert it to

1 a b c

tried couple of stages but seems like reverse of pivot is not possible thru them.

Regards,

Hi, I've never worked with XML string and we have below XML string <msg><trans><InsertRow> <col name="PARTY_ID" isKey="1"><char>1INSER </char></col> <col name="PART_CD" isKey="1"><char>s </char></col> <col name="INDIV_VER_GMTS" isKey="1"><t...

Hi, I have XML string as input, Every string format is different i.e. I want to parse the haeder first and then the col tags. I'm able to parse the xml header which has table name and do not want to parse the data field i.e. I want all fields to remail in tags as I want to parse it in later stage on...

Why not just leave it as a server job? The startup overhead is much less, which means that the output would arrive sooner. In server job MQ websphere stage is not available and also IBM has developed some segment splitter and product called DTS which we are using and its only available in parallel ...

Gurus, We getting error in the basic transformer in parallel job, job is running on single node on which DS is configured. ds_loadlibrary: error in dlopen of ccpassive.so - /opt/is/IBM/InformationServer/Server/DSEngine/lib/ccpassive.so: undefined symbol: _ZN7DSStageC1EP10DSCStageT_ Any inputs why we...

Hi, I even proposed it to call from sequencer and pass the routine value to parallel job....but we can not use sequencer as our job source is MQ websphere and the way its configured it will pick up the messages(segments) from UDB log i.e. as soon as UDB table are updated the message will be publishe...

Hi Ray, We have c++ compiler and our job will be running in in sequential mode i.e. we have MQ Websphere plugin as source and messages are generated in order like before and after image comparison .....we have created the POC and it works ...we need to get the value from ctl tables on basis of argum...

Gurus, I've written a server routine which I wanted to convert to parallel routine. We have c compiler installed on box , I wanted to wrap the below code in c shell and ompile it but I'm not sure abt the syntax i.e. can below code be just included in c shell as it is ..i tried to search for examples...

Thanks a lot

[quote="narasimha"]Assuming '[b]%[/b]' is your delimiter, use

[code]Field(Arg1,'%',3)[/code][/quote]

Actually the requirment is to cut string in b/w 3 and 4th instance of identifier , I was not bale to post it correctly first time i.e.

1111%11111%RESULT%11111% = RESULT

Regards

narasimha wrote:Right(Arg1,3)
Or did I miss something from your requirement?

Hi,

I have a requirment to always grab last three charcters from string i.e.

123456 ans= 456
I tried couple of optios but it chops like substring, left, right but nothing seems to work,

Right(Arg1, len(Arg1) - 3)

regards,