DSXchange

Vignesh Basically, I need to end up with a Sequential file that has one row for every quarter hour slot in a day (so there should be 96 rows in the file). The majority of these rows will be obtained when the source data is extracted from the DB2 table. However, if there are no records for a specific...

I am running a job that extracts data from a DB2 table and stores it in a sequential file. It is basically records of telephone calls received and is split into quarter hour slots during the day. What I need to do is insert blank rows of data for every quarter hour slot within each day where no data...

Thanks for that.

Tried the first option and it sorted most of the rows correctly but there were still some out of place. But when I tried the second option, it sorted them all correctly

Cheers

:D

I am attempting to pass some data through an aggregator for grouping and summing purposes but appear to have found a problem in that the aggreagtor seems to remove the value stored in one of my fields which happens to be a date field. The value in the sequential file is held as '2004-07-29' and it i...

The fields in the file I am trying to sort appear as follows: 110,21,11 110,5,3 1,1,1 1,1,1 111,45,23 1,17,9 1,25,13 1,25,13 1,25,13 12,69,35 1,29,15 1,33,17 137,45,23 1,53,27 1,65,33 1,69,35 1,77,39 1,85,43 1,89,43 1,9,5 204,69,35 207,77,39 307,45,23 307,9,5 36,5,3 62,61,31 The sort command I have ...

Just in answer to your first point, the Call Application Number is an Integer.

Apologies !! Was getting myself confused. Forgot that testing the routine would output the time in the internal format and not the HH:MM:SS format.

Have added your routine Garth and it works fine.

Cheers !!!

:D

Apologies !! Was getting myself confused. Forgot that testing the routine would output the time in the internal format and not the HH:MM:SS format.

Have added your routine Garth and it works fine.

Cheers !!!

:D

I am trying to aggregate some data from a source file containing records of telephone calls made on a certain day. When I pass the data into the aggregator, I want to group by the following fields in this order: Date, Site, Call Application Number, Quarter Hour Slot, Half Hour Slot. It seems to work...

I have tried all of the previous suggestions but none of them work. With the 2 routines suggested, I have created and compiled them but when I test them, they come up with incorrect results. Zeros = FMT(Arg1,"6'0'R") Ans = Iconv(Zeros[1,2]:":":Zeros[3,2]:":":Zeros[5,2],...

If I put in your code either before I add the leading 0's or after, the results are the same and are still incorrect.

For example, 2 or 000002 appears as 02:00:00
37 or 000037 appears as 13:00:00 !!

I have tried the Oconv you suggested but this converts the value in the source file into a seconds from midnight value which is not what I require.

For example, 109 in the source file should appear as 00:01:09 for my conversion but comes out as 00:01:49 (which is 109 seconds after midnight).

I am attemtping to convert a source value into a valid time field to be loaded into a DB2 table. For example, in the source file, I am getting the following values: Source File 2 5 126 2545 And they should appear as time fields as follows Target File 00:00:02 00:00:05 00:01:26 00:25:45 So therefore,...