DSXchange

SetNull()

I haven't had any issues using the same 'tnsname' in both the thick and thin Oracle ODBC drivers:


Changes/additions to this are immediately available.

Use the StringToDate function with the appropriate mask. Search the forum for specific examples.

I thought a job User Status area was strictly Server job's only? Can it be used in a EE job to pass a sequence number? As far as I know, you can if you do it in a BASIC transformer - with all the restrictions and caveats that that would bring along with it. Or simply plug a Server job into your job...

chulett wrote:If it is truly the 'Initial Value' to use in the Surrogate Key Generator, then should you not increment your current max value by 1 before you poke it in there?

ray.wurlod wrote:No, because I specified "the next available key", rather than the current max key value. implying that there would be a +1 in the SELECT statement.

Code: Select all

SELECT MAX(SKey) + 1 FROM tablename;

So, in other words - yes.

I'm guessing that on a Windows server that would be a Service you would need to check and see if it was running. However, not having any personal experience with DataStage on Windows, I'll defer to people who actually know what they are talking about.

It is the same 'Validate' that is available in your normal Run dialogue box. In much earlier versions, it was a required step as it was the only way to create your hashed files. I can't remember the last time I validated a job now that that is no longer an issue. Never really found where the docs ac...

If it is truly the 'Initial Value' to use in the Surrogate Key Generator, then should you not increment your current max value by 1 before you poke it in there?

Time to mark this as Resolved, it seems.

Field marks in the output need to be removed. Your Custom Conditional expression should be:

Execute_Command_7.$CommandOutput<1>=1

-or-

EReplace(Execute_Command_7.$CommandOutput,@FM,"")=1

Topic has been discussed quite a bit here, search for Range Lookup to find them.

We knew you would figure it out.

Shrey - if you are going quote everything every time you reply, at least remove the check next to 'Disable BBCode in this post' so it shows up correctly.

Suggest you click the Help button on the connection screen and read all about the Omit option there.

What O/S is your laptop running? Hint - 'Windows' is not a specific enough answer.