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!

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

Search results for query: *

  1. venkatpavan

    IBM WTX EXTRACT function

    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...
  2. 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...
  3. 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
  4. 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
  5. 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...
  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

    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...
  8. 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 }...
  9. 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,
  10. 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...
  11. venkatpavan

    Writing Log files

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

    valid Date of birth

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

    Perl Database question?

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

    Functional Map

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

    &quot;MAP FAILURE&quot;

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

    XML Validation error

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

    Get Function

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

    List command

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

    XML Error

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

    List of Sub Directories under directories

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

Part and Inventory Search

Back
Top