Search found 53125 matches

by ray.wurlod
Fri May 08, 2009 2:28 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to ignore warning......in sequencer
Replies: 4
Views: 1954

You can't eliminate it. The activity expired its given timeout period and has to alert you of that fact. Emplace an explicit Failure trigger on the WaitForFile activity to handle the situation, but you can't eliminate the warning. You can, however, use a local message handler to demote its severity ...
by ray.wurlod
Thu May 07, 2009 11:45 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Distinct of a query not retrieving correct result
Replies: 14
Views: 3284

Please strive for a professional standard of written English on DSXchange. Put yourself in the position of someone whose first language is not English wasting time looking up "ecjjactly" in a translation dictionary. And please refrain from frequent use of ...mate... - it does not contribu...
by ray.wurlod
Thu May 07, 2009 11:41 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Warning while running the job
Replies: 6
Views: 1856

What are the data type, precision and scale setting for Field 6?
by ray.wurlod
Thu May 07, 2009 11:40 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: data with double quote
Replies: 4
Views: 1358

It's a difficult problem to solve generically - it's easy if the extraneous double-quote character is at either end of the string, but what if it's in the middle?
by ray.wurlod
Thu May 07, 2009 11:38 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Can Data set be accessed from any external editor
Replies: 9
Views: 1937

datastage_learner wrote:u can read those... am I right? :wink:
No.

Whatever Sudeep does will not enable U to read anything.
by ray.wurlod
Thu May 07, 2009 11:36 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Regarding LOG file
Replies: 6
Views: 2108

datastage_learner wrote:What you want to read in log files
There is no such thing as a log file in DataStage repository.
by ray.wurlod
Thu May 07, 2009 11:33 pm
Forum: General
Topic: warning while running a job
Replies: 10
Views: 4140

I doubt it. U has not logged in for some weeks. The second person personal pronoun in English is spelled "you", not "u". We strive for a professional standard of written English on DSXchange, primarily to make life a little easier for those whose first language is not English, bu...
by ray.wurlod
Thu May 07, 2009 11:30 pm
Forum: General
Topic: Datastage certification cost
Replies: 12
Views: 12539

Among other things you need to guarantee IBM a certain amount of income per year. It's not a small amount.
by ray.wurlod
Thu May 07, 2009 11:29 pm
Forum: General
Topic: warning while running a job
Replies: 10
Views: 4140

Try posting the question in the correct forum, so we get some idea of what version, what platform and what job type you are using.
by ray.wurlod
Thu May 07, 2009 9:58 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Lookup vs Join
Replies: 5
Views: 1917

There's no such thing as a reject from a join, in exactly the same way that there's no "reject" when you perform a join in SQL.
by ray.wurlod
Thu May 07, 2009 9:48 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Date format
Replies: 5
Views: 1254

sbass1 wrote:Does this do what you want?

Code: Select all

Ans = oconv(iconv(Arg1,"DMDY[2,2,4]"),"DMDY/[1,1,4]") 
Not in a parallel Transformer stage. Iconv() and Oconv() are not supported.
by ray.wurlod
Thu May 07, 2009 9:45 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Looping through a range of dates
Replies: 4
Views: 3967

The counted loop is only for integers. You may wish to convert your dates upstream to an internal, or Julian, format.
by ray.wurlod
Thu May 07, 2009 6:49 pm
Forum: General
Topic: Client licensing clarification
Replies: 5
Views: 1487

Even more obtuse than that. Let's say five people are connected. A ten-user license connects, there are now six people connected and the limit is ten. A five-user license then attempts to connect... That user gets successfully connected, and there are seven people connected. BUT the limit is now res...
by ray.wurlod
Thu May 07, 2009 5:07 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Cross join
Replies: 5
Views: 2801

Another possibility is to use an ODBC stage, with the DSN using the driver for text files.
by ray.wurlod
Thu May 07, 2009 5:06 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Can we export joblog to a file
Replies: 27
Views: 11793

Did you even bother to look at the link Craig posted, or do you just want everything handed to you on a silver platter?