DSXchange

Hi Ray, thanks for answering but what is the use of the parameter sets defined out of the data definition once you defined it. What do you do with them? I tried to map them to the global settings ($PROJDEF) without success. This is why I ask about the idea or concept behind it.... Thanks in advance

Hi, working with DS 8.5 I do not see/understand the concept of defining a Parameter Set from a existing Data(base) Connection definition. I know connection definitions and I know Parameter Sets - but what is the use and intention of being able to associate / create a parameter set from a connection ...

Hi suresh_dsx, what you do is extremely expensive - as Chulett mentioned as well - you will delete let us say 15000 x 4 rows = 60000 rows if every row in the source is selected. The real problem behind that is that you will issue 120000 statements for that 60000 Deletes (of a single rows each) 60000...

eostic wrote:Confirmed. The doc is correct.

Ernie

Hi Ernie,

thanks a lot - but what a pitty - unbelieveable...

Hi Ernie,

eostic wrote:I seem to recall finding this also, as a difference between the Stage and the Connector.
Ernie

so you can confirm this.
Do they call this a concept/architecture?
That is really strange!

I indeed need the additional functionality of the connector...

thanks so far

Hi can anyone proof that it is possible to write multiple columns to the MQ Connector in DataStage 8.5? There is a strange sentence in the Information Center documentation: Message payload Contains the message data in text or binary format. Message data can be structured or unstructured. However, th...

Hi abhilashnair,

you could use a sort stage to detect the group change and then filter it.
Alternatively you can do it "manually" in a transformer - use stage variable to detect the change of the key column and set this as condition for the output.

Hi samyamkrishna

good idea but it is a Server job...

Hi Ray, well that is what I have read from the books as well but my job design is really simple: File --- TX --- MQ Connector I do not understand where I can get any differences between my design and what you say "is out there". If I pass two columns through the transfomer how should there...

Hi, we are migrating from DS 7.5.3 to 8.5 and trying to replace the MQ stage with the new MQ Connector. We have defined the connection properties and successfully tested the connection. Writing to the queue works for a single column. When we change the column definitions to more than one column we g...

Partioning sounds like a good idea but I think DB2 is limited in this area Hi clarcombe, why do you think DB2 is not good in partitioning? We do have database partitioning, table partition, and MDC-tables. These are all forms of partitioning and they can be combined in every way. So this might be a...

I am in the process of taking a DB2 source, and loading it back to another DB2 table that has RI on another table. The client is ok with breaking the RI in this test environment. What would the syntax be within the DB2 connector to disable RI within the table before loading? Hi well if you talk abo...

Hi clarcombe ok - so you are running out of log space - most probably you will receive a SQL0964 telling you that the transaction log is full. Well - you want best practices - and the answer is: IT DEPENDS! So while the answer is correct (although you might not like it) you might consider following ...

We have embarked on a Datawarehouse project with DB2 v9.5. We are experiencing issues with running out table space as we are using the DB2 Connector stage to write to the table. Hi clarcombe, I am not sure what you try to tell us - running out of space in a DB2 table space has not much to do with t...

Hi, a customer wants to upgrade from AIX 5.3 to AIX 6.1 on the LPAR where we run DataStage 7.5.3. and RTI 7.5.2.8. Officially this combination is not supported by IBM. But.... has anyone run this combination already? Any experiences? This is really nothing I want to try but the circumstances at the ...