Search found 53125 matches
- Wed Oct 18, 2006 11:47 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: RE:Error
- Replies: 2
- Views: 1123
- Wed Oct 18, 2006 11:46 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to do look for the greater than or less than date ranges
- Replies: 7
- Views: 2132
- Wed Oct 18, 2006 11:45 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Problem running osh shell
- Replies: 7
- Views: 2060
- Wed Oct 18, 2006 11:43 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Advice on generating OSH script
- Replies: 10
- Views: 3738
- Wed Oct 18, 2006 11:39 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Wanted to Capture the link status
- Replies: 8
- Views: 1955
- Wed Oct 18, 2006 11:37 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: need for loop in basic code
- Replies: 14
- Views: 5526
- Wed Oct 18, 2006 11:29 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Passing before routine output in the datastage job parameter
- Replies: 11
- Views: 8777
- Wed Oct 18, 2006 11:25 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Maximum and Minimum JOBNO in a project
- Replies: 9
- Views: 2132
All the UniVerse manuals.
- Wed Oct 18, 2006 6:49 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Upgrade to 8.0 for Server-only sites
- Replies: 5
- Views: 1114
Upgrade to 8.0 for Server-only sites
I asked Keith Kohl, product manager for DataStage, this question. The answer is that the cost is $0 provided you are on maintenance. You will get the Information Server and a DataStage server-job-only licence. The licensing scheme is changed - no more auth codes. Instead, they send you an XML file a...
- Wed Oct 18, 2006 6:46 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to avoid this warning
- Replies: 3
- Views: 1052
- Wed Oct 18, 2006 6:43 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: how to avoid this warning
- Replies: 3
- Views: 2329
- Wed Oct 18, 2006 5:01 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Job failure: lookups on datasets
- Replies: 6
- Views: 1503
- Wed Oct 18, 2006 4:57 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to read .dtl files
- Replies: 15
- Views: 4748
- Wed Oct 18, 2006 4:55 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Null Handling: High Values
- Replies: 4
- Views: 985
- Wed Oct 18, 2006 4:52 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Maximum and Minimum JOBNO in a project
- Replies: 9
- Views: 2132
That's because JOBNO has a data type of VarChar. Try:
or
Code: Select all
SELECT MAX(CAST(JOBNO AS INTEGER)) FROM DS_JOBS;Code: Select all
LIST DS_JOBS MAX JOBNO DET.SUP