Search results for query: *

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

No, that is not an option with this.

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

Thank you. Boy it's funny how easy that was but I was looking at it so hard the easy way just slipped right by. LOL

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

The stored procedure is already built, when it runs it updates my databse table with current information running checks and balances against other data that is already in my system. Then I have to use that database table as INPUT for my map. I was trying to find out if there was a way to kick...

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

Yes, Emanio did purchase all the Trading Partner assests and still own them. They have created this new product UNITE and I was just interested to see if anyone else has heard of it or possibly worked with it. Thank you for your response.

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.

Did you go with Mendelson? If yes, how is it working. We to are looking for a new AS2 program provider.

You say your map is version 5020 but the data states 4030. Don't know if your tree is set up to except mulitiple versions but you may check.

John Caparulo - This guy had me laughing though his whole show, will for sure go see him again!!

For us we usually receive the 820's on or after the terms date. I'm assuming after payment but that is not my department I am only going by when the invoice was sent and when we receive the 820.

Our trading partners pay us to and we do receive 820's all the time. The 820 is remittance advice on the invoice (810) you sent to them. The 820 will give you informtion like the invoice number they are paying on and how much they are paying on it and usually also the check number they are...

Thank you, I was affraid of that. To bad Mercator or IBM datastage does not have a SORTBY function. Maybe someday. Thanks again.

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.

thank you for the quick answers. Both ways actually worked.

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