Search found 53125 matches
- Wed Dec 12, 2007 7:38 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Calling routine inside a rotuine
- Replies: 7
- Views: 3032
- Wed Dec 12, 2007 7:36 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: TeraUtils:Fetch failed: Error Code = 227 [terautils.C:2863]
- Replies: 4
- Views: 3753
- Wed Dec 12, 2007 7:34 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Query About join stage in PX
- Replies: 8
- Views: 2622
- Wed Dec 12, 2007 7:32 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error Meaning
- Replies: 3
- Views: 1534
- Wed Dec 12, 2007 7:31 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Dataset's data file on database node
- Replies: 4
- Views: 1425
- Wed Dec 12, 2007 7:27 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Appending CRLF to data being read from a sequential file
- Replies: 6
- Views: 1317
Or, somewhat more simply:
You may even not need the second command here!
Code: Select all
gunzip filename ; cat - ; echo \r\nYou may even not need the second command here!
- Wed Dec 12, 2007 7:25 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to use the switch stage
- Replies: 2
- Views: 1588
- Wed Dec 12, 2007 7:24 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: main_program: Internal Error: (nP==nC)
- Replies: 2
- Views: 1236
- Wed Dec 12, 2007 7:20 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: OCI has fetched truncated data
- Replies: 10
- Views: 3554
It means that the default date format is the one you would get by executing the following query.
Code: Select all
SELECT CURRENT_DATE CONV 'D' FMT '20L' FROM VOC FIRST 1;- Wed Dec 12, 2007 7:16 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: CREATE.FILE usage for 64 bit hashed files
- Replies: 30
- Views: 7576
To do the CREATE TABLE method, you would use a UV stage and edit the DDL that it creates.
To delete a hashed file (not a table) created in a directory you have to remove not only the data portion but also the dictionary portion.
To delete a hashed file (not a table) created in a directory you have to remove not only the data portion but also the dictionary portion.
Code: Select all
rm -rf hashedfilename ; rm -f D_hashedfilename- Wed Dec 12, 2007 7:13 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Handling different metadata in runtime for the same table in
- Replies: 8
- Views: 2007
In particular, how do you learn the format of the source stream, from which you hope to be able to create the target table? And what database is this? There may be a bulk loader solution possible. At the same time that you create the table you create the bulk loader control file based on the same me...
- Wed Dec 12, 2007 1:46 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Selective reading Metadata versus using a copy stage/Modify
- Replies: 3
- Views: 1587
- Wed Dec 12, 2007 1:44 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to Re-INDEXED the Project
- Replies: 2
- Views: 1277
- Wed Dec 12, 2007 1:42 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error Meaning
- Replies: 3
- Views: 1534
- Wed Dec 12, 2007 1:38 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Routine
- Replies: 3
- Views: 1133