DSXchange

Curious... does this file come from a Windows system? If you view the file in vi and ":set list" does a ^M show up at the end of each line? If so, ensure the file is transferred to your UNIX server via an ASCII transfer to eliminate those as an issue.

You might need to translate this into PX, but EReplace or Convert can do that for you:


Would replace each CR with an empty string, in essence removing it.

There must be something you're not telling us, everything you've posted should be working fine. Can you perhaps post some screen prints of the job and the triggers? We do these kind of things 'all the time' and really haven't had any issues getting them to work. You should also consider contacting S...

gsym wrote:I 'm using the TFR TRIM function but to no avail.

You might want to explain what this means. It looks like you may be picking up a <CR> in the artist element - do that mean you are trying to remove it? Post your derivation.

Sure... just don't run them at the same time unless it is a multi-instance job. Drag the job onto the Sequence job canvas several times, link them together in a serial fashion and then tweak the parameters as needed. Easy Peasy.

Me, I'd create a table with the three values in my database of choice, load the input file into another and then extract from that database letting the sql do a cartesian product.

Start your own thread, don't jump on the end of someone else's. That way we know your particulars. Do a better job of explaining what your job looks like in this new thread and what you are actually seeing or not seeing. For example, do you get no file whatsoever or only an empty output file? What ...

What's incorrect about the information you found there?

The question is - what client are you using? The OCI8 stage should be using an 8i client to connect to your 10g database to minimize issues. Better yet, switch to the OCI9 stage and a 9i client. Better yet, upgrage to 7.5.x which actually supports 10g. From what I recall, there is a utility on the c...

Did you read the post I linked to? Did you try everything noted there, including setting APT_IMPORT_PATTERN_USES_FILESET to TRUE?

So there's nothing wrong with what your script is outputting and your triggers as posted should work fine, as long as you straighten out the '0' versus '1' versus '2' issue.

Post your trigger code. Again, do not hand type them - open the Execute Command stage and copy/paste both values here.

Suggest you reinstall your client software, see if that clears things up.

Start over. This isn't rocket science so should be pretty easy to straighten out. Your script is fine. I build it here and put it through its paces and it outputs a 0 or a 1 appropriately, so there's nothing wrong there. Its Return Code will always be zero which is why you have to check the 'output'...

Also known as the 'Description' field.

Doh!