Num() function will report whether the data is numeric. You can also use the Matches operator - for example Matches 1N0N.
Finally you can use oconv(string,"MC/N") and see if there's anything remaining.
Search found 53125 matches
- Mon Oct 13, 2008 1:34 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Data validation
- Replies: 1
- Views: 1111
- Sun Oct 12, 2008 3:07 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Routine hangs
- Replies: 13
- Views: 3609
- Sun Oct 12, 2008 1:57 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Routine hangs
- Replies: 13
- Views: 3609
A useful trick
The NUL file (or /dev/null if you're on UNIX) can deliver an infinite number of "presses of Enter". Try something like the following if default answers are OK. Call DSExecute('DOS', '7z x ' : Filedir : '\' : ZipFile : " < .\NUL", Output, ReturnCode) Ans = Output
- Sun Oct 12, 2008 1:54 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Routine called from job transformer -> abnormal terminati
- Replies: 10
- Views: 5998
- Sun Oct 12, 2008 1:52 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: outerjoin worked but not lookup
- Replies: 1
- Views: 802
- Sun Oct 12, 2008 1:51 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Datastage repository interface and Universe
- Replies: 1
- Views: 945
Welcome aboard. This question is too vague. The structure of the Repository is intentionally sparsely documented by the vendor. The DataStage Repository has not been UniVerse since version 5.2; if you want to know more about UniVerse then I suggest you visit IBM's website for UniVerse and UniData
- Sun Oct 12, 2008 1:48 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Dataset read - Unknown Error Reading Data
- Replies: 15
- Views: 5092
- Fri Oct 10, 2008 1:21 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Spliting data using transformer vs filter stage
- Replies: 6
- Views: 1922
- Fri Oct 10, 2008 1:15 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: how to use mathamatical function of Exp in datastage
- Replies: 5
- Views: 2566
- Fri Oct 10, 2008 7:23 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Scheduling Jobs at V8
- Replies: 3
- Views: 966
- Fri Oct 10, 2008 7:17 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Usage of LOG.SAVE
- Replies: 2
- Views: 1098
- Fri Oct 10, 2008 7:14 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: how to use mathamatical function of Exp in datastage
- Replies: 5
- Views: 2566
- Thu Oct 09, 2008 8:03 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: delimiter string in schema file definition
- Replies: 2
- Views: 3117
- Thu Oct 09, 2008 7:54 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: OCI stage assuming null for field containing only one space
- Replies: 2
- Views: 1390
APT_STRING_PADCHAR is not relevant to VarChar data types. Why do you claim that "OCI stage assuming null for field containing only one space"? What is populated into the table (use a query with NVL function) or, if there is an error message, please post that. In short, debug! Send (a relevant sample...
- Thu Oct 09, 2008 7:52 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Restore purge settings
- Replies: 10
- Views: 2582
If it's in VOCLIB, then
It it's not in VOCLIB but is in another job log, then
Note that neither of these is SQL, so there is no terminating semi-colon.
Code: Select all
COPY FROM VOCLIB TO RT_LOGnnn '//PURGE.SETTINGS'It it's not in VOCLIB but is in another job log, then
Code: Select all
COPY FROM RT_LOGkkk TO RT_LOGnnn '//PURGE.SETTINGS'Note that neither of these is SQL, so there is no terminating semi-colon.