DSXchange

What have you tried so far... anything? Always best to mention that, so we don't go through iterations of 'no, I already tried that'. Best Practice is to get (or create) an xsd for the XML you will be working with. You can then import the metadata from that xsd and it will create the XPath Expressio...

You have to use a Transaction Size of 0 so commits are only done once at end-of-job. You then need to ensure the job aborts in order to force a rollback. Finishing Ok or with Warnings will commit any non-rejected rows. You can then use a reject link, set to abort after '1 rows', to abort the job whe...

kduke wrote:I got passed by 2B and Kumar. Get left in the dust.

You can't help it if you have a life, Kim.

Kumar - on my HPUX cdrom there is a packages directory and then the various plug-in folders under that. So for OCI: \packages\oci9\hp \packages\oci9\hp\oci9.dsp \packages\oci9\hp\dstage \packages\oci9\hp\dstage\oraoci9.enu \packages\oci9\hp\dstage\oraoci9.jpn \packages\oci9\hp\dstage\oraoci9.sl So y...

If I set my 'key_expression' as: My_Customer_Number OR Your_Customer_Number OR Our_Customer_Number Not even close to a valid Key Expression. An expression like this will resolve to one of two values: TRUE or FALSE. A zero or a one. You can conditionally supply one of the three values to the field v...

Well the problem here is among the two fields that i'm comparing , they happen to be the same field in the oracle table . thats why i tried making them as PROM_FROM1 and PROM_FROM2. is that a problem and if so how do i give this query Of course that's a problem, you can't just make up field names. ...

Yes, and each and every one a quality post.

I don't know about candy, but you're almost at the 20K point level where you can finally get that pony you've always wanted.

Keep track of the filenames processed, then just delete those. Or sweep the 100 out into a 'processing' directory first so the arrival of other files isn't an issue.

When you say you "need V-8" from that example field, what exactly do you mean? You need the last 'word' from the string? The sixth 'word'? The last three characters? Be more specific, please.

Sequence jobs are used to control looping thru a set of jobs not records. All DataStage jobs perform row-based processing, one record basically goes from beginning to end before the next starts the trip, hence the confusion with your question. Can you clarify your need? What exactly are you trying t...

A check digit, in other words. Best to do that in C, I would think...

You could still move it to a Stage Variable so it doesn't get resolved on every row.

In a nutshell - Ditch the routine. Create a job to select the value and store it somewhere - could be a file, USERSTATUS, whatever. Then retrieve it and pass as a parameter to your job or retrieve from inside your job. Increment from there. The USERSTATUS method has been discussed here ad nauseum, a...

I'd suggest a routine to get the value of an environment variable and then call it in a Stage Variable's initial value. Then use that stage variable in the transformer. This way it only gets resolved once.

Pass in the variable name as a parameter. Echo and capture it.

Assuming you are using the 'dsjob' command, you need to look into the -lognewest option. A search will reveal many conversations on this topic.