DSXchange

jdmiceli wrote:You could use a Sort Stage

Datastage TX?

So in the future if anyone reads this thread, my post will look like I'm typing jibberish.....again. For a second there I thought that YES sampled the quote from the movie. Actually this may sound good.... "Hello. My Name Is Inigo Montoya. You Killed My Father. Prepare to Die" <insert Old ...

I'll take the compliment that if I'm being strange, at some point, I must have come off as normal.







The quotes are from the same flick (Princess Bride). Did the group "YES" use them or something? YES was a bit before my time.

"Hello. My Name Is Inigo Montoya. You Killed My Father. Prepare to Die."

So wait...you're trying to get the time zone out of an input field, that doesn't have the time zone in it? You may get a date in this input field that is a few days old, and you want to include the "ZZ:ZZ? Or is it always the current date, like, whatever date is in that field, plus the current ...

So wait...you're trying to get the time zone out of an input field, that doesn't have the time zone in it? You may get a date in this input field that is a few days old, and you want to include the "ZZ:ZZ? Or is it always the current date, like, whatever date is in that field, plus the current ...

TODATETIME()

The TODATETIME function converts a text string of a specified format to a
date/time.

If you didn't want to create a lookup, which would work fine, and if more values come down the pike and you had created one, you can just add it to the look up, and not have to re-deploy, stop/start the system. Another way you could do it is using the SUBSTITUTE function, which will change any strin...

Procedural Note We don't do "urgent". But dude, he said "please." :wink: hi, Please upload X12 type tree, the XML schema equivilent, a mapping document that probably took you 2 months to do so I can put my name on it and show it to my boss, the mms you built from it, a map of Ve...

in map rule. =substitute(Country_Name Field:In1," ","") Big thanks to janhess for a qwick reply. THANKS!! You could always rate his post high and set the thread to "resolved" and give him a boost in points. Of course, this will put his farther ahead of me, but I like t...

I marked this as a work around, because it was a question about preference, not a direct technical question that can be resloved. I wanted to do this before it slid off into oblivion. If anyone has a strong opinion either way, please PM me, unless posting is still possible. Thanks to everyone who sh...

My shop is currently at DS TX 7.5 and Commerce Manager 7.6, using Oracle 9I. We are expecting an upgrade to Oracle 10I, in which Commerce Manager 7.6 is not compatible with, but Trading Manger 7.7 (The next upgrade from Commerce Manager 7.6) is. On top of that, we would also at the same time, like t...

I have found the solution. field that has extra comma as part of data should be in double quotes. In Type Designer, select property of the field, and go to TYPE SYNTAX and use initiator/terminator and value to be " (quotes). I tried, and it kept the comma as part of data. Yeah, well if you're ...

Street corner? No. That's Willy. And what he was handing out...for a price...would be very diffictult to scan and upload, plus, I'm not sharing any of that. :P Jim...Jim is the two year datastage guy that is in my group (development). I'm the guru! And while he is a swell guy, I would recommend meet...

Um...no.

Jim handed it out, hence, "Jim's hand out."


I don't have the softcopy, so if you really, really, really want one, I'll scan it and upload it.

But you're kidding, right?