DSXchange

Make sure that the name of the remote machine is mapped (in the /etc/hosts file) and use the name, rather than the IP address. FTP can sometimes be finicky about these things. It can sometimes also object to the password being redirected. If you can't get that to work, create a shell script to perfo...

Hearsay is not admitted as evidence in courts in most countries of the world. There has recently been a distressing (to me) tendency to introduce a thread with "I have heard a rumour that..." and inviting replies. Be advised that I shall no longer be reponding to such posts unless some verifiable ev...

...which is pretty much what DSExecute does.

Kim's reasoning probably has to do with the stripping of quote characters. But he didn't say.

You can establish the name of the job controller (the job sequence that is controlling this one) and attach to that, but why would you want to? Anything you can do with that job handle you could do in the parent job sequence itself.

Derive the value in your routine, return it to the calling job, and use a stage type (OCI or ODBC) to insert row into Oracle table.

You've spent all that money on GUI software so that you can write your own ETL code? I don't think so.

To re-word Craig's answer, there are no data types within DataStage server jobs. Thus data type conversion appears to be automatic. If you have a string containing a date, that's fine. If you have extracted a date from a database table, it may be a character string or it may be an internal date; it ...

I see only one DSAttachJob call, and no DSDetachJob call. Did you create this as a transform function or as a before/after subroutine? I assume, because you've assigned a value to the variable called Ans, that it is the former. You have performed a 'D' conversion on a time. You should use 'MT' for t...

That's because there's not much to say. An activity that is checkpointed will be skipped next time the job sequence is run if there remain any checkpoints in the job sequence (that is, the entire job sequence did not complete successfully). If any activity must be run every time the job sequence is ...

The database is objecting to EDWAPP.T_PARTY_ADDRESS - the error message is telling you that WAPP.T_PARTY_ADDRESS is a legal identifier. Please verify that you are using a schema.table combination that is valid. (I need to add that the routine is working correctly, being able to report this error. )

Can you see the performance statistics inside the container, if you open it from the job design?

I have seen this limit on Solaris; max 32K subdirectories in a directory. In that case it was also the VERSION project (for Version Control); we got around it by converting dynamic hashed files (directories) into static hashed files (O/S files). Given that each version of each job creates dynamic ha...

There is something in one of the manuals about these kinds of characters - I've read it quite recently. (As is usual on Saturdays I'm logged in from an airport lounge and can't check the details.) It may have been for DB2 stage. It may have been for parallel jobs. Open the Server Job Devloper's Guid...

Please post your design documentation and, if you can, your code.

What you are trying to do is possible, but perhaps not sensible. What kind of routine are you using, and from where are you invoking it?

Comment must be a separate statement. See CASE @TRUE line. code = trim(code) begin case case code = 'X' Ans = 1 case code = 'Y' Ans = 2 case code = 'Z' Ans = 3 case @true ; * (If any other value apperas for code) Ans = @null DSLogWarn("Unexpected code appeared":code,&qu...

Only if the account rep includes it. With some you have to ask for it to be included.

But you can always enrol (and pay) separately to the software purchase price.