DSXchange

In case it's not clear in Arnd's post, drop the 'dot' from the front of the filename. You want to edit the regular uvconfig file instead of the hidden .uvconfig file. And then yes - once you regen - your changes will more than likely 'effect the actual run of the job'... some more than others.

Failures during a direct path load will leave indexes in an UNUSABLE state, which a rebuild will be needed to fix. As to why there were failures... definitely get your DBA involved. Show them what SQL is being generated by the stage for each of the steps involved. I suspect it may have something to ...

No, not directly. You might want to explain what you are trying to do, then you can get something less 'generic' in the way of advice.

I did a quick search on excel odbc and got 37 matches, so your answers are out there. Like for example, this one.

Since you are on a Windows server you can read the .xls directly. Or you can always do the old standby of saving as a .csv first and then loading it via a Sequential File stage.

i want to use this number down the line to update the records with different statuses. I think the key here is what 'down the line' means. If they are followup jobs, then you can get the new column values post-process and hash them up as Vincent notes. However, if 'down the line' means 'later in th...

But not and get the name of the constraint being violated.

Two things:

1) I believe max key length is controlled by a uvconfig file parameter. I have no idea what effect changing this would have.

2) Why in the world would you need a 2000 character key? Do you really need to do this?

You either need to make sure the install path for WinZip is in the PATH variable of the server or launch the command from that directory or fully path the executable when you run it.

Unfortunately, no - not from the reject link inside the job. The only place the full message exists is in the job's log. So you'd need to farm that information from there after the job completes. If you don't want to roll your own, you might want to check out Mr Duke's ETLStats package you can downl...

Welcome aboard. :D

You should be fine all around as long as you don't hork up any existing definitions you care about. They are only used to establish the connection AFAIK, so I'd be surprised if it would bother anyone who is already hooked up.

It's not a bug. Putting '0001' for a year is the same to it as putting '01' - it thinks the century is missing. Based on the sliding window year (don't recall the exact name) defined in the uvconfig file it decides if it goes into the current or previous century. I think it defaults to 30.

Define what you mean by "unpredictable" or "unexpected" behaviour, so we know what you mean. Examples would be good, too.

I really don't think that can be true, Ogmios... at least not for us when working with Oracle via the OCI stage. Perhaps it's different when using ODBC, couldn't say as we typically don't. There are quite a number of jobs here with comments in them, some even at the very beginning to note what is go...

Use Char(10) or Char(13) instead.

lagrangeusa wrote:I am looking for a default screen in Data Stage Administrator or Data Stage Manager that allows me to set the SMTP mail settings for all DS jobs.

You are thinking of the option in Designer to provide defaults for the stage when it is newly added to a job.