DSXchange

"Another user" in this context can even be another Designer or Manager client opened from the same PC; they run separate agent processes on the DataStage server. It may also be that there is a monitor open on the job, but this information is included in the message. Most usually, however, the other ...

All of what Ken said and more! Don't forget to gaze into your crystal ball and look to the future. What if your company acquires another, and that other company is not using Oracle? Or what if you need the capability to exchange metadata with CASE tools and/or business intelligence tools? Would you ...

Most operating systems have some form of remote execution (rexec) or remote shell (rsh, but beware that this may also be "restricted shell") or other method of causing remote execution. On Windows platforms you can use AT and specify the other machine name. You then don't need dsjob or any other Dat...

You won't ever be able to select them unless they're visible from the server (for example via SAMBA). You can, as ariear suggests, access them via an FTP stage for example, but won't be able to import the "table definitions" unless you copy them to the server. Ray Wurlod Education and Consulting Ser...

What kind of stage is t3xfmAudit_DIM? If it's a Transformer stage, what kind of stage is connected to its output link?

Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518

Once you reach this point where the DataStage job hangs, can you execute the SELECT statement from PL/SQL or TOAD? This will help to isolate the problem to Oracle or DataStage.

Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518

Assuming that the file is created with 64-bit pointers, so that the 2GB limit caused by 32-bit pointers does not come into play, there will be no warnings because there will be no integrity problems, only efficiency problems. If a static hashed file has more data in it than the allocated number of g...

In UNIX it's cat, in Windows it's either type or copy. Before the job runs, execute this command (perhaps through a before-job subroutine invoking ExecDOS): type file1 file2 > file3 Then your job processes file3, which contains all the rows from file1 and file2. If file1 and file2 have header rows, ...

You can use -1 with Replace function, and your syntax seems to be OK. REPLACE (expression [, field# [, value# [, subvalue#]]] ; replacement) If you're saying there's a syntax error merely because the expression editor leaves the expression red, this is because the Replace function is not in the DSPa...

That's exactly what DataStage mainframe jobs do. On the DataStage server you generate the COBOL, and the JCL to compile and run it, then upload same to the mainframe. The most difficult part is the politics of getting permission to compile and run on the mainframe machines; their guardians are (prop...

"Any day now" has been the reponse from marketing for the past month!

I'd suggest you post this to the Parallel Extender forum on DataStageXChange (www.datastagexchange.com), where people who use PX lurk and may be able to provide good responses. Only some of them lurk here as well. [:)]

Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518

This isn't so much an issue of maximum length as of precision. The default precision in DataStage is configurable up to 57 digits, but defaults to 14. You can use the Compare() function or the string math SSub() function to do unlimited-precision comparisons. Ray Wurlod Education and Consulting Serv...

The ORABULK stage is written in DataStage BASIC. In a WRITESEQ or WEOFSEQ statement the ON ERROR clause is taken when some form of fatal error (e.g. file not open, disk full, disk crashed, etc.) occurs. Has the file system to which you're writing the file become full? Become corrupted? Ray Wurlod Ed...

Use HTML tags & L T ; and & G T ; (omitting internal spaces) for these characters (< and >). You already use <pre> and </pre> (I also use <big> and </big> for one increment in font size, <i> and </i> for italic, and <strong> and </strong> for bold). Ray Wurlod Education and Consult...