DSXchange

Hi, I have a job running successfully with a multi-row lookup against a ODBC stage. Due to requirement changes I have to change the lookup from a equality condition into an IN-list - like select ... from TabA where ID in (?) ID is an integer column and in my stream I have a column with a comma separ...

Hi Developer9,
It is a generated name so I assume you created the table with a primary key and this is the index DB2 automatically generates for it.

Hi well the message is quite clear - so let us check it in detail You can use following SQL to figure out which constraint you are violating: SELECT INDNAME, INDSCHEMA FROM SYSCAT.INDEXES WHERE IID = <index-id> AND TABSCHEMA = 'SCHEMA' AND TABNAME = 'TABLE' In your case you have to use 1 als the <in...

Hi Gopi,

switch to mnimal validation in the validation tab of the composer.
Data type problems should be ignored then - it is a problem with data not corresponding to the XSD I suppose.

Hi Andy

Thanks a lot - this is the information I was looking for.

It is stored in
/opt/IBM/InformationServer/Server/DSODB/samples

Hi, I am looking for the "Pre-built Operations Analytical Report" described in the What's New presentation for DataStage 9.1 see http://dsxchange.net/uploads/91_DataStage_Deep_Dive_DSXchange.pdf page 27 Can anyone tell where I can find those? There seems to be (again) no documentation at a...

Hi Curious George I opened the different tabs in the DB2 Connector Stage and checked the Stage page and in that there is no Advanced tab for DB2 Connector stage. It is present for other stages which shows the information: Execution Mode: Default(Parallel) I don't have access to view the job score or...

Hi, you will see if the DB2 Connector already runs in parallel looking at the partitioning icon. I recommend to use "DB2 Connector" partitioning within the DB2 Connector - which is different to "Auto" but will provide the correct partitioning if your target is a DB2 DPF (partitio...

Hi Arnd,

I have 9.1.0 on Linux - and it compiles fine but the job run never ends.
So if even 9.1.2. does not solve the problem it prooves a really high quality implementation

best regards
Michael

Hi Arnd,

well it appears in my installation and Tony Curcio presented it a new functionality of DS 9.1...

best regards
Michael

Hi, finally - after many years - in DataStage 9.1 Ereplace and Change appear in the transformer functions lists - although they are only documented in the info center for basic server job. My first simple test job (generating one row passing it into a transformer and writing to a peek stage) runs bu...

Hi neena If I have to come to table, table is partitioned by one of the date fields (this field is not in any index). Also we have index that was created on the 5 part natural key that we are updating (Also we had 32 index on this table). So you got 32 indexes on a table and you wonder about perform...

Hi Well it will override it if it is a SELECT statement - and it is needed to have an isolation level set when the WITH <Isolationlevel> is NOT used (so also for generated queries). Cursor stability is the default isolation level in DB2 that is the reason why you see it in most situations (for the g...

Hi Pedro,

thanks for your comment but I am not talking about the 2old" stage like XML input etc but about the new XML stage.
It is completely different and I want to use this as it is future proof.

Hi, I am using the XML stage in DS 8.5 and I can not find a solution for this problem - hopefully one of you can help: My input is a single stream with data - a little simplyfied it is: Workgroup lastname firstname city citycode telephone A single person can have muliple adresses (cities and city co...