Search found 3 matches

by DrackThor
Mon May 16, 2016 11:21 pm
Forum: General
Topic: Xmeta query to get list of all assets changed or modifed
Replies: 2
Views: 2423

Hi - yeah just use some MWB queries to get all changed objects. You can use the asset hierarchy at this point. E.g. you don't have to get jobs, stages, projects separately, just query the assets with lowest granularity, e.g. link and get the job, project,.. information of this asset. Same for databa...
by DrackThor
Wed May 11, 2016 11:37 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Get SQL State of DB connector
Replies: 5
Views: 7389

Thanks ray and chulett for your answers! 1. I do know the feature of a parallel Job's DB-Connector to reject an SQL-Errorcode + Errortext, but I want to get ALL the SQL-States, not only the errors. E.g.: I insert 2000 records with 500 records per transaction, which makes four transactions which make...
by DrackThor
Thu May 05, 2016 11:38 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Get SQL State of DB connector
Replies: 5
Views: 7389

Get SQL State of DB connector

Hello everybody! I hope anyone can help me with this issue. I need to use a DB connector stage (eg. DB2 connector) to do some SQL stuff (delete, update, insert..) and always get the returning SQL state, because I need to react on this SQL state in my sequence. E.g.: I want to update some records in ...