Search found 53125 matches
- 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
- Thu Sep 25, 2008 6:19 am
- Forum: IBM<sup>®</sup> DataStage TX
- Topic: Hash file in Datastage
- Replies: 2
- Views: 2284
- 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...
- Thu Sep 25, 2008 5:13 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Varchar to Date format
- Replies: 42
- Views: 10909
- 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
- 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...
- 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,...
- 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).
- 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
- 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
- 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
- Thu Sep 25, 2008 4:55 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Problem with Routine Calls
- Replies: 15
- Views: 4271
- Thu Sep 25, 2008 4:53 am
- Forum: General
- Topic: uv help error Could not locate NLS map
- Replies: 2
- Views: 1541
- 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...
- 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...