DSXchange

Sorry i thought i had posted the error as well.. well i have set the APT_DUMP_SCORE to TRUE and this is what i am getting main_program: This step has 1 dataset: ds0: {/DataStage/data/DEV/SCD/ISS_INSERTS.ds [pp] eSame->eCollectAny op0[1p] (parallel APT_CombinedOperatorController:Data_Set_0)} It has 1...

Hi All, i have this simple job where i'm just trying to insert or update a DB2 table from the Dataset using DB2 API stage. Also i have set the Run Time Column propogation ON I have defined only key columns in the COlumns tab of the Dataset and checked the run time column propogation i have set the U...

Hi Craig, I tried giving display to 12 as well . but no luck . still the same error. but the strange thing here is i can view the data from the DB2API stage without any problems with just giving length =12 and datatype decimal, its only when i run the job i'm facing this problem. Any help is appreci...

I'm sorry for the confusion , i have set the length to 12 and ther scale to 0 in the DB2API stage.

What is it that i must correct now?

any help is highly appreciated

Hi All, I have this simple job where in i am extracting data from a db2 table. I am using the DB2API stage. i have defined the custom sql and also mentioned the columns with their datatypes and lengths. there is one field of type decimal and lenth being just 12 . no precision mentioned even in the d...

Thanks for information.That was really helpful!!!!

Hi All, I think i have asked this question before , but i still have certain doubts while using a dataset. If we have created one dataset using 4 nodes and the other using 1 nodes can i do a lookup of dataset1 with that of dataset2 using 2 nodes in another job , will my job run successfully ? cause ...

Do you think i rather do the sorting and partitioing in the join stage rather than using 2 sort stages?

do you think that would make my job run much faster?

Thanks i advance

Note that not only does your join data need to be sorted, but DataStage needs to know that it is sorted (through inserting a sort operator, but with "don't sort" on the key). How can i accomplish this??What env Apt file am i suppose to intrduce in my parameter list? Let me put my design mo...

My Query returns rows in less than a minute.
Where could i be going wrong?

Any help is highly appreciated

Thanks in advance

Hi Arwd, I changed my design right now , i have removed the sort stage and removed the order by clause in the sql (in both db2 stages) as well. i instead am sorting and partitoing the data in the join stage for both the links . despite this the job is taking for ever to run. Any light on this would ...

Hi All, I have this job which is running for ever and i had to stop the job . the warnings that i see in the director is as follows Sort_15: When checking operator: When binding output schema variable "sortRec": When binding output interface field "CHK_NUM" to field "CHK_NUM...

Thanks Grace and laknar!!!!

the command worked for me .

Thanks you once again. i'm marking this topic as resolved

I did check with the DBA and he said that the version of DB2 we are using doesnt support the function LAST_DAY.
is there any other way to get the month end date of a given date ?

any helo is highly appreciated

Thanks in advance

Hi All, I have this field which needs to get the month end date of a given date field . i am populating a db2 table. I know db2 does have a function LAST_DAY which would give this result, i tried using this function on Advanced Query Tool , but i'm getting the following error 42884(-440)[IBM][CLI Dr...