DSXchange

Is "c:\folder\txt" the full path to a specific hashed file? You can't create a generic one at the directory level, each one needs a specific entry.

Crazy thought, but a search of the forums here for "dsdesign" would answer your question.

Containers are clearly documented in Chapter 5 of the Designer Guide pdf.

The convention here is one topic = one problem or question. Please don't string multiple unrelated questions into a single topic. Kindly give a new post for the flat file question. And please start doing a better job of chosing a more appropriate subject.

If you really need to use sql for these joins, you may end up needing to load the files into work/temp tables in an accessible database and perform them there.

Either provide more information about your job design or try searching for "found converting string" to see what others have done when faced with this.

You might want to explain exactly how you created it.

Then it's time to mark this as Resolved using the button at the top of the page.

Ok, that's what I was afraid of. DATE fields have no 'format', that only comes into play when you select them. Meaning, you can compare two DATE fields in internal format wthout any shenanigans, just like with DataStage internal dates. What I posted should work fine for you - the trunc() removes the...

So, claim_date - is it a VARCHAR2 or a DATE? If I take you at your word on the format and assume varchar, why not use a TO_DATE() on it rather than a TO_CHAR() on the sysdate?

Have you checked the documentation to see how to configure it and if it requires the Sybase client be loaded? Those errors make me think a) it does and b) you don't have it.

Yes, but not on this world.

Guess I was think'n that backwards. And I believe the SP stage requires at least one input parameter.

... and? Nothing there changes my answer.

If you've got a specific question, please ask it otherwise people will just have to guess as to what kind of information it is you are looking for.

First silly question - are you certain your char field values are in fact convertible?