DSXchange

The devno and inode columns in the list_readu report can be decoded from a map of such information gathered by regular monitoring with utilities such as ACCOUNT.FILE.STATS (that's the one that I use). This also contains the project (account) name if collected globally across all projects.

Once upon a time - I think it was in the Ardent days - "they" were gunna (I'm sure that's the word used) establish Centers of Excellence. What ever happened to that initiative? Yeah, OK, sure, whatever.

Yes, sir, that'll be five bags of smoke and two mirrors?

This really belongs on the server forum. The routine probably barfed at a 2GB limit - remember that DataStage is a 32-bit environment, so one must assume that a 32-bit number controls the offset address within a text file. You have mentioned in an earlier email that the Merge stage also does not cop...

How is the match to be performed? For the sake of example, let's assume only the key is to be matched. Optionally pre-load the target's keys into a hashed file. This is for performance, not functionality. Construct a job that reads the source, performs a lookup against the target, and writes to eith...

So you can FIX the next higher number (N + 1) surely? You might also like to investigate the rounding/truncating capabilities of the FMT function, and the OCONV function with MD conversion specification. Finally, you could write your own CEIL function as a user-defined Routine. Make sure that whatev...

Of course calling a server component will have performance issues; it runs only in a single process. There is a list of what you can and cannot do with shared containers that contain server components in the Parallel Job Developer's Guide.

Of course calling a server component will have performance issues; it runs only in a single process. There is a list of what you can and cannot do with shared containers that contain server components in the Parallel Job Developer's Guide.

As we say in this part of the world - ONYA!

(It's short for GOOD ONYA, but the first syllable is really redundant on a number of levels.)

Really need a praise emoticon. :praise:

I doubt that it's the same message for RowCount - which is never, could never, be a decimal number with more than zero decimal places.

Read the message carefully; it tells you what you've asked it to convert, and warns you about why it may be infeasible.

Welcome aboard! :D I do prefer to create my own control files, because I can then tune every little thing that I can to optimise the load. I do sometimes use the bulk load stage to generate a prototype; other times I don't. If I want to run the bulk loader under DataStage control, I use either ExecS...

Several. Search the forum for the terms I mentioned earlier. Which one you choose depends primarily on which one the various administrators will allow you to use. Search also (here and in your man pages) for terms like rlogin , rsh (or remsh ) and rexec . These man pages will explain what you need t...

And are they being passed accurately?

Check the child job's log entries to view the parameter values with which its run was requested.

Write the load script as a text file, then use ExecSH as an after-job subroutine, or DSExecute from within a custom after-job subroutine, to invoke the bulk load utility. You may need a technique such as remote execution or remote shell if the bulk loader command is on a different machine from your ...

There are only two things I can suggest beyond what has already been offered; really you need to be a detective on-site. Has your support provider been able to assist? One is to enable server side tracing, connect a client, wait till the connection is lost, then see if there is anything in the trace...

Use a Sequential File stage to generate the data file. Write your own bulk loader control script (or adapt the one produced by the BCP Load stage for use with SQL Server 2000). It's your call whether to invoke the bulk loader from DataStage or from an external scheduler.