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 Chriss Miller 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: *

  • Users: Stella001
  • Content: Threads
  • Order by date
  1. Stella001

    Sterling Integrator Version 6.2

    I have been having an issue when creating a new map. On the outbound side when I edit the properties under the delimeter tab I have element delimeter set to an "|" (pipe). I also check the box that states always output trailing element delimeter for elements with data. However when I run my...
  2. Stella001

    Parsing out an address

    I am using Sterling version 6.2. I have a address field that looks like this: 11248 west st|anytown MD 12345 I need to parse out the address before the | and map to one field and the address information after the | and map to another field. would appreciate some assistnace with this if...
  3. Stella001

    Number to text field

    I have a number field for my inbound ( 110450000 ). I have to put this into a text field according to my customer but they want it in a number format ( 110.45 ) My inbound number field has an assumed decimal place of 6. any help would be greatly appreciated. :)
  4. Stella001

    Stored Procedure

    I need a stored procedure to run only to update a table that I am using for input. I have been reading on how to do this with my map and I am not making much headway. Any assistance would be greatly appreciated.
  5. Stella001

    Having a memory error

    I am using Datastage TX 7.5 I have an input field of; NAME / ADDRESS For my first output I need everything left of the / , and of course for my next element output I need everything right of the /. I know I have done this rule before but I am not at my normal computer and can't lookup any of...
  6. Stella001

    Emanio Unite

    Has anyone been approached by or heard of Emanio Unite. This is suppose to be another mapping program option since mercator is no longer supported. Just curious if anyone has seen it or used it.
  7. Stella001

    sorting data

    Let me see if I can explain my request. I have a multiple group of records. Each record set consist of header info, detail info and summary info. There is a date in the header information. When I extract these records from my system they are not in any kind of data order. Is there a way...
  8. Stella001

    Mercator version 7.5

    We are running version 7.5 on windows 2000. My manager wants me to load this onto our VISTA machine. From my understanding 7.5 is not going to work on Vista. Please let me know if I am correct or not.
  9. Stella001

    DBLOOKUP Question

    I am having problems with the query below. I need to pass in thw two elements of SCHED_NO and SHIPMT_NO in order for me to get back the correct information. This is not working the way I am passing them. Any help would be appreciated. =EITHER( DBLOOKUP( "Select olsi.inst_txt from...
  10. Stella001

    comparing files

    Has anyone ever used WTX for comparing files? I want to take two files, each with their own input card, and make a comparison of the two files and have the output only show the differences.
  11. Stella001

    mapping a floating NTE segment

    I know this is old school and it has been a long time since I have had to map and NTE segment in version 3020. does anyone remember how to map a floating segment?
  12. Stella001

    Trading Partner (Emanio 6.8)

    Has anyone ever worked with or are currenly using report writter with trading partner?
  13. Stella001

    brain fog question

    I am using mercator version 7.5 I have a customer sending me a number ( ex 999 ). I need to load this into a text field making it a decimal ( ex 9.99 ) . I know this is probably an very easy question but for some reason my brain is fogged over this morning.
  14. Stella001

    1 SYNC

    Have any of you vendors out there had to deal with 1SYNC / Ontuet for you product catalog and if so are you having any issues?
  15. Stella001

    Vista and Datastage TX

    Has anyone had or heard of any problems with Datastage TX 7.5 loaded onto VISTA?
  16. Stella001

    Run map question

    Here is my question. I am running mercator 7.5. I have a map with one input and two outputs cards. My first output is creating a simple text file that I want to use in my second map that I am kicking off in the second output card using the run function. What is happening is the file is not...
  17. Stella001

    DDEQUERY

    Can you combine the DDEQUERY with the GETANDSET function? Here is my rule now: =DDEQUERY( "TPPC", COMPANY_NAME, "UNBControlReference" ) What I need to do is not only pull the control number I need to update it to the next number after it is pulled. I've tried many ways but none will analyze.
  18. Stella001

    Need to Upgrade to version 5010

    We are currently using Mercator 6.7 We have a customer that is requiring us to upgrade to version 5010. Can someone tell me what version of Mercator we will need to upgrade to in order to obtain the 5010 type trees?

Part and Inventory Search

Back
Top