DSXchange

Please share the exact problem you are facing while conencting to DB2 on mainframes, using the DB2 API ? I am also working on server edition and using DB2 API stage for connecting to DB2 on mainframes... Initiallly I did faced some issues...like unable to acces the table definitions and catalogs......

I am working on datastage server edition on windows platform , need to connect to DB2 in mainframe so i am using DB2 API stage. How can i do the connectivity , As we have dsenv file in unix server to write the DB2 parameters like PATH, INSTANCE do we have some file in windows where this type of decl...

Hi,
Hash Files were in Server Job and is no more supported in PX.
In Server jobs writing a reference table in to a Hash file and reading (referencing) for lookup would result in better performance rather than looking up a table.

Hi
can some body please expalin where are these compile flags present

Hello I am trying to decipher some legacy code that we're supposed to support. There are a couple of jobs which supposedly call dependant jobs however I am unable to figure out which jobs are being called without running/executing it since they contain include statements such as below included in th...

Hello I am trying to load the metadata from the db2 source database. However when i use the load metadata tool in Profile stage , even though i am able to select the required table after making a connnection when i click OK button - the status window displays the following message and appears to han...

Hi ,

The DS server project NLS is set to TH-THAI.
But I am unable to read any of the Thai language characters when I say view data from any of the DS stages.
I work with DS 7.5.1.

Kindly advice.

Thanks

Ray, Checked it. I have the same job. ArndW, I would reply your question, to provide more info as below: 1) The key in the source is not same as the key in the referenced object. The source has one key-A. The reference lookup has two keys-A,B. 2) The lookup condition is Source.A = Reference Lookup.A...

Hello
how about having a before script that takes care of the unzip/'uncompress'ing that you require.

Hello! Well, you 'could' test the concept of restartability with the logic you've thought of. When you run the sequence for the first time with lets say jobX having the after job subroutine, all jobs upto JobX would execute successfully. JobX would abort and cause the sequence to be aborted too and ...

ray.wurlod wrote:What - precisely - did you attempt?

Which of the three option buttons did you select?

Hello

We selected the "Add rule to Chosen Message Handler" option to create the new message handler and add the rule to it.

Hello "TheBird"

We didnt have any success at this seemingly simple task of using a named message handler for a particular job. have included the steps we followed ... where could we be going wrong ?

thanks in advance

Once you have named message handler(s) - files with names ending in ".msh" in the MessageHandlers directory - you get an extra option in the dialog for handling a message, and the drop down list of named message handlers becomes available. Choose one from there. Yes I do see the named mes...

Hello I have read through the FAQ on the forum however have we can implement a named message handler for a particular job. Lets say I create a message handler which has two rules. I would now like that this message handler be used as the default handler for a specific job(instead of adding the two r...

Yes ray,
all of them are in runnable state

Thanks and Regards
Koti

ray.wurlod wrote:Are the jobs in a runnable state? Compiled?