DSXchange

I have a file in this format. .........P1 P2 P3............................ A001 v11 v21 v31....................... A002 v12 v22 v32....................... A003 v13 v23 v33....................... A004 v14 v24 v34....................... ................................................. .................

I have a requirement in Job Sequencer. We have a master sequencer which inturn calls a number od other sequecers and individual jobs.

Some times the parent sequencer abort in the middle. Is there anyway in in DS 7.0 to restart the sequencer from where it got aborted.

Thanks !!

Kumar

Thank you Sai and ArndW

Kumar

Hi - I am trying to convert a date to Julian format. The format I require is

105202.

1 represents 21st century

05 is current year

202 is the days in Julian format.

Is there a fn or routine is DS to achieve this. Thank you.

Kumar

Thank you chulett.

Hi everybody,

i am new for DS. I have one question regarding Real time loading with DS.
Could anyone explain how can we implement Real-time loading in DS, please.
Thank you

I have a situation like like this with 2 hash files that I am performing a lookup: File 1: DateCol D1 D1 D2 D3 D4 D5..... File 2 DtStrt DtEnd D11 D12 D13 D14 D15 D16 D21 D22 D23 D24... Where D1,D2,D3,D4 are the dates which come in the range between DtStrt and DtEnd. All I have to do is see in which ...

I am creating a simple Date comparision job. 1. Data is fed to Tx using 2 paths. 2. First path give a list of date values (Lets say Date1) 3. 2nd path gives me 2 ref dates from a Hash file. ( St_Dt and End_Dt). All are in internal format. In the transformer I am using a simple constraint like this: ...

I have a folder which has few Seqeuntial file names. The number of files names can vary every time. I need to merge data from all these files and store it in a new Seq file for further processing.

Can anybody help me on how to handle this? Thank you.

Kumar

Shaina - Pls let me know what solution you adopted. I have asimilar requirement but, the OS is unix. appreciate your help.

Kumar

I have 2 inputs coming to a TX stage. <pre> SEQ 1---------------------------> TX1 --------------------> SEQ3 | SEQ 2 -----> TX2-----------> HASH1 </pre> The SEQ1 stage has over 50K records. One of the column being Date. SEQ2 has just 1 recordwhich is another date value. I want to compare 2 dates and...

Thank you everyone for all the info. Appreciate your help.

Kumar.

Hello Arnd,

Thank you for that. Further to that is is possible to make that 3 a variable.

In the sense, the value 3 is being pulled from another another DB2 table. Today it is 3. But, in our old project we used 2.

So, it might keep changing every time. Thank you again.

Kumar

I have a Date field coming from a DB2 stage. I need to add 3 months to it and store that value seperately for further processing. Just adding 90 days to that will not work right. Because, we need to take into consideration months with 28 days, 30 and 31. I can convert the date to an internal format ...

I am using it in a Sequencer. Is ther a way to use in Server Jobs. Mostly the stages used are ODBC, Seq and Hash files. Thanks Kumar. [quote="ArndW"]Kumar, offhand I would say the solution is (or ought to be) parameters. Which stage/methodology are you using? Is it in a sequencer or server...