DSXchange

In other words, you can't do what you want from 'before job'.

Those are O/S commands, so you'd need a routine via a Routine Activity stage to execute them.

Well, I told you what was missing to allow the function to compile and run, never said it would accomplish what you needed. Perhaps this would be more appropriate... Index(Convert(",",@FM,"Word01,Word02,Word03,Word04"),ds1.field,1) You'd obviously need to do the c...

Try what in 7.x, clearing from the Status view? It works fine, you just need to be patient. I prefer using CLEAR.FILE though and (yes) then re-establishing the auto-purge settings. So perhaps Zet's issue is 8.x related. Again, people are thrashing without any further input from the OP. Why not wait ...

My question is actually; is the array problem caused by: - the stage being inserted/updated into, or - the stage used as reject, or - both? As I tried to explain above - "the stage being inserted/updated into". I was somehow hoping that when using a sequential file for rejects we are on the safe si...

You need to use 'code' tags to preserve spaces - your example made zero sense until I looked at what you originally posted. hi, when i add other fields to the multiple lines question the format seems to go wrong, any ideas. i.e. col1,col2 1, aaaaabbbbb which i want to be 1 aaaaa bbbbb ends up as 1 a...

Is your post related to this one?

http://www.dsxchange.com/viewtopic.php?t=116763

If not, that's one heck of a coincidence.

In other words, you can look in whichever Developer's Guide floats yer boat, you'll find the same information in both.

All one 'word':

/ *+ NOAPPEND */

Check the help, the Index function requires three arguments - you are missing the instance or occurance number to look for.

I didn't offer up any advice of this nature because the OP said the problem occurred with any a.k.a every log, not one specific one.

Check this FAQ posting: http://www.dsxchange.com/viewtopic.php?t=88639

You can write out a single 'record' with record delimiters in all the right places such that, when the records are read back in, they break up into the pieces that you need.

No.

I've always used flat files to capture rejects. Doesn't matter where you write them to, it matters what you are capturing them from. Are we still talking Oracle from an OCI stage here? If so, what versions of everything: DataStage, Oracle database, Oracle client? Specifically what I saw: take an arr...

Before posting, I was sitting here trying to think how one would use it for something other than assignments and couldn't come up with anything.