Search results for query: *

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,

We receive four files with following naming convention, My task is to read these four files from the same directory and process them through my script, Filenames: ABCD_CLIENT_20101203.csv EFGH_CLIENT_20101203.csv IJKL_CLIENT_20101203.csv MNOP_CLIENT_20101203.csv Q1. Issue is I have to read...

Good Morning all, I'm a beginner in perl script,I wrote a script and wanted each and every failure/success points to be logged in a log file.Could somebody help me on how to log everything in a logfile. Thanks in advance! Thanks, V

Hi, How can I check whether Date of birth which I have is valid,I need to check the following, DOB – should be valid date and less than current date DOB format - 1970/12/11 similarly for Date time stamp TIMESTAMP – should be valid date and time and less then current timestamp Thanks, V

Thanks for the reply,Below is the part of the script I'm using in PERL, In this script,Using sql query I'm pulling the values B_ID,B_NUM,B_DT and B_LAST_NAM. My question is How to read above values from the query and use it in our condition (As shown below),Could you please let me know how can...

Hi, My sample script; Select A,B,C from Table...doing database connection and getting query results. If (defined $query_results), than checking A from database = A from file,B from DB = B from file, than do....something Else ,Do something else. In the above script, Q1: How do I check...

Hi, I have a map with two input cards,Input1 has "n" records and input2 has "n" records and In the mapping I'm using functional map with input1 & input2 has parameters and the output I'm getting is n*n records,My question is How can I do mapping to get only "n" records in output instead of n*n...