Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by venkatpavan

  1. venkatpavan

    MQ Error Message not available (rc=2033, event=1)

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

    WTX IBM MQ trace log Append

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

    Exponential numbers eg,3E-05,2e-06

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

    Create Empty file thru RUN map if data no content

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

    Type tree reading

    Thanks guys! Let me try...
  6. venkatpavan

    Type tree reading

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

    Insert execution check

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

    Insert execution check

    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,
  9. venkatpavan

    Insert execution check

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

    Database Query Values

    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,
  11. venkatpavan

    Database Query Values

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

    empty field check

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

    empty field check

    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,
  14. venkatpavan

    Reading Filename

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

Part and Inventory Search

Back
Top