DSXchange

Hi Devesh still wondering.. does it mean ..if load aborts by any means then the amount of data is loaded in to table at abort instance will be rollbacked or it creates save point and when we load agin will bypass already loaded record and load remaning data please correct me thanks and regards, Deve...

Hi meet_deb85,

I think your problem is that you use the DB2 server instance in your stage - change it to the client instance!
You have successfully cataloged the database and this is enough for DB2 to know where the database is (including the instance).

Best regards
Michael

Its DB2 database and I dont have a DBA support but I have admin privelages On my id. Hi Jack this means the DB2 log ran full because your Transaction was too long (too many rows where changed). Several solutions for that - here is one: 1. Increase your number of secondary logs (logsecond parameter ...

eostic wrote:Where exactly are you with 8.1 ? Ernie

Hi Ernie

we are on 8.1.0.1
so the Service Pack is already applied.

In my eyes thing that worked in th eold version should do in the new one without any changes unless documented otherwise.

Best regards
Michael

Hi, we have a working job which selects data from DB2 and sends it through a XML-Input stage. This jobs works fine in DS 7.5.3 but after migrating to DS 8.1. we get problems with the german special characters which are no longer readable. So we got some kind of codepage problem. Is there anypone who...

Hi, no DB2 functions are SQL and the Transformer uses C-Code (or Basic if it is a Basic--Transformer). U can use stored procedure or u hve to write routine to obtain this Regards Manoj Hi manoj_23sakthi copying my answer is without quoting is NOT the way it works! Write your own stuff or mark it as...

Can I use DB2 function to transform a column in Transformer stage? Hi, no DB2 functions are SQL and the Transformer uses C-Code (or Basic if it is a Basic--Transformer). Use your DB2 stage for SQL stuff or a stored procedure (separate stage)... If you describe a little more what your problem is you...

No..... the WSPack (Web Service Tranformer or WS Client Stages) in DataStage has never supported arrays. Ernie Hi Ernie, I do not want to argue with you about it but it simply worked with RTI and the WebService Pack in 7.5.3. Could you please point me to the location where it is stated that this is...

The problem is not with ISD....it's with Web Services Pack. The WSPack can't easily handle services with arrays. There are ways to do it, but for the moment I will assume that your real future client is a java or .NET application somewhere that wants to use your ISD DataStage or QualityStage based ...

Hi, we created two WSDI services. 1) One service is just for testing. For this service only one operation is implemented requesting and returning only one column. A job using this service is working and there are no problems importing its definition to a Webservice Client Stage via the Webservice Me...

"SQLExecute reported: SQLSTATE = 40506: Native Error Code = -1476: Msg = [IBM][CLI Driver][DB2/AIX64] SQL1476N The current transaction was rolled back because of error "-289". SQLSTATE=40506 (CC_DB2DBStatement::executeInsert, file CC_DB2DBStatement.cpp, line 661)" Hi, in DB2 you...

Hi, Ray already pointed to the root cause: Did you extract "GRAYT" does not have the privilege to perform operation "IMPLICIT CREATE SCHEMA" from the first error? Check with your DBA. It seems you are trying to create a table in your stage in a new schema. To do so - meaning to b...

Rohit_ben wrote:A NULL value was being encountered for a partitioning column, hence the job was failing. There was a slight confusion about the error as the director was showing an error for the Transformer stage.

Thanks for all your help.

Hi could you please mark the topic resolved

thanks
Michael

Hi, I need to generate sequence from the db2. Iam having 2 columns and the sequence applies to both. Can you tell me how do I implement this through Transformer stage as processing stage between the input db2 and outout db2 . Hi sometime a little more input is required to understand what you intend...

I thought there would be the answer to my problem, but unfortunately do not have a DBA for DB2 and the logic of the DB is not easy to learn. The solutions presented here serve only to improve the reading logs. Hi, well this is why DBAs are still needed :-) Actually what you want to achive is not th...