DSXchange

I'll step in before Ray does and ask "What changed? Nothing is not the correct answer."

I'd also be curious if this happens to everyone or just your / your client.

That would be a support question.

You can reference a file that holds server, userid and password (from what I recall) and if that's what you mean by an authorization file then yes! Never tried an encrypted password there.

Tell us exactly what you put where in the stage.

What kind of "transformation" do you think you are going to be able to effect? And still wondering why your target is a dataset, will you be picking that up for the "transformation" processing? As to the size, the only avenue I'm aware of is by increasing the BLOCKSIZE as you've ...

Very nice - that filter option looks viable.

I'm assuming 'generic' in this case means that the job control queries the job and gets a list of the parameters that it needs so it knows what to pass to each one. But that would be just a guess.

With the restrictions you've posted, I think you are basically... what's the technical term... screwed. I'll ponder this and I'm sure others are as well so perhaps someone can think of something to unscrew you. The problem is your parameter needs to be used right away in the job for your source stag...

I am able to read payload,i have changed the sql type from LongVarchar to LongVarBinary. Well... it is a BLOB not a CLOB. :wink: Just i am thinking is it feasible to transform 600MB payload(BLOB) data into datastage? You're not "transforming" it. And I thought you said you need to write i...

Enzopre wrote:Indeed, from the documentation:

We know, you've now posted that paraphrased section of the documentation three times in the thread.

So, as you are finding, having that property set to FALSE just means that the Copy Stage may be optimized out - not that it will be. Unfortunately, I can't tell you under what exact circumstances it will decide it's not really needed and remove it... perhaps others can. Or you could open a support c...

Or that.

That option wasn't always supported, btw.

Pardon my persistence but how exactly do I generate the contents of an SQL file? You just need a pre-processing step to take your parameter value and incorporate it into the SQL... much like building dynamic SQL in PL/SQL. Where does the value come from? A small Server job could source or create th...

As noted, you have to install without NLS to derive any benefit from not doing the 'mult-byte capable processing' that Ray mentions. Disabling it doesn't help.

No need for the second step, use the -jobstatus option of dsjob, it will wait until complete and then the return status will be of the job: 1,2,3, etc.