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...
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...
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. :)
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.
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...
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.
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...
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.
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...
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.
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?
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.
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...
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.
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?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.