DSXchange

That's an Oracle 'type 12' which means DATE. If the field was null the function would return the word 'NULL' rather than those hex zeroes. I'm not really sure what to make of this one.

The Power of Search can help! Search for "ParamValue/Limitvalue is not appropriate" and all will be revealed.

In other words, with the exception of (apparently) being able to type the word 'OTHERWISE' in the constraint, it works exactly the same as a Server reject link. Positional, logging, the whole nine yeards.

Isn't that just the placeholder for the sign the viewer adds?

That would be a job for Excel code, not an ETL tool.

Great, thanks for the clarification. Does it still function as the Server 'reject' does where it is positional, meaning it fires if the links above it haven't? Or is it a true 'otherwise' constraint?

In other words, it's a bad idea.

ArndW wrote:No, only rows that don't go down any other links will go down an "Otherwise".

Is this something new in 8.x or PX? An 'otherwise' constraint?

Sorry, but for some silly reason I thought you meant an 'Otherwise' trigger in a Sequence job and were using the word 'constraint' in a more generic manner. Let's start over. There is no such thing as an 'OTHERWISE' constraint. An empty constraint means the link is not constrained and accepts all ro...

Catch all. It 'fires' only if none of the other triggers fire.

Yes.

What happens if you dump that column? I'd be curious what's actually in there rather than what to_char pulls out. select item_pur_dt, quantity, dump(item_pur_dt,16) from <target_table_name> where item_id = 1 and item_seq_no = 2 That will give us the data type, length and hexidecimal contents...

That would explain why it doesn't work.

As Nike would say - Just do it. Use #spath#/filename or #spath#/#sfilename# if the filename is parameterised as well.

Then you cannot store it in an Oracle DATE as they require a full date. If you literally just want to store 'MMYY' you'd need a CHAR or VARCHAR2 field for that, otherwise you will need to add a 'day' to the date before formatting it for Oracle. After that, people can choose not to extract the day wh...