DSXchange

Any nulls in the record being inserted into not null column? Doubt it, given the size of the target table, but it's worth asking for next time someone is searching this topic.

Any too-large character strings (for example trying to insert "STRAWBERRY ICE CREAM" into a Char(12) column?

"what will you further step that you will do" sounds like an order for professional services? Are you willing to pay for the solution? You have not described your job sequence in sufficient detail to allow accurate diagnosis; the previous post is therefore at best a diagnostic suggestion. For exampl...

"pls solve my problem" sounds like an order for professional services? Are you willing to pay for the solution? You have not described your job in sufficient detail to allow accurate diagnosis; the previous posts are therefore at best diagnostic suggestions. For example what is your target? What tra...

If the target is a hashed file being accessed via a Hashed File stage, you do not get the insert/update choice. Every row is written to the hashed file; if the key already exists that record is destructively overwritten. If the target is accessed using an SQL-capable stage, you can differentiate bet...

What happened to the other rows? Were there any warnings logged about their being rejected by Oracle? Did you set up a rejects link to capture them? For so many rows, I'd counsel using bulk loader techniques. Array size is a function of row size (which you can calculate). It's how many rows' worth o...

The statement that a Transformer stage cannot handle as many as 84 columns will come as a surprise to those who are handling hundreds of columns through this stage type. No, your problem is elsewhere. Can you please post the exact and entire text of the error/warning message(s) associated with the j...

baabi_26 wrote:I thought CASE stmt can only be included in select list not as a part of your where clause. Am i wrong?

Depends which database you're using. You're right; most only allow it in the SELECT clause.

Triggers are executed in the order they are found in the grid, top to bottom. For some strange reason this grid control does not support dragging rows to new positions, which most of the other grids in DataStage do. All you can do is build the output links in the desired order of execution. And subm...

It can be done in a number of ways. BCI functions mimic the ODBC API (search for BCI) but you need a licensed ODBC driver. The routine can run a job that fetches the data from Oracle into, say, a text file then reads the value from there. Why do you believe you need a routine? Why not pre-load a has...

It doesn't really matter whether you have the database server perform the UNION or have DataStage perform it; the same amount of work has to be done. In DataStage I'd suggest processing two separate streams. Even though you didn't specify UNION ALL in your SQL (you only had UNION), you need to handl...

Need design opinions.

You haven't posted any design(s) on which we might opine.

Doing your design work for you, that's a different question, and involves money as part of the solution. You are seeking professional services.

Depends on your management style. Search the Internet for "Theory X and Theory Y".

Document the rules and procedures, and require compliance. Either explain the reasons to the developers or threaten them with consequences.

An ingenious solution, and one which highlights the fact that parameter values can not be changed within the job itself.
You might consider constructing a query with a CASE statement. Without wasting a lot of thought on that approach, I can already see that it would be messy.

Only by hacking the export file (remember to export default-valued properties) or hacking the repository directly.

ACCOUNT.FILE.STATS (not STATUS) as Arnd said. Preferred format is to capture information into a local STAT.FILE. The form of the command is: ACCOUNT.FILE.STATS ALL LOCAL It's not interactive, so you can run it as a background process. PHANTOM ACCOUNT.FILE.STATS ALL LOCAL ANALYZE.SHM from VOC is only...