DSXchange

Hi sriec12, it is possible to connect to DB2 on zOS (Mainframe) with the DB2 Connector and I would suggest this as well. The point is that for every DB2 connection (via DB2 Connectors) you need the DB2 client (free) installed on your DataStage server. DB2 Connect is an additional (or alternative com...

Hi one way is to create a stored procedures which handles the deletion for you and add some intermediate commits so the log full condition does not occur. This would be a way (and we do it this way) if you need the deletes logged. For any other solution I would like to know more details but in gener...

Hi Ray

yes you are so right - but I know customers who think this date is ok - and have designed applictions that way

Hi Ray
of course in every year - but not in the example of the first post

Hi JJ, first of all I think you mixed up some dates in your post (there is no 31-JAN-9999 etc.) but I think I got the idea. I completely agree with chulet that it is maybe not a good idea to use the before SQL for your purpose. Second point is that your table - unless you oversimplyfied it for the p...

Hi tbrosi finally I remember this problem - sorry we had it in 2011 so I forgot about it but when I read you last message I finially remembered it. We had the same problem in DS 8.5 and a PMR was opened and we got a special build for this. Please check for APAR JR39943 You might open a PMR in order ...

Hi tbrosi I do not have a DataStage 8.7 at hand ... What could be interstiong though is if you expect unicode characters or not. Or in other word does the problem occur as well when you select the let us say tabname from syscat.tables? Have you tried using the UNICODE extended attribute in the colum...

Hi tbrosi

first of all there is no such thing as "DB/2" it is a full database so it is DB2

I have Server Jobs working without problems in DataStage 8.5 (both with UTF-8 Job NLS setting and without).

Which DataStage version do you use?
What is the database codepage - UTF-8?

Hi, we are using the new XML-Stage of DataStage 8.5 and we have to provide the XML-tags even when the content is empty or null. There is a setting in the composer step on the format tab which I though would do the job: "Omit Null Elements" is unchecked but the stage does not return the tag...

Hi ok we have to differentiate between number of statements and number of transactions. The number of statments can increase by one for every failed let us say update in this example. The number of transaction depends on your settings. If you have set it to one it is increase in the same manner but ...

Hi well in order to know if you will get an update failure you have to try it - don't you. The update is then an other operation - it is anyway for all additional rows - so I do not think that any other mode would be more efficient. For example - let us assume you have 10 rows: This will give you an...

Hi zulfi123786

the second point is right:

...
2. As and when a record fails for update the insert follows before the second record in the transaction is updated.
...

This is why you usually check if you have more updates then inserts and then you use update - insert mode and vice versa.

Hi zulfi123786

DB2 will use UR in this case.

Hi qutesanju ... FROM #AML_ACH_DBR_PARAM.$AML_DB2_SCHEMA#.NTS.AML_AC AML_AC.AML_AC ... Tablenames in DB2 consists of a schema (in your case #AML_ACH_DBR_PARAM.$AML_DB2_SCHEMA#) and a object name. The objects name seem to be NTS.AML_AC in your case - I doubt that an additional "." is allowe...

Hi caola,

DataStage will use the two statements - a delete and a insert
but I am not sure about the size of the transaction.