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

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...

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...

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...

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 }...

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

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...

Hi, I'm getting following error when I'm trying to run the file(Huge file of 3GB). "MAP FAILED Not enough memory to execute map" I tried options like trace off,Page size/Setup chages and changing wworkspace from memory to file. Could someone have better ideas on this??? we are using WTX 8.2

Hi, I'm using WTX 8.2 version and trying to validate XML through XSD but receiving below error, <!-- Building the object model. --> <StatusMessage>XMLParser: Input XML data is invalid.</StatusMessage> <DetailedStatusMessage> Error (-1), "XMLParser: Error(s) occurred." SAXParseException, Error...

I'm using get function in the map rule to pull the messages from the queue but messages are not being deleted from the queue once it is pulled,Do we have a option to delete the messages once we pulled the messages.Please let me know.Command we are using in map rule is Get ("MQSC",-QMN,-QN)...

Hi All, There is a directory with lots of files in it,I want to list all the files without dot '.' in it.How could i do that,Please let me know.Below is the sample 12345678.999 111111111111 23456789.000 222222222222 I want the list files with out dot 111111111111 222222222222 Thanks in...

Hi, I'm getting following error in trace file when I'm trying to read XML file,Is this common error? External Parser returned Error: TYPE X'0002' (Error (-1), "XMLParser: Input XML data is invalid." SAXParseException, Fatal error [line: 2 column: 1] An exception occurred...

Hi, Could you please give me commands that lists all directories and sub directories in it and size of those. Eg: I have directory XXXX and YYYY,In XXXX i have sub directories AA and BB,In YYYY i have DD and FF.DO we have any command that lists all these directories and sub directories in that...

Hi, I'm a beginner on UNIX,So please forgive my Ignorance on this. I'm trying to split a file into batches,Big file which i want to split looks like below one 00 XX XX 99 00 XX XX 99 00 XX XX 99 00 XX XX 99 Each batch starts 00 and ends with 99 records,I want to split this big file into...