DSXchange

Hi,
If the whole directory where the DS installation resides migrated to new server, will I be able to access the jobs as usual.
We were in the process of migrating server. So should I need to aware if something else.
Pls advise.

Sorry this is an Server Question.
May I know how to find the template project settings.

If I create a new project (Unis server). I couldn not get Oracle9i stage. But it is there one of the exixting project. Is it an plugin? I could not export and import the stage from existing project. Should I need Install this? Or copy from the existing project (Unix copy)? I have client software han...

Thanks Ray,
So is that ment that, datastage will read and process 1024 rows from Database parallely.

Though the Array size totally depend upon their environment, may I know the maximum value been used by your guys. So that I can visuvalize the maximum possible limits for more efficiency.

By default Array size is 1.
May I know, for what scenario we need to set it as it is.
And what scenario we can increase?
Is it the memory bandwidth of datastage, which limits the performance at a point when we increase the Array size to a level?

Thanks for your inputs.
Due to some reason, the job ran find from the second run. And the RT_BP271 file also got over written. So I counld not find the reason why.

And I was using dsadm for both the time.

Hi Kim,

Program "DSD.WriteLog": Line 239, Abort

Is this information helped you to come to a conclusion of this.
May I know wha is catch 22 problem?

Hi, If I get the following error, DataStage Job 271 Phantom 6765 Job Aborted after Fatal Error logged. Program "DSD.WriteLog": Line 239, Abort. Attempting to Cleanup after ABORT raised in stage I know that i need to find the line number 6765 in the file related to the jobno 271 under the p...

Now I got what you mean, while 'Build'ing the sql, in the 'Table Name' option we can give the parameter.
Thanks for this.

For the same reason of using parameter for the SchemaName, i switched to user defiend query.
Is there a way to make datastage to handle by it self?

But my worry is, when I use those option, I get <instance>.<tablename> in the generated query (as I mentioned earliar.)
If i move the job from Dev to PROD wont this be affected?

PS: CODE is just an example. sorry for the confusion.

May I know, what do you mean by "query that DS generates by default"? Is it by the option "Fully Generated SQL Query" in the Query type on SQL tab? If that is the case, I should need to click on Build, and select the tables which I should have been imported already. Even then, th...

Do you mean "Fully Generated SQL Query".
But I couldnt see any SQL, If I select that option. Is it usual?
More over can I select only few columns using this option.
Or do you have any other suggestion?

I think I need to change the code as
SELECT CODE FROM CODE_LKP WHERE CODE = :1

where :1 is the CODE from the main stream.

Now the fatal error vanishes.