DSXchange

adding more info here.
Not all records are being duplicated only certain records are being duplicated.

e.g. SQL query output gives 28 records and db2 stage is producing 44 records.

Any thoughts.

Please disregard my last post because i was running sql with distinct in it. Now when i run actual sql with SEQUENTIAL mode records are being duplicated. I have simple join condition on key and as i mentioned there is one record in each table with matching key. Is there a partition on db tables maki...

Yes, it has defaul option of SEQUENTIAL. I changed the option to SEQUENTIAL which resolved the problem even when reversed the option back to defaul (Sequential) it produced correct result. Looks like default setting needed to be refereshed !!

im using db2 api stage to extract data from two tables in db2 z/os. When i run sql in db2 api stage i get some records duplicated even both tables have single record and to verify this i have this sql in db2 client and get only one record.

Thanks Chullet.
WeekdayFromDate(link.datecolumn) gives Integer from 0-6. Used if conditions to get values for Sun-Sat.

Thanks sourabhverma,

From documentation "WeekdayFromDate" Returns the day number (int8) of the week from the given date.

Is this day number mean 1=Mon 2=Tue 3=Wed ........ ?

Am i right ?

I want to get DAYNAME from the Integer Date Type:

e.g.
Input: 20090520
Output: Wed

This is a px job, advance thanx for any help.

We have same error comming out from different projects. Nothing has been changed. I read somewhere in the forums that it require some Patch from IBM. Any body knows about the actual Patch# ?

Resource disk needs to be located on two boxes or can be two different folders on same box and that box should be a datastage ?

Question from question: Can you write to two diferent FileServer locations to get the max parallel performance? Can two locations be on a same server pointing to different folders ? What are the best practices to follow when defining resource and scratch disk configuration in config file? Should Des...

throbinson: When i pointed to header file i was able to view the data. However i have following scenario: In our jobs we are creating datasets on an external file server (e.g. \\fileserver\dev\proj\work\test.ds) but in config file admin has pointed datasets path as below: node "node1" { fa...

throbinson: When i pointed to header file i was able to view the data. However i have following scenario: In our jobs we are creating datasets on an external file server (e.g. \\fileserver\dev\proj\work\test.ds) but in config file admin has pointed datasets path as below: node "node1" { fa...

When i try to view a dataset using Dataset Management Utility in Designer. I pointed to data file path which is mentioned in config file. I get following error messgage "This is not a valid dataset file or format is not currently supported." How can i run Orchadmin from windows workstation ?

I have to delete from db2 table where db2 timestamp column is defined as 26,6 and its value is as follows: 2008-09-03 13:42:10.333 While extracting from the db2 table and passing to a dataset, same timestamp column is giving value as follows: 2008-09-03 13:42:10 When i try to delete from the table w...

How Parallel Funnel stage functionality can be used in server job. Want to union two sequential files in a server job. Please comment...thanx.