Search found 224 matches

by attu
Fri Jun 15, 2007 9:25 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: job sequence
Replies: 16
Views: 5274

Thanks for the help,

The script will load data into a table which will be used by the next job, in that case after the script finishes running and moves on to the next job and if the table is still being loaded. How will it affect the next job?
Any thoughts on this


Thanks
by attu
Thu Jun 14, 2007 11:01 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: job sequence
Replies: 16
Views: 5274

thnx Craig,

for every job activity stage i have routine activity stage attached and an execute command stage attached, but the next job in the sequence should only run when the script in the execute command stage finishes ...how would i accomplish this?

any suggestions

thanks
by attu
Thu Jun 14, 2007 10:35 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: job sequence
Replies: 16
Views: 5274

Craig,
Thanks for your prompt reply

So I should use an after job sub routine at the job level. right?

is it a best practice ?
by attu
Thu Jun 14, 2007 10:25 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: job sequence
Replies: 16
Views: 5274

job sequence

I have 4 jobs and after each job completes i need to run a script , i need to know whether i can use before after sub routine in each job or in the job sequence i can use execute command stage.

Thanks all
by attu
Tue Jun 05, 2007 2:51 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: moving records from seq file to netezza table
Replies: 1
Views: 780

moving records from seq file to netezza table

Hi,
Can someone help me out with the follwing error message

When checking operator: When validating export schema: At field "CHR_SRC_ID": Exporting nullable field without null handling properties
Thanks[/b]
by attu
Tue Jun 05, 2007 9:03 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: julian to timestamp
Replies: 6
Views: 2310

Thanks Ray and Josh...

The julian date is coming as an integer and the expected result is a timestamp date.
2007-04-22 00:00:00

I would be using Datefromjulianday but the date coming is an integer?
how would i transform that.

Any thoughts
Thanks
by attu
Mon Jun 04, 2007 3:38 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: julian to timestamp
Replies: 6
Views: 2310

julian to timestamp

how to convert 2454282 julian date to timestamp yyyy-mm-dd- 00:00:00
i am using basic transformer and
Oconv(Iconv(InLink.InputColumn, "DYJ"), "D-YMD[4,2,2]"):'00:00:00'.
what kind of julian dates are they 2454275,2454296?
any help is appreciated thanks.
by attu
Wed Jan 10, 2007 6:17 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: what is SIGINT
Replies: 4
Views: 2750

Thanks guys
by attu
Wed Jan 10, 2007 4:10 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Heap Allocation failure
Replies: 2
Views: 1758

Heap Allocation failure

hi, Can some one explain why do we get this kind of error message.
APT_CombinedOperatorController(),0: Fatal Error: Throwing exception: APT_BadAlloc: Heap allocation failed.[/b]

Thanks
by attu
Wed Jan 10, 2007 4:03 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: what is SIGINT
Replies: 4
Views: 2750

what is SIGINT

Hi Guys,

What is this error?

main_program: ORCHESTRATE step execution terminating due to SIGINT
Parallel job was aborted
by attu
Tue Nov 22, 2005 10:08 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Job Sequences
Replies: 4
Views: 2771

chulett wrote:Exactly.
Thank you very much Sir.
by attu
Tue Nov 22, 2005 9:52 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Job Sequences
Replies: 4
Views: 2771

chulett wrote:Sure, create a new Sequence that runs the nine.
Thanks for the reply, So I will use a JOb activity for each sequencer, right?
by attu
Tue Nov 22, 2005 9:44 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Job Sequences
Replies: 4
Views: 2771

Job Sequences

I have 9 Job Sequences and I want to run all the Job Sequences in one Sequenece. Is that possible?
Appreciate any post in this regard.
Thanks
by attu
Fri Oct 21, 2005 9:21 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Phantom Aborting with @ABORT.CODE = 1
Replies: 3
Views: 2972

Phantom Aborting with @ABORT.CODE = 1

DataStage Job 378 Phantom 8288
DataStage Phantom Aborting with @ABORT.CODE = 1