Search found 107 matches

by diamondabhi
Tue May 31, 2005 7:22 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: sequencer
Replies: 2
Views: 685

Ram,

Thanks a lot.

Abhi.
by diamondabhi
Fri May 27, 2005 11:28 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: sequencer
Replies: 2
Views: 685

sequencer

Hi All, I am using DS 7.1 server sequencer to run around 20 jobs and checked the option checkpointed run. so when say job 15 aborts i go and make necessary changes to the job and compile it and restart the sequencer from the director but its getting aborted, but if i dont make any changes its doing ...
by diamondabhi
Wed Apr 27, 2005 8:24 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: error in sequential file
Replies: 10
Views: 3431

HI,
I had a similar problem where pipe delimiter was used instead of alphabet I , as Sainath suggested open the file and check,maybe this could help you.

Thanks,
Sai.
by diamondabhi
Tue Apr 26, 2005 7:41 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Database name included in SQL in ODBC stage
Replies: 7
Views: 3369

hi rdsarbo,
i had the same problem for which i used user defined environment variables as parameters and this works good .

thanks,
abhi.
by diamondabhi
Wed Apr 06, 2005 11:45 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Timestamp substraction
Replies: 9
Views: 2271

Hi,

Thanks Roy and Arnd for the help, the job is good to go now.

Thanks,
Sai.
by diamondabhi
Wed Apr 06, 2005 11:06 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Timestamp substraction
Replies: 9
Views: 2271

Hi, Thanks to all those who replied and gave suggestions. I know access to this forum is a privilege and not a right and I am very grateful to it I am sorry if I made an earnest request but I will keep that in mind next time. But, coming to my problem I may be wrong in expressing my question as I kn...
by diamondabhi
Wed Apr 06, 2005 9:55 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Which is best tool for handling 20TB to 30TB Data ?
Replies: 10
Views: 4151

DataStage EE ofcourse, no questions about it even performance wise and economic factor and technical support.
by diamondabhi
Wed Apr 06, 2005 9:52 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: how are updates in datastage performance
Replies: 12
Views: 4592

Hi,
Bulk loader loads into onlyone table so it is comparitively fast, so wen u have to do bulk loading and with no updates its better to use bulk loader.

Thanks.
by diamondabhi
Wed Apr 06, 2005 9:36 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Timestamp substraction
Replies: 9
Views: 2271

Thanks for the replies,but I have to implement the following logic in the stage variable: Using table1.strt_tm, table1.finishing_tm for a specific WORK_ID, Select the min(LAST_UPD_TMST) from table2 . Compare the min(LAST_UPD_TMST) to the WORK_DETAIL.strt_tm and WORK_DETAIL.finishing_tm. If it is bet...
by diamondabhi
Wed Apr 06, 2005 7:39 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Timestamp substraction
Replies: 9
Views: 2271

Timestamp substraction

Hi,
How can I substract 5 minutes from a timestamp and get the output.

Thanks in Advance,
Abhi
by diamondabhi
Mon Apr 04, 2005 9:45 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: NOT COLUMN OF INSERTED/UPDATED TABLE
Replies: 4
Views: 3047

Thanks Ray,

I just changed the Update action after close scrutiny and its working.

Thanks again for help.

Abhi.
by diamondabhi
Sat Apr 02, 2005 5:51 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: db2 timestamp to oracle timestamp
Replies: 4
Views: 1839

use Oconv(link.columnname"D D-M-Y,[,A3,2]")
by diamondabhi
Sat Apr 02, 2005 5:32 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: what does bin/uv mean
Replies: 10
Views: 2269

Hi anu,
You would find all the documentation in DataStage Admin Guide in online manuals of DS Documentation. :P
by diamondabhi
Sat Apr 02, 2005 5:29 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: NOT COLUMN OF INSERTED/UPDATED TABLE
Replies: 4
Views: 3047

Ray,
Thanks for the reply, but I am using the same column names and same data types, but invain.Can you please tell me would there be any other problem.

Thanks,
Abhi.
by diamondabhi
Fri Apr 01, 2005 3:10 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: what does bin/uv mean
Replies: 10
Views: 2269

hi,
The command would be bin>./uv -admin -start