Search found 162 matches

by laknar
Thu May 03, 2007 10:37 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to run jobs Parallely in Batch Jobs
Replies: 5
Views: 1989

Please provide me sample batch script
by laknar
Thu May 03, 2007 9:01 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to run jobs Parallely in Batch Jobs
Replies: 5
Views: 1989

How to run jobs Parallely in Batch Jobs

I would like to run some jobs at the same time.

Please how to run?
by laknar
Thu May 03, 2007 1:18 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to establish a connection to DB in Batch Jobs
Replies: 6
Views: 1683

i want to call all the variables in DB insert statement like

Jobstarttime
Joblasttime
Jobelapsedtime
Rundate

how to call that in batch jobs.
by laknar
Wed May 02, 2007 1:01 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to establish a connection to DB in Batch Jobs
Replies: 6
Views: 1683

I declared a variable in First job like jobstarttime etc

* Setup A, run it, wait for it to finish, and test for success hJob1 = DSAttachJob("A", DSJ.ERRFATAL) If NOT(hJob1) Then Call DSLogFatal("Job Attach Failed: A", "JobControl") Abort End ErrCode = DSSetDisableProjectHandler(hJob1, @FALSE) ErrCode = DSSetDisableJobHandler...
by laknar
Mon Apr 30, 2007 1:40 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to establish a connection to DB in Batch Jobs
Replies: 6
Views: 1683

How to establish a connection to DB in Batch Jobs

Hi,

I would like to establish a connection to DB2 Db in Batch job

Iam trying to insert (Jobstarttime,jobendtime , job elapsed time and current date) into Db in the Batch job.

How to execute a script in Batch Jobs
by laknar
Sun Apr 29, 2007 10:28 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Scheduling jobs using Unix Script
Replies: 5
Views: 1646

Scheduling all the jobs in a Project

Schedule "an entire Project"? Besides that fact that you don't really do that from a UNIX script, I'm not really sure what that means - and I can't imagine anyone needing to do that if I'm guessing right. :? How about you explain what exactly it is you think you need to do? Take a little ...
by laknar
Fri Apr 27, 2007 11:19 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Scheduling jobs using Unix Script
Replies: 5
Views: 1646

Scheduling jobs using Unix Script

I know how to run the job from command line.

can any provide to schedule entire project using Unix Shell Script.

Please provide me Unix Shell Script to Schedule a Project.

Because i am new to Unix.Pls
by laknar
Fri Apr 27, 2007 10:16 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Reports to Database
Replies: 6
Views: 1549

can you explain step by step to implement the same

kduke wrote:EtlStats will generate all jobs, all jobs in a sequence. Take that code and modify it to meet your needs.

Hi i found in the Duke site but there are lot of sqls and Jobs.

can you explain step by step to implement the same .Please
by laknar
Thu Apr 26, 2007 1:05 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Parameters
Replies: 4
Views: 1088

i tried to search but iam not able to find exact solution topic in forum.

please help me regarding this.
by laknar
Thu Apr 26, 2007 12:49 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Can we export joblog to a file
Replies: 27
Views: 16116

Can you give step by step code to store the log details into Excel file

Please provide me code.

In parallel jobs is preferrable.

Thanks & Regards,
laknar
by laknar
Thu Apr 26, 2007 11:38 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Parameters
Replies: 4
Views: 1088

Parameters

how can i give parameters i.e Third Party tools

or is there any command for giving parameters from outside the job

if possible Please explain me how it works
by laknar
Thu Apr 26, 2007 6:25 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Reports to Database
Replies: 6
Views: 1549

Reports to Database

I would like to generate reports for entire project or folder thru command line

cmd : dsjob -report (project name)

can any one help me how to generate reports for particular folder.

and How can i redirect the reports into database.