DSXchange

Hi All
I did not get any answer to my original post.Suggestion of TRUNCATE is not valid since I am using DB2.I cannot set in environment variable since I have three more schemas in the DB.If there is no solution then I call it a DS bug.

Regards

Shiv

Hi All I use DS 6.0 on AIX with DB2 as DB.I am using ODBC stages for all my jobs.For every load I need to clear the staging tables,so my update logic is "Clear the table and Insert rows".Since I process more than 6 million records I get into trouble with the logfiles and the job gets abort...

Hi All I have a series of jobs executed through a sequencer.These are mix of parent and child table jobs.The logic for the parent table is INSERT/UPDATE and for the child table it is UPDATE EXISTING ROWS ONLY.Now the problem is,i select the records from WareHouse based on a time window.It happens th...

Hi
I am getting the following error while importing a project,can anyone clarify this.
Line33330:Unknown property name 'STAGETYPE'
Object=V0S0
Class=CODBCSTAGE
Thanks in advance
Shiv

Shiv

Hi
I use ODBC stages in all my jobs!
Regards
Shiva459

Shiv

Hi We have developed server jobs in a project using ODBC connection to DB2v8 database.But in our pre-prod we have configured DB2 CLI Plugin to access the DB2v8 database.Now i want to export the project to pre-prod.Will there be any implications on the import or the behaviour of the jobs?If any one h...

Hi Kim Thanks for your reply.I was trying to find the difference in months.If i get difference of 1.1 then it should go as 2 months into the ClaimAge.Basically i was trying to round to the next higher value.And the Mod was to check for Integer. But is it the routine giving problem or the lookup tabl...

Hi I have a if statement which calculates the claim age for the products.I get the sale date from a lookup.Once i start the job,the monitor shows status as running,but doesn't process any rows.I guess it is problem with statement.I am posting the routine, can any one correct me? IF IsNull(SALE_DT) T...

Hi One of my job in the sequencer got aborted by giving the following error message.I guess it is a ODBC error.Can anyone please clarify me why the job got aborted.Any help would be greatly appreciated. Regards Shiva SQLSTATE=22005, DBMS.CODE=-99999 [DataStage][SQL Client][ODBC][IBM][CLI Driver] CLI...

Hi Tony
You are absolutely right !.Thats the only mistake i was doing.Now the job is working fine.
Thanks a lot for your help.

Regards
Shiva

Shivakumar

Hi I've designed a sequencer which should read the parameters from os level file.What i did is wrote small pro which reads the values from OS file and assigns to all the jobs in sequencer.But some how it is not able to assign the parameters and taking the default parameters given in the individual j...

Hi
I want to use a function which rounds off the decimal value to next higher value.I mean anything greater than 1(say1.1) should be rounded to 2.Is there any inbuilt function or i have to write a function to acheive this.
Regards
Shiva

Shivakumar

Hi
I am using ODBC stage to perform update
Regards
Shiva

Shivakumar

Hi All I have two jobs to load a table.The first job loads the data from master to the target.The second job updates the data from child to the target.But when the second job finds no data to be updated it gets aborted with the error . [DataStage][SQL Client][ODBC][IBM][CLI Driver][DB2/6000] SQL0100...

Hi I would like to add some more infi with the above error SQLSTATE=IM974, DBMS.CODE=0 [DataStage][SQL Client]Parameter marker text size exceeds allocated space SQLSTATE=22005, DBMS.CODE=-99999 [DataStage][SQL Client][ODBC][IBM][CLI Driver] CLI0112E Error in assignment. SQLSTATE=22005 SQLSTATE=58005...