Search found 42189 matches

by chulett
Fri May 23, 2008 7:08 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Datastage Command for scheduling
Replies: 11
Views: 2230

I assume we're talking about DSR.SCHED. Called from the dsr_sched.sh script in cron.
by chulett
Fri May 23, 2008 6:53 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Project currently locked
Replies: 23
Views: 11396

Basically yes, the same. Only 'wrong' thing might be if you logged out the wrong PID, I suppose. :wink:
by chulett
Thu May 22, 2008 9:35 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: row splitter stage
Replies: 6
Views: 2825

New but did you get any training or were you just thrown straight into the deep end of the pool? Per the documentation, the RowSpitter stage "Reads one row at a time, splits the data fields contained in a string into a number of columns, and then writes the columns to the output link". In other word...
by chulett
Thu May 22, 2008 8:57 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: row splitter stage
Replies: 6
Views: 2825

Welcome! First question would be - have you read the documentation on the stage? You should be able to find a 'rowsplit.pdf' in the Docs directory on your pc. For example, one question answered there - the derivation column is not used.
by chulett
Thu May 22, 2008 8:48 am
Forum: General
Topic: Change Source From Oracle to Other DataBase
Replies: 2
Views: 955

Nope. There's no escaping the need to modify the job and replace the stage.
by chulett
Thu May 22, 2008 7:24 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Read in a mail box
Replies: 6
Views: 1599

Yes, you are correct and that is what we are talking about.
by chulett
Thu May 22, 2008 7:04 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Stored Procedure Stage
Replies: 3
Views: 1500

A couple of problems...

1. You can't "make up" a database vendor. If something isn't there, it isn't there.

2. SQL Server is Windows only.

http://www.sommarskog.se/mssqlperl/unix.html
by chulett
Thu May 22, 2008 7:03 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Read in a mail box
Replies: 6
Views: 1599

You mean Notes? Ugh. Is there a command line interface for that?
by chulett
Thu May 22, 2008 6:54 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Oracle Remote Server
Replies: 3
Views: 1382

Re: Oracle Remote Server

sanjay wrote:we are using Oracle Enterprise Stage with Remote Server option its working fine but we have ETL and database in same server.

Then it's not really 'remote', there's no 'network' involved and your problem is solved! :wink:
by chulett
Thu May 22, 2008 6:48 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to use Email Notification?
Replies: 2
Views: 1193

In other words, the email body in the Notification Activity stage doesn't support dynamic contents. If you don't feel like writing your own routine to send any kind of email you want, perhaps this... What I've done in the past is build your list of files details into a .csv file and attached it to t...
by chulett
Thu May 22, 2008 6:36 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Project currently locked
Replies: 23
Views: 11396

Search the forums for DS.TOOLS and use the 'logout' option there as 'dsadm' to clear those old pids. It's under '4' then '9' from what I recall.
by chulett
Thu May 22, 2008 6:33 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: UNIX variable in Parallel job
Replies: 11
Views: 3091

Your problem here doesn't really make much sense. I'm worried it may be '8 specific' and that if I build a test case and it works fine here under 7.5.2 that it won't really prove all that much. At the moment, I'm going to defer to those running 8 to see if they can help. You could also open a case w...
by chulett
Thu May 22, 2008 6:28 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Using environment varaible in the job paramter
Replies: 6
Views: 2308

avneeshrai wrote:So is there a work around for this issue, I did try just $ParamName and it too returns error, as expected.

Can you please explain exactly how you tried this and what error you are now getting? I hate to assume too much here.
by chulett
Thu May 22, 2008 6:26 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Job reads its own link counts
Replies: 12
Views: 5537

Actually, Ray's mention of 'periodic updates' was while the job was running. Arnd mentioned that the only safe place to get those stats was at 'end of job', meaning once it had completed, so I assume Ray was clarifying the why of the what. I was curious what exact 'practice' Cr.Cezon was asserting t...
by chulett
Thu May 22, 2008 6:18 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Email sending with attachment
Replies: 10
Views: 2990

What 7.x version? 7.5 adds an attachment option to the Notification Activity stage, hence the question.