DSXchange

Searching the forum will yield at least three solutions.

An Excel worksheet is a table, as presented by the Excel ODBC driver.

Welcome aboard. :D What precisely do you want to review? One of the services my business offers is a DataStage health check - reading this may help you on your way. Estimation is first and foremost a function of the skills and competence of the DataStage developer. I'm quick, a tyro is not so quick....

Earlier in this thread I warned "Beware that ten instances of a parallel job is quite likely to swamp your server with demand for resources." After that it's simple economics. You have a finite supply of resources and an excessive demand for resources. Provide more resources (all of extra CPU, extra...

Yes, but AMZN_PREP_DESC_T has only 16 characters (making it legal), whereas ACTIVITY_BOX_REQUIRED contains 21 characters (illegal).

I have seen master job sequences with this many and more. There is no theoretical limit to the number of job parameters than may exist in a job or job sequence. If there is a practical limit, it is running out of memory to store the lists of names, default values, prompt texts and so on. Thousands, ...

Plural of WC ?

On second thoughts, don't go there.

You can create a self-generating artifical key as follows. It's the DEFAULT NEXT AVAILABLE clause that does the trick.

Sounds like the REDEFINES for a type "H" record is inexact in the metadata. Get that fixed and all should be well.

I am surprised by your assertion that this works in DataStage. It returns different number of columns for different cases, which can not match your metadata. You must have been lucky and only had case values that caused all rows to correspond to your metadata, or you have not checked for rejected ro...

Why not StringToDate(DateToString()) with appropriate format strings for each function? But, of course, once it's a date again, the internal representation is the same as when it started. So what you claim to want to do will be a complete waste of time. The format string only relates to when the dat...

What is the source of these times? Does your operating system even support beyond milliseconds in system calls for time? The behaviour you are seeing suggests not.

Actually, it is what you were asking for. Specifically, the automation part he mentions. ... sorry, guys, i am not convinced. and i am not willing to buy into something that has no proven its value to me. thanks for trying. That's OK, it's a free country, or so they tell us. DSD.RUN is only for ser...

Welcome aboard. :D

It's not the right forum; this forum is for feedback about the site itself. Would you mind re-posting on the Parallel Extender forum? You can copy and paste the actual text. May I suggest "Arithmetic with Modify Stage?" as a suitable topic?

For less than $1/week you can be a premium member. My earlier answer shows a manual approach using Director, then a suggestion for how to automate that process. Even that ought to be work this week's $1.

Click on the Server tab in the Edit Column Meta Data dialog, and fill in the Padding character there.