DSXchange

Why?

How often do you rename jobs?

The only "solution" is to have fewer jobs in a project. Consider using more than one project.

Please mark this thread as Resolved using the green button at top.

It's done because Oracle is unusual - every other database has essentially compatible standards (SQL CAE Access Group standards). DataStage also complies with these standards, so has to translate where necessary. Sometimes it doesn't get it right, but I blame Oracle for that. If you create a column ...

Get into TCL (dssh) or Administrator client Command window for the project. If this returns 0 records there is no VOC entry.

HEY WILL u be able to send me this process in private message as i am not premium customer...so am not able to view your full reply... Premium membership is one of the ways that hosting and bandwidth costs incurred by DSXchange are funded. I do not intend to prejudice this arrangement by bypassing ...

Can plz post your reply again.I can only read first 2 lines and it shows premium content. Premium membership is one of the ways that hosting and bandwidth costs incurred by DSXchange are funded. I do not intend to prejudice this arrangement by bypassing it. Premium membership is not expensive, at l...

The Sort stage has more options.

More specification needed. For example what determines which part of record 1 makes it into the output? The rest of the answer will probably involve a mix of Index() and Field() functions. The expression is likely to be somewhat complex so you might like to decompose the logic's intermediate results...

If you don't have a VOC entry, then rm -rf /path/name/*HF_CDPROVSTATETP is the appropriate method. As Craig noted, if you have a VOC entry, then things are different, and will also depend on whether the hashed file was created as a UniVerse table (in which case use DROP TABLE) or as a regular hashed...

The obvious question to ask is WHY aren't you standardizing?

Matching works so much better when you have blocking fields (like NYSIIS) that take "fuzziness" into account - then you specify the actual fields with an appropriate level of uncertainty.

That said, if you specify in the metadata that there are specific data types, these will be enforced. The usual 12 data types in DataStage are available, some with extended properties.

Exactly? They are directories in operating system file systems (perhaps on storage array networks (SANs) or similar). As its name implies, scratchdisk should contain nothing except while jobs are running and whose operators need more memory than they have bene allocated. The disk resource is used fo...

Performance tip: initialize a stage variable, say svTAB, to Char(9). That way the function is only evaluated once.

Possibly. More important is that you will need to install the 64-bit WebSphere Application Server (6.1.0.27).