DSXchange

Just to highlight the problem:

The license for the Evaluation version of IBM XL C/C++ for AIX V12.1 compiler product has expired.

I'm not sure how helpful it would be to bury information like this in a long post which will scroll off the first page and into possible oblivion once people stop adding to it. Now, if someone wants to put something together on the subject for a FAQ post, that would be helpful.

If you have no DB2 experience or DBAs in your organizations, there's no way you should be considering using DB2 as your repository. In my opinion. 1) And yet you will need to support this RDBMS. 2) Easier for support requests? No. Oracle is fully supported. 3) Yes it can. Existing Oracle can be used...

Which part is unclear? Build the output record yourself. Leave out the zero values. Write it out as one long string. Ask specific questions if you still need help.

That would be a question for your official support provider.

That version is that odd duck release that runs Parallel jobs on Windows. Did manage to find this pdf so it looks like the answer is yes.

(see previous answer)

Write the output record as one string field and craft it in a transformer from the appropriate source columns. Concatenate them together with the appropriate field delimiter between them.

Maybe the Netezza stage has a higher level of metadata validation than the ODBC stage. Doesn't every other stage? I seem to recall that ODBC was the only stage that didn't seem to care if you bound all of the columns into the SQL or not. Comes in handy sometimes (a trick Ernie taught me back in the...

We know. But there's plenty of information you can see, didn't any of it help? Let us know if you still have any specific questions... and I'm still wondering why your subject says "Invalid Time" and then you asked how to validate a date. Are you actually wondering how to validate a timest...

Let's get you into the proper forum... not really a "FAQ Discussion" post.

FYI - I walked into a hormet's nest of production issues this morning and am still pulling out stingers. Anyone who wants to chip in, please be my guest.

kcho69 wrote:I can insert the code written in the 'Job Control' tab but I'm afraid this will bring more confusion.

It won't... but I'll leave that up to you. Most of us here have written a crap-ton of job control code over the years.

The Server documentation for 8.5 has a section on this stage. And yes, from what I recall you must specify each element as ascending or descending, with each having 3 possible values depending on how much you feel like typing:

a asc ascending
d dsc descending

The only thing that 'bothered' me was the lack of proper information - but that doesn't mean we should just give up. Let's take a step back and try again, shall we? Can you post the actual unedited code you are using to call JobB? Or at least clarify exactly how it is being done? Can you try clickin...