Search found 3 matches
- 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...
- 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...
- 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 ...