DSXchange

All,
Do we have any functions to convert seconds to HH:MM:SS format. I generally do it in database itself. This time looking for something in Datastage. Can we do it without Routines.

Seconds- 100
HH:MM:SS-00:01:40

Seconds- 10410
HH:MM:SS- 02:53:30

Thanks..

Craig, Sorry for that. I am joining on ID, not the date. Did it and worked fine. Thanks a lot for the explanation.

Craig, I did first part. What should I do to compare it. Any functions.

I mean, as the design has Join stage. We cant compare in Join right, it has to be in transformer. Kind of confused.

All, One more question on date validation. We have a job which outputs a cvs file. I created another job, which will read the file and Join with a Query from SQL server. Both have date filed. (File and query). How we can have a validation check to see both the date are equal or both the dates are sa...

Worked well. I was stuck with the outliers. Solved now. Thanks a lot Craig and Ray. Appreciate your help.

All, need a quick help on field function. I have a name- ASHLEY, MARTHA ANNIE This is char(30) column and need to separate it to first name,last name and middle name, three separate column. Used FIELD function below. LAST NAME- FIELD(name,',','1') Last name worked. But got stuck in first and middle ...

Ray and Craig, thanks for the reply. Let me go through the data again. I initially thought two files have complete separate data but seems like one key column is common. Then merger would definitely work. Craig, Initial requirement was excel output. But 11x onwards we have excel output in unstructur...

All, have a question. I have two jobs for two separate CSV output. Now I need to merge them into single CSV file with two different worksheet. Can we achieve this in Datastage?? Appreciate for any other suggestions.

All, Have a question on Pivot enterprise stage if anyone used it before. Got below example from IBM dev guide.It works fine. But how do we specify ARREY SIZE when we do not now the data due to large volume. This works fine but I have to pivit where Smith is 4 times and Yamanda is 3 times. WHat would...

ok Thanks Craig. Will try it now.

@rkashyap,
If multiple records in the same key then change the status column of the past end date column to 'Completed;

We can pull only duplicates rows from database can create this job as an Update only.

Craig,
I used a sort stage, sorting on ID and generate a Keychange column. Seems like it marked the Oldest date as 1 and new date as 0. Then used Transformer and put a condition to change the Status column to Completed when Keychange column is 1.

Wat do you think.

All, Need a help with a condition in DS parallel job. I have a DB2 table, there are three columns as below. Key is ID. ID, Start_Dt, End_Dt, Status 1,10/22/2012,11/10/2015,In Process 1,10/22/2012,11/10/2016,In Process We need to update the the row to "Completed" if it finds same record wit...

Yes. It would be even that much. May be not more than 10 minutes and its average time. Thanks.

All,
We are pulling a column from DB2 database as 2.2 but in Sequential file it suppose to be deliverable as 00:02:02. So, its actually 2 minutes and 2 seconds format which needs to convert to HH:MM:SS.

Any clue how to achieve this.

Thanks.

Ok Sure. Let me do some more research. Thanks.