Search found 110 matches

by kirankumarreddydesireddy
Thu Feb 03, 2011 3:36 am
Forum: General
Topic: How to store Job start time,end time,job name in Oracle
Replies: 51
Views: 44580

Thanks Shruthi.I have included this after job subroutine.can you please let me know what is the "input value" i need to pass in the Job properties tab.

Thanks
Kiran
by kirankumarreddydesireddy
Thu Feb 03, 2011 12:37 am
Forum: General
Topic: How to store Job start time,end time,job name in Oracle
Replies: 51
Views: 44580

Thanks Ray

Since our environment is highly secured,we should'nt dowload any external applications.

Can we get this info by writing a rouitne and calling this after the job is executed

Do anyone have this routine ready with them?

Thanks
Kiran
by kirankumarreddydesireddy
Thu Feb 03, 2011 12:26 am
Forum: General
Topic: How to store Job start time,end time,job name in Oracle
Replies: 51
Views: 44580

Yes.but how to get end date and time?




Thanks
Kiran
by kirankumarreddydesireddy
Wed Feb 02, 2011 11:57 pm
Forum: General
Topic: How to store Job start time,end time,job name in Oracle
Replies: 51
Views: 44580

How to store Job start time,end time,job name in Oracle

Hi, After completing of my job execution,how to store the job name,job start date and time and end date and time in to oracle. If it is in unix environment,I know to get this information using dsjob - report functionality But we are using Windows environment.Can anyone please suggest me. Thanks Kiran
by kirankumarreddydesireddy
Thu Jan 27, 2011 11:11 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Reagrding xls file as source in Datastage Job
Replies: 2
Views: 2108

Reagrding xls file as source in Datastage Job

Hi

I have a requirement to read from excel file(.xls file).Can anyone please let me know how to do this Datastage job and which stage to use.

I think we can do it in ODBC stage but I am not sure.




Thanks
Kiran
by kirankumarreddydesireddy
Thu Jan 27, 2011 5:33 am
Forum: General
Topic: Regarding VB script in datasage
Replies: 3
Views: 1961

Regarding VB script in datasage

Hi



We are using Datastage 7.5 server version.OS windows 2003.
Can we call VB script in execute command stage?




Thanks
Kiran
by kirankumarreddydesireddy
Tue Jan 25, 2011 5:20 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: logic implementation
Replies: 2
Views: 1234

Thanks nayan




Thanks
Kiran
by kirankumarreddydesireddy
Tue Jan 25, 2011 3:04 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: logic implementation
Replies: 2
Views: 1234

logic implementation

Hi I have requirement as below. Source Cash_receipt_id Amount 200 500 201 500 Lookup Status Amount Cash_receipt_id Cash_history_receipt_id Cleared 500 200 1000 Reversed 500 200 1001 Cleared 500 201 1002 Target (only one cash_receipt_id ) Cash_receipt_id Net receipt Amount 200 0 201 500 Can any one p...
by kirankumarreddydesireddy
Mon Jan 24, 2011 3:08 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Regarding Oracle as Metadata repository Infosphere 8.5
Replies: 2
Views: 1592

Regarding Oracle as Metadata repository Infosphere 8.5

Hi I am trying to install Infosphere Datastage server 8.5v.We have windows server 2003 enterprise edition. We are planning to use Oracle as our Metadata Repository. Please let me know Is it mandate that we need to install Oracle 10g Server? or Is it fine that we install Oracle client on this windows...
by kirankumarreddydesireddy
Thu Jan 20, 2011 3:19 am
Forum: General
Topic: Regarding Oracle as Metadata Repository V8.5 Infosphere
Replies: 1
Views: 1136

Regarding Oracle as Metadata Repository V8.5 Infosphere

Hi We are planning to install Infosphere Datastage server v8.5 in our project.I am new to installation.We have decided to use Oracle as our Metadata Repository. Can anyone please let me know if we need to install either Oracle 11g R2 Server? or Client? so that we use as our Metadata Repository. Than...
by kirankumarreddydesireddy
Tue Dec 28, 2010 6:25 am
Forum: General
Topic: Datastage 8.1 Installation Error (FdatastageEngine34023)
Replies: 4
Views: 2882

Hi Vivek

Did you get the error FDataStageEngine34023 fixed?If yes .can you please let me know the solution.



Thanks
Kiran
by kirankumarreddydesireddy
Fri Dec 17, 2010 3:03 am
Forum: General
Topic: Datastage server 8.1 installation error
Replies: 1
Views: 1762

Datastage server 8.1 installation error

Hi Ray I got the below error while installing(at 63 percent)DataStageSvr_v8.1_WinSvr2003.Some part of the log file created says DataStage server Build Info --------------------------------------------------------------------- BUILD_DATE=Fri Aug 22 18:35:20 2008 BUILD_VERSION=8.1.0.0 BUILD_MACHINE=WI...
by kirankumarreddydesireddy
Fri Dec 17, 2010 2:58 am
Forum: General
Topic: Datastage server 8.1 installation
Replies: 3
Views: 3233

Licensing is now on an honesty system. Check only those components that you have actually purchased. If, when IBM audits your site (which the licensing agreement allows them to do), they find you us ... Thanks Ray. As per analysis,I got to know that the PX edition is Infosphere Information Server 8...
by kirankumarreddydesireddy
Fri Dec 17, 2010 12:13 am
Forum: General
Topic: Datastage server 8.1 installation
Replies: 3
Views: 3233

Datastage server 8.1 installation

Hi Can you suggest me what to checkin(while installing) among the below components if I need to install the Datastage server 8.1 edition only? (Websphere Business Glosary,Websphere Business Glosary Anywhere,Websphere Datastage and Qualitystage,Information Server FastTract,Webphere Information Analyz...