DSXchange

Excellent. :D

They will. Me, I don't use ODBC so can't really help.

Or give Support a call and open a case.

There is also the MONTH.LAST transform available in the Built-In / Dates category.

So now it is being called but cannot be found. Does the user you are connecting as own the stored procedure? Have execute permissions on it? You may need to change who you are connecting as, or specify the schema owner in the call statement, or setup a synonym. Assuming the name as typed actually ex...

I haven't found it to be an issue, but could see where it might be a nice option to have. Options are good.

Remove it. And silly question - are the curly braces actually there as well?

Try just this:

call SP_CID_EXTRACT_CUST_DATA_FIX1()

You don't have a semi-colon at the end, do you?

You mentioned it in the previous post, hence the question.

Unfortunately, no - no Project level setting for warning levels exists. And be aware that the default for Warnings when you run a job from the Designer is unlimited - and there's no way to change that default.

Still unclear. There are no options in the Administrator which control the Warning Limit. If you want a default in the Director other than to 'Abort job after 50 warnings' - you'll need to change that on every PC where you've installed the DataStage client. Or are we talking about the Auto-purge ac...

There is no 'option from Server'... what do you mean by that?

You can either change the default warning level in the Director tool itself or override it on a job by job basis manually when you run a job.

How about you let us know why you are asking about this? What would you need to do 'after job' in Oracle? The 'why' behind your 'what' would let us make suggestions how best to accomplish your goal...

DSguru2B wrote:I think its dsjob -warn 0, right.

Right.

nkln@you wrote:So, what should I do to satisfy my requirement

So, what exactly is your requirement? In your two record example, what are you expecting back when you do a lookup using:

a b c d

As noted, you cannot build a hashed file with X key fields and then perform a lookup with less than X key fields. Period. You have two choices here: 1) Build the hashed file with 4 key fields. Yes, the data for the 'missing' 5 & 6 key fields will because they are no longer part of the key and th...

Yes, same company in different departments and sit on different floors. And I was a little confused by his post because we do have both creation and update timestamps (and users) on the table he is sourcing from. However, we chatted and I think we're all on the same page. Us upstairs types already f...