Search found 55 matches

by Amar_nath
Thu May 18, 2006 5:47 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to control the load sequence of transformer outputs
Replies: 7
Views: 2163

Yes, after loading of OD1 is completed then only OD2 's loading should be started .
by Amar_nath
Thu May 18, 2006 5:03 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to control the load sequence of transformer outputs
Replies: 7
Views: 2163

hey that just changes the sequence of links,
but the loading is done simultaneously but I want to change the order of loading the tables.
by Amar_nath
Thu May 18, 2006 3:18 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to control the load sequence of transformer outputs
Replies: 7
Views: 2163

How to control the load sequence of transformer outputs

hi all, In a job I am loading data from one ODBC. I have a trnsformer with two output links connecting to ODBC stages OD1 and OD2. I want to load the data in OD1 first and then in the OD2 (constraints are in transformer) Is there any functionality for sequencing the loading of target stages ? thanx ...
by Amar_nath
Thu May 18, 2006 12:43 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Built in function to add months in a date
Replies: 8
Views: 4676

Built in function to add months in a date

hello all, I am very new to DS Is there any Inbuild function in DS to add number of months to a date so it will give the resulting date. Example : date is 12/4/2001 if i want add 25 months in it it should give resulting date as : 12/5/2003 So is there any inbuild function for that ? Thanx in advance,
by Amar_nath
Wed May 17, 2006 5:41 am
Forum: IBM<sup>®</sup> DataStage TX
Topic: specific function to add months in a date
Replies: 26
Views: 19307

Hi Ashwin,

I think the problem is not clear, let me clear by am ex.

Example : date is 12/4/2001
if i want add 25 months in it
it should give resulting date as : 12/5/2003

So is there any inbuild function for that ?

thanx.
by Amar_nath
Wed May 17, 2006 5:13 am
Forum: IBM<sup>®</sup> DataStage TX
Topic: specific function to add months in a date
Replies: 26
Views: 19307

specific function to add months in a date

hello all,

I am very new to DS

Is there any Inbuild function in DS to add number of months to a date so it will give the resulting date.

Thanx in advance,
by Amar_nath
Fri Apr 21, 2006 12:07 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to connect DS cleint with DB2 on the server
Replies: 2
Views: 874

How to connect DS cleint with DB2 on the server

hello,

I am new to DS,

I am having a unix server for DS on which DB2 installed

now I want to connect to Sample db in DB2 in server job

I kno how to connect throgh Command Line Tools in DB2 but from DS how to use the Tables present in database on DB2 server

suggetions ??
by Amar_nath
Wed Apr 19, 2006 4:53 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Error in Merge stage(Sequential files)
Replies: 3
Views: 1601

Error in Merge stage(Sequential files)

I am currently dealing with Server Jobs only I have taken 1 merge stage output is linked to a Seq file. I have entered names of two existing Seq files in the input of the merge stage.And mapping is done on Primary key the error message is :- MergeSeqFiles..Merge_0: Error opening first input file Mer...
by Amar_nath
Wed Apr 19, 2006 1:56 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to join(merge) two sequential files?
Replies: 4
Views: 2146

Welcome aboard. :D This is precisely the function of the Merge stage in server jobs. It can perform inner joins as well as outer joins. I have tried for that but its not permitting me to link Seq file directly to Merge(in Palette->Merge) it gives error "The destination stage does not support s...
by Amar_nath
Wed Apr 19, 2006 1:31 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to join(merge) two sequential files?
Replies: 4
Views: 2146

How to join(merge) two sequential files?

hi ,
i am new user of DS

I want to merge 2 seq files on a primary key

1st seq file contains - EmpName,EmpNo,Dept
2nd seq file contains - EmpNo,BasicSal

so i want a target file which contains-EmpName,EmpNo,Dept,BasicSal

reply soon.