Search found 42189 matches
- Wed Nov 21, 2007 7:42 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: NLS SETTINGS?
- Replies: 5
- Views: 1871
- Wed Nov 21, 2007 6:47 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: XML Input
- Replies: 5
- Views: 2278
- Wed Nov 21, 2007 6:43 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: array size and transaction size
- Replies: 3
- Views: 1343
- Wed Nov 21, 2007 6:40 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: DATA TYPE COMPATABILITY
- Replies: 3
- Views: 1448
- Wed Nov 21, 2007 6:38 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: OCI has fetched truncated data
- Replies: 4
- Views: 1240
- Wed Nov 21, 2007 6:36 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Error While Creating Sequencer
- Replies: 4
- Views: 1513
- Wed Nov 21, 2007 6:35 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Determining which cpu performs which process in a Job
- Replies: 6
- Views: 1683
- Wed Nov 21, 2007 6:32 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: 7.5.1.A Can't Compile my 7.5 Sequences
- Replies: 1
- Views: 695
- Wed Nov 21, 2007 6:30 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Optimisation of hashed file population
- Replies: 7
- Views: 2086
A little lost... So, you're not using the hashed file to 'aggregate' or 'de-dup' the data, it is the actual target of these jobs? Meaning, the goal is to build these hashed files, yes, not use them in some intermediate fashion? And you have like data from three different tables being collected befor...
- Wed Nov 21, 2007 6:22 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: How to Run a Query on Hashed Files using Command Line
- Replies: 3
- Views: 1084
You would need to create a VOC record for each of these hashed files, that is what is missing when you don't create them in an 'account'. Plenty of discussion here on the subject, but here's some quick syntax: SETFILE <full hashed path> <name> OVERWRITTING The <name> would be what you would referenc...
- Tue Nov 20, 2007 3:30 pm
- Forum: DSXchange Testimonials
- Topic: Some things are just "what the doctor ordered"
- Replies: 8
- Views: 19714
- Tue Nov 20, 2007 11:24 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Date Format
- Replies: 2
- Views: 966
You need a combination of IConv and OConv for the date portion, no clue how you are going to handle the time:
Off the cuff.
Code: Select all
OConv(IConv(YourField[1,10],"D/"),"D-YMD[4,2,2]")Off the cuff.
- Tue Nov 20, 2007 8:43 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Slow performance.
- Replies: 10
- Views: 3163
The table is indexed for the some of the columns and not to all the columns. 'Some' of the columns can be ok as long as the columns you are using in your update statement are on the leading edge of the index - i.e. are the first columns in a compound index. Otherwise, it cannot be used and we're ba...
- Mon Nov 19, 2007 11:31 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Problem returning @TRUE, @FALSE from Routine to Transformer
- Replies: 9
- Views: 6491
There are better ways to... well, never mind. Actually, on the issue of comparing dates, that is a fundamental technique - convert to internal format and then directly compare the internal values. So that part is fine. And you don't have an issue 'returning @TRUE/FALSE' you just have an issue with y...
- Mon Nov 19, 2007 10:36 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Problem returning @TRUE, @FALSE from Routine to Transformer
- Replies: 9
- Views: 6491