Recent content by venkatpavan

Hi, Currently we are using WTX8.4.1.0, have a simple map which has two input cards and two output cards one for extract and map and another to put file. Using extract function using input 1 and input 2 one fiekd inside the functional map. It is taking around 30mins Input 1 has 10k records and...

Hi All, Application Pushing around 1000 messages(each message with size 2 kb) to the Queue, and when WTX tries to pull using the IBM MQ client, receiving only around 700 messages. Pushing : 1000 files successfully pulled : 709 Errored in Mq trace log : 204 <31260818-5931-Wed Feb 10 11:54:32...

Hi, I'm trying to generate a MQtrace.log using -T command thru launcher(msd), however whenever I receive a message it overwrites the log, in this case how could I append, so that I couldn't loose the information of my previous message. Thanks, Consultant

Hi , I’m receiving following nos in xml field and I need to convert to number in the output, do we have any function or anyway to caculate this. 3e-05 = 3/100000 2e-06 = 2/1000000 Thanks, V

Appreciate it, Thanks!

Hi, I have a main map calling a another map and getting data from first card using "-OF1". If RUN map doesn't create any data so nothing sent to main map(As output card set as create on content), main map is not generating any file. My query is even if RUN map not generate data I need to...

Thanks guys! Let me try...

Hi, I'm trying to read the file which has multiple MQheader + messages in a file(doesn't have any terminators),Could someone help me how could I read each message and process it, File looks like...

Thanks a Lot! This worked....Appreciate your Help!

Thank you both, travs69 - I'm using use strict in the script,This is the just Insert part in the script which I mentioned above. dkyrtata - Sorry ,I Just started working on PERL,So how could I check return code in the script? Thanks,

Hi, I'm trying to check whether my insert statement executes successfully or not,Depending on this I'm using the counter,Below is the insert statement from my script, $sql_Insert = qq {INSERT INTO TABLE VALUES(A,B,C,D)}; $sth_Insert = $dbconnection -> prepare ($sql_Insert) || die print...

Thanks for the reply! Yes condition X=X provided as generic. All the three fields have values and select query is returning all the three but I could not able to read all the three values,$query_result is returning only one value i.e first field. Thanks,

Hi, Could someone help me on how to get the values from sql query,Below is the query i'm using to get 3 values and trying to use later but I'm getting only one value from the query,Below is the query which I'm using in my script. $sql = qq {SELECT FieldA,FieldB,FieldC FROM TABLE Where X=X }...

Below are the couple records from the flat file 123456789,2010-12-03,perl,yes,2010-10-10 13:12:45 ,2010-12-03,perl,no,2010-10-10 13:12:45 Field: Above you can see First field is empty,I need to check whether that field is blank or not,If it is blank I need to do some check. Date...

Hi, Q1. How to check whether field is empty or not. Q2. How to check the Date which I received in my file is valid date or not. Thanks,