Search found 53125 matches
- Tue Feb 26, 2008 5:56 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Row Counts
- Replies: 6
- Views: 1572
- Tue Feb 26, 2008 5:53 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Checking the path of DS services
- Replies: 1
- Views: 827
- Tue Feb 26, 2008 5:48 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Making data run on multiple lines
- Replies: 10
- Views: 2370
- Tue Feb 26, 2008 5:47 am
- Forum: General
- Topic: Export, import, delete an empty job
- Replies: 15
- Views: 3020
- Tue Feb 26, 2008 3:55 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: month from date
- Replies: 5
- Views: 1943
If you have a Date column is does NOT have a format: your Sequential File stage specifies the date format in the file and the import operator looks after it. If it's a Char or VarChar data type then the format is important. There are date conversion functions both for the Modify stage and for the Tr...
- Tue Feb 26, 2008 3:52 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Date Conversation
- Replies: 3
- Views: 1194
Source is VarChar while target is Date. Date does NOT have a format.
Therefore should suffice.
Therefore
Code: Select all
StringToDate(Trim(LNK_Read_Input.IND_DT), "dd-%mmm-%yy")- Tue Feb 26, 2008 3:50 am
- Forum: General
- Topic: Export, import, delete an empty job
- Replies: 15
- Views: 3020
Can you see the dummy job post-import? If not, try the query It may be that there's a job called dummy in some other category, which should throw an error if you try to import the same job name into another category.
Code: Select all
SELECT NAME, JOBNO, CATEGORY FROM DS_JOBS WHERE NAME = 'dummy';- Tue Feb 26, 2008 2:34 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Calling oracle sequence
- Replies: 3
- Views: 1469
- Tue Feb 26, 2008 2:33 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Failed a keylookup for record.(Shared Container)
- Replies: 1
- Views: 811
- Tue Feb 26, 2008 2:31 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Director Getting Closed Abruptly when viewing log in detail
- Replies: 8
- Views: 2490
- Tue Feb 26, 2008 12:22 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: how we can remove duplicates in transformer stage
- Replies: 10
- Views: 4330
- Mon Feb 25, 2008 11:45 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: how we can remove duplicates in transformer stage
- Replies: 10
- Views: 4330
- Mon Feb 25, 2008 11:43 pm
- Forum: General
- Topic: DataStage Health Check
- Replies: 4
- Views: 2709
Define "not performing". The only permanently-running process is the dsrpcd (DataStage RPC daemon). It is a listener, so tends not to use much in the way of resources. Optionally you may have the job monitor (a Java application JobMonApp) running for parallel jobs, and the DataStage deadlock daemon ...
- Mon Feb 25, 2008 11:14 pm
- Forum: General
- Topic: Unable to connect to Host
- Replies: 2
- Views: 1019
- Mon Feb 25, 2008 11:12 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: phantom
- Replies: 1
- Views: 755