DSXchange

I wouldn't consider that as "successful completion" but that's just me. Please to ignore the intrusion, we now return you to your regularly scheduled conversation...

Early. Misremembered. Edited.

Server forum, Server post, PX advise. Hence the comment.

syeed wrote:Other Simple Way would be have a remove duplicate stage Sort data based on first by field01 and field02(descending) and Remove duplicate key as field01 with Retain=First Record.

Don't you mean "?????". Fixed width, after all.

Sounds like you have the grants you need to see the index, but not enough to drop / rebuild it. Check with your DBA, show them the ORA error.

That's what pretty much any software company on the planet does. Still, made me chuckle.

attu wrote:...and bugs.

Still need to answer the question. And if "od" doesn't mean much, you can google for "free windows hex editors" and take your pick.

Yes, you would need Perl. Does Google not work for you? Searching for "perl windows" should do the trick.

So - under what circumstances would you not find a file there after successful completion of the FTP job?

Ugh. Use DataStage to run command line ftp for this... or "just a huge size varchar column".

No, no threats there. That WFF step seems superfluous to me, but whatever.

Four steps actually.

4. Learn patience.

Then time to mark as Resolved with the big button at the top of the page.

No, it's not. The hashed file is created with the name you specified and another file is created with the "D_" prefix: the "dictionary" file that holds the metadata.

This is nothing you need to worry about nor "disable".