DSXchange

We prefer to avoid the "double action" methods replace (= delete then insert), insert or update, update or insert; for performance reasons.

This has been discussed many times. Searching the forum will answer your question. So will consulting the on-line help for the stage types in question.

Did you search the forum? What did you turn up? This post for example may prove informative.

Unless you can reproduce it reliably it will be a very hard one to track down. DSR.RECORD is a "helper subroutine" that moves a record between the client and the server. So one record (it could be one stage or even one end of a link, one routine, one table definition) may not be successfully importe...

You can do this in a BASIC Transformer stage using the following derivation expression. Oconv(Iconv(Left(InLink.TheTimestamp,10),"DYMD")+3,"D-YMD[4,2,2]"):Right(InLink.TheTimestamp,9) Otherwise you need to read the timestamp as a string, pick the p...

For most databases, load can only add new rows, not update existing ones. Best practice is to split your stream into rows that are new (which you can load) and rows that already exist (which you must update).

Welcome aboard! :D

Do learn to search the forum, you're not the first to have had this question.

The link variable LASTERR gives the error message text generated by the database server, client software or ODBC driver (as relevant).

Welcome aboard! :D

Has the other user ID been granted CONNECT and the requisite table privileges in DB2? In particular, to import table definitions the user requires SELECT privilege to a number of system tables (search the forum to find out which ones, and ask your DBA).

And what happens then? Does that fix the problem, or are you explaining that that's how you implement the Wrapped stage in your design?

That's weird! Have you provided a reproducible case to support? What's the data type of the return value?

SELECT COUNT(*)... should always return a row, so the lookup "succeeds"; how does it come to be null?!!

Are there any errors or warnings logged?

Welcome aboard! :D What value is returned into StageName2 by the DSGetLinkInfo function? It's my understanding that the StageName argument must be that of an active stage (not a passive stage); that is, one of the stage names returned by DSGetJobInfo(HJob, DSJ.STAGELIST). Is this the case in your co...

Some of the duplicates arise because more than one headhunter is bidding for the same gig. But there truly are lots of opportunities in Australia at the moment. Particularly for anyone with ten years experience in PX.

It's the number of rows of data values sent at a time to the database server by DataStage. It should be a multiple of the "rows per transaction" figure, for efficiency. You can find out more by searching on this forum.

Many of the gurus do it in job control code because we're still around from the days before job sequences, when it was the only way. Job sequences were quite limited when they first appeared, but now (7.5) seem to have most, if not all, of the constructs necessary, so most of us are coming around to...

Surely "they" (who have access to the full source code) can find out? Any joy on ADN? Does looking at the source code in Server Job Developer's Guide (Appendix A, if my memory serves me correctly) help?