Search found 62 matches

by samba
Mon May 22, 2006 9:30 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Calling parameters from table
Replies: 1
Views: 893

Calling parameters from table

I dont have shell script
All the parameters are reside in the ds_parameters, when ever the sequence is running i need to call the parameters from table.

How to call the parameters from table to Job Sequence

Can any one please help me regarding this.
by samba
Mon May 22, 2006 8:52 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: sequencer
Replies: 6
Views: 2705

No I need to do it in Job Sequence itself
by samba
Sun May 21, 2006 10:47 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: sequencer
Replies: 6
Views: 2705

In Jobs what are the parameters i am passing for particular job, we need to insert thats parameters into table from the table we need to call the parameters to run job sequence the job sequence has to run in different envinorments suppose its running in development need to get the paramaters from de...
by samba
Sat May 20, 2006 5:38 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: sequencer
Replies: 6
Views: 2705

sequencer

In Job sequence i need to call the parameters from table. How to call suitable parameter for particular job

How to do this???
Can you please give me suggestion for this


Thanks in advance
by samba
Fri May 19, 2006 10:35 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Stages
Replies: 7
Views: 1932

HI Thanks for the information

I Generated dummy key column to get the information


Thanks
by samba
Fri May 19, 2006 10:17 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Stages
Replies: 7
Views: 1932

Can any one please help me
by samba
Fri May 19, 2006 10:00 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Stages
Replies: 7
Views: 1932

here i have one column in first dataset
and one more column in second dataset
i dont have any other columns, i need to get two columns into one dataset or Database
by samba
Fri May 19, 2006 9:58 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Stages
Replies: 7
Views: 1932

I dont have any key columns on two datasets
by samba
Fri May 19, 2006 8:18 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Stages
Replies: 7
Views: 1932

Stages

I have two datasets first dataset having the column names 1. JobName ----------- 2. JobNameresult JobName ------- XXXXX second dataset having the column names 1. Jobdesc ------- 2. Jobdescresult Jobdesc ------- xxxxxxx i have to load JobNameresult and JobdescResult into database the database is havi...
by samba
Thu May 18, 2006 12:49 pm
Forum: IBM<sup>®</sup> DataStage TX
Topic: column manipulation
Replies: 3
Views: 3574

column manipulation

I have two columns

ParaName ParaOutput
JobName xxxxx
JobStartTime xxxxx

I need to convert columns into rows..

how to convert, which stage i need to use

please help me
by samba
Thu May 18, 2006 12:37 pm
Forum: IBM<sup>®</sup> DataStage TX
Topic: Routine Generating file
Replies: 7
Views: 5067

Thanks for your help Its working now
by samba
Thu May 18, 2006 12:16 pm
Forum: IBM<sup>®</sup> DataStage TX
Topic: Routine Generating file
Replies: 7
Views: 5067

Thanks for you quick reply

Its Generating the output file like this

JobName2620060518og
by samba
Thu May 18, 2006 11:28 am
Forum: IBM<sup>®</sup> DataStage TX
Topic: Routine Generating file
Replies: 7
Views: 5067

Routine Generating file

i Build one routine, its generating one output file with file is as follows This is the code is generating below file name: code: JobName : oconv(@DATE, "D-YMD[4,2,2]") : "_" : oconv(@TIME, "MT") ".log" File Name :JobName_262006-05-18_12:12:10.log this file i ...
by samba
Wed May 17, 2006 10:10 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Regarding Routine
Replies: 4
Views: 2031

regarding routine

Can you please elaborate on what exactly do you mean by i tried to call routine in after job routine its not working Does that mean that the Routine is not giving the desired result or is failing to execute all together. Are you using the the Routine Activity to call the routine in the Sequence job...
by samba
Wed May 17, 2006 9:37 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Regarding Routine
Replies: 4
Views: 2031

Regarding Routine

I built one routine, after completion of every job it has to generate information regarding particular Job Routine is working in job sequence Job ----> Routine after completion of job i am calling particular routine like above mentioned format. Is there any best way to call routine? i tried to call ...