DSXchange

Try '' instead of null
or else
use transformer stage and create those two colums and assign them with setnull()

Regards,
Chandrakiran

Many many thanks to you Ray.This has really helped me a lot.

Regards,
Cmunikoti

i am stuck with one problem. i got one master sequencer in which i am calling 'N' sub sequencers. Each and every sub sequencers are independent of each other. But due to some resource crunch i cannot trigger these sequencers simultaneously. SO i just created an "unconditional link" between...

What kind of 'routine'? ... Actually i have written a routine in which i am calling a job sequence in loop using DSRunjob(somekind of a real time implementation). I actually want to call that routine somehow from somewhere. so i m calling it from sequencer. But since i am calling that routine from ...

Can a routine be called from the command line.

As we do it for the job.

Regards,
Cmunikoti

I have a issue and i need help on this. I am running a sequencer in which i am calling a user def routine. The routine runs continously in infinite loop (for real time implementation). The sequencer in which i am calling the routine ,the log is getting generated and getting appended continously for ...

What output are you getting in PX and have you tried it with a 1-node configuration file? ... Yes, actually i tried with execution mode as sequential also ,but giving same out put col1 | count_col2 abc | 0 abc1 | 0 abc3 | 0 is it possible to take a count of varchar column? regards, cmunikoti

I have an issue .i got input as col1 | col2 abc | y abc | NULL abc1 | y abc1 | y abc1 | NULL abc3 | y i want ouput as col1 | count_col2 abc | 1 abc1 | 2 abc3 | 1 I used aggregator stage and used "count of non missing value" on the column "col2".i am getting output as col1 | count...

Thanks a lot Sainath .This gives me the output what i want. :D

Sainath.Srinivasan wrote:

Code: Select all

[ ( (hh * 60) + mm ) * 60 + ss ]  / 86400

...

Regards,
Cmunikoti

I want to convert time to decimal as done in the msexcel. if we use format cell then by selecting general as option. By doing this the time gets converted to decimal. I want the same to be performed in datastage. I am getting input as '00:05:30' Viz time i want it to be displayed as '0.00381' i.e de...

I got a work around for this.

The routine ConvertTag(,"W") solves my purpose :D .

it gave me something like 2009W37 .i just want 37 out of it so.....

Thanks and regards,
Cmunikoti.

How to get Week of the year for a input date using iconv/oconv .

I'll be using it in the sequencer.

Regards,
cmunikoti

Thank you all for the help. this solves my purpose.

Sainath.Srinivasan wrote:Multiple by 86400 and round to nearest integer for seconds from midnight. ...

Actually the format of the file is something like uder the same column for other key we are getting decimal values which need not be converted into time. but for some key it should be converted into time(which is coming as decimal). foreg A | value 1 | 0.95 2 | 0.034 3 | 200 i just want to convert v...

How can i convert a decimal value to time in datastage. In excel when we format the cell ,containing value as 12:05:44 AM, to general it gives value in decimal as 0.00398.I am storing this decimal value in the table.But my requirement is that the value needs to stored as time hh:nn:ss format. Can th...