Search found 53125 matches

by ray.wurlod
Thu Sep 25, 2008 6:21 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: how to convert date type(2008-03-12) to date type(12-MAR-08)
Replies: 6
Views: 2135

If you have a parallel job question please post it in the parallel job (Enterprise Edition) forum.
by ray.wurlod
Thu Sep 25, 2008 6:19 am
Forum: IBM<sup>®</sup> DataStage TX
Topic: Hash file in Datastage
Replies: 2
Views: 2284

There are no hashed files in DataStage TX. Indeed, DataStage TX does not exist under that name any more.

You would do better to ask this question in the Server Edition forum.
by ray.wurlod
Thu Sep 25, 2008 5:14 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Generate Time Stamp Value
Replies: 7
Views: 3262

U didn't ask about generating timestamps. The user may not want the job start timestamp - the value required may be "now". For long-running jobs this can be quite different from the job start timestamp. In this case prefer Date() and Time() functions, because the system variables @DATE and @TIME are...
by ray.wurlod
Thu Sep 25, 2008 5:13 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Varchar to Date format
Replies: 42
Views: 10909

Please write in English.
by ray.wurlod
Thu Sep 25, 2008 5:10 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Reading asterisks instead of timestamp
Replies: 8
Views: 2120

Do the metadata properly describe the fractional seconds?

Are the delimiters within the "bad" timestamps "as advertised"?
by ray.wurlod
Thu Sep 25, 2008 5:08 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Sequecer Compilation Error
Replies: 2
Views: 1014

Had you bothered to Search DSXchange you would have learned that this error results from job sequence designs that contain no job activities. Yes, it's a bug, and the obvious workaround is to add a job that doesn't do anything (the statement X = 0 on the job control tab of a server job is a good "do...
by ray.wurlod
Thu Sep 25, 2008 5:06 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: SORT:Restrict Memory Usage
Replies: 5
Views: 5819

Memory usage is described in the manuals. First place it uses is the scratch disk specified in the configuration file. That is, it does not go to your swap device(s). There are unbounded and bounded VarChars, and they are handled slightly differently. But if you base your sizing on 100% fill factor,...
by ray.wurlod
Thu Sep 25, 2008 5:03 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Internal Error 39202 encountered
Replies: 1
Views: 1342

Search DSXchange for 39202, which decodes as "Slave failed to give server the Go Ahead message" (from UniVerse manual InterCall Developer's Guide Appendix B).
by ray.wurlod
Thu Sep 25, 2008 4:59 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Need to solve a small scenario which i couldn't get
Replies: 12
Views: 3678

You could use an Aggregator stage if you like, but it won't produce the required output.
:roll:
by ray.wurlod
Thu Sep 25, 2008 4:58 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: how to convert date type(2008-03-12) to date type(12-MAR-08)
Replies: 6
Views: 2135

The Oconv() that Arnd gave you won't give quite the result you seek. Its second argument needs to be "D2-DMBY" or "D-DMY[2,3A,2]".
by ray.wurlod
Thu Sep 25, 2008 4:56 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: how to convert date type(2008-03-12) to date type(12-MAR-08)
Replies: 6
Views: 2135

But U did not ask the question.

The second person personal pronoun in its nominative form in English is spelled "you".
by ray.wurlod
Thu Sep 25, 2008 4:55 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Problem with Routine Calls
Replies: 15
Views: 4271

Put the DEFFUN at the top and don't use AbortNumber as the placeholder. Use X, or Arg1, or anything that's not in use elsewhere.
by ray.wurlod
Thu Sep 25, 2008 4:53 am
Forum: General
Topic: uv help error Could not locate NLS map
Replies: 2
Views: 1541

UV.SAVEDLISTS is a pointer to the &SAVEDLISTS& file (directory) in the UV account. If you have NLS enabled, then DataStage/UniVerse searches for a hidden file called .nlsmap in the directory. If one can not be found, then this error can occur. You may need to reinstate the .nlsmap file. If y...
by ray.wurlod
Thu Sep 25, 2008 12:27 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to convert sting to date(DD-MMM-YY)
Replies: 2
Views: 3288

Perhaps you should ask Gordon Sumner. Using StringToDate() you must provide the format of the string - that is, the format in which the string is being provided. In your case you also need to remove the date component from your longer string that also includes the time. So you need something like: S...
by ray.wurlod
Thu Sep 25, 2008 12:24 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Data mismatch issue with DB2
Replies: 4
Views: 1298

Ur was a city in ancient Babylonia. The second person personal pronoun in its possessive form is spelled "your" in English. Please maintain a professional standard of written English on DSXchange. If the problem is resolved then, as its originator, it's your task to mark the thread as Resolved usin...