DSXchange

It was executing sequentially!! .... i want it to work parallely ...

Hi Friends, Need a help on runnind a script in parallel ( Background processing) Scenario: Script name: Script.sh ETL jobs expects 3 files which will be created of the above script for given 3 different parameter. Script.sh Parm1;Script.sh Parm2;Script.sh Parm3 Usage of ";" will make it to...

Hi,
Can some one assist in converting a date from one format to another.

eg:
Input Date : 2009-12-31 ( yyyy-mm-dd) data-type : Date

Output Required : 31-12-2009 ( dd-mm-yyyy) data-type : Date

Regards,
SatishM.

Sure... but the first question is going to be - what is your definition of a month? Were you given any business rules on how to compute this? Is this always a whole number? (etc etc etc) ... Yes!!...Thanks for your reply! Lets take an example, DATE1 = 2006-01-01 & DATE2 = 2009-11-09 now by manu...

Hi Friends,
Need a help!
Suppose in a file they are two date columns and I wanna subtract those two dates to get the no. of months...Can we achieve this any way?

Regards,
Satish M.

Hi Friends,
Can someone suggest me a command/syntax to capture a link count fetched by the DSGetLinkinfo routine in a sequential file ?

Regards,
Satish.

Hi ,

Need help on writing routine for link count.

If available,please provide the same.

Regards,
satish.

Hi, We want to use only first 18 digits from the filed.
Like the Field Name is Filler1 with size 120.
But we will be using Filler1[1,18] and store it in Decimal of (20,2).


Thanks.

I appologise for words mismatch from my side, i must have typed in "Issue is Urgent for me". This is the Filler column from CFF which was stored into dataset as a binary column in our Cycle 1 jobs, now in Cycle 2 we are using this dataset and extracting the information stored in Filler col...

Hi, Can anyone please help me to convert the input Binary column to be converted to Decimal. Input string is "08 16 O 00 0f 08 16 O f5 f0 f1 f0 f0 e8 e8 f0 f0 f1 f1 d5 @ @ 07 85 14 8f 00 0f 00 00 00 0f 00 00 00 03 8c 01 d 09 / f0 f2 f0 f2" Output should be Decimal value. Can please anyone ...

kumar_s wrote:Did you try StringToTimestamp(DSLink4.time,"%yyyy%mm%dd%hh.%mm.%ss %aa")? ...

yeah..I tried but job got aborted.see error in my prvious post..

What solution did you use - all that extra work using stage variables or the proper StringToTimestamp function syntax that Kryt0n helped out with? ... One which Neena provided, as i dont wanna store am/pm in table and also wanna store it in 24 hrs format.. She provided a perfect solution. But thank...

What solution did you use - all that extra work using stage variables or the proper StringToTimestamp function syntax that Kryt0n helped out with? ... One which Neena provided, as i dont wanna store am/pm in table and also wanna store it in 24 hrs format.. She provided a perfect solution. But thank...

chulett wrote:So you quoted the simple solution but actually implemented an unnecessarily complex one? If so, you might want to revisit this. ...

Sorry...I dint get u

Kryt0n wrote:The format you provide to StringToTimestamp needs to match your input format, not how you want it to look.

For am/pm use the %aa format option

Help files are more than enough to figure out the correct format

Thanks, Neena ...It worked.....God BlesS!!