DSXchange

Sure... I've helped build systems where 100s of jobs were generated from a template using source/target metadata to drive it. It's not something to take lightly and we had plenty of time to work all of the kinks out. Unless you're comfortable with generating dsx code on the fly, you'd more than like...

Short answer? Not possible. Too many specifics for anything a single 'generic' job could handle. And RCP is out the window.

How many tables are you talking about?

Have you looked into the IsValid function? You would bring your values in as a string and then use the function to decide what to do with it. Invalid? Reject. Valid? Convert to the proper data type.

There should be the same set of documents out there on IBM's site for each release... or at least every major one. You should be able to just move up the URL and then back down the 9.x branch. Or search there. Yup, easy peasy. http://www-01.ibm.com/support/knowledgecenter/SSZJPZ_9.1.0/com.ibm.swg.im...

And... done! Don't know when exactly but just noticed.

OK, well past time I split this out to your own thread. If anyone is curious, the original is here.

Perhaps you should look up the version of that document that matches the version of your software?

Looks like a vertical pivot to me of rows to columns. What have you tried?

Cool. Pretty much any question you have has been asked and answered over the many years we've been here.

Ray posted a white paper that might help. Best to take a class if you can... there are so many other things you'll need to learn and become familiar with before you need to start worrying about things like how many processes a job creates. IMHO. As to the differences between SMP and MPP plus how tha...

Keep in mind the fact that any "ASCII translation" of packed fields will destroy them. Years ago we used a utility that allowed you to define the character positions that needed translation during the transfer so you could skip over anything packed. Nowadays it seems that people either bui...

Let's play... all from scratch off the top of my head so your mileage may vary. End Date: last day of previous month. I like your method but let's try this: ErrCode = DSSetParam(hJob3,"EndDate",OCONV(@DATE-@DAY,"D/MDY[2,2,2]")) Start Date: first day of previous month. ErrCode = D...

Sorry and hate to say it but these kind of questions are not ones that I prefer to answer. It's not about a specific problem someone is having but rather what seem like interview questions or someone farming for an interview answer site... especially when it's a first post. Never mind that these top...

If you are worried about its behavior around year-end, test it with those numbers. Do an IConv of the dates you're worried about and capture the result. Replace @DATE with those values, test.

Looks a bit... overly complex... is that actually working for you? I ask because you are doing string math, subtracting a string like "31" (today's day number) from an internal integer date. Server is pretty forgiving of such things but it's not really a best practice. Got no time for a pr...

Been there, done that, got the t-shirt. Both t-shirts, actually.