Search found 42189 matches

by chulett
Wed Nov 21, 2007 7:42 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: NLS SETTINGS?
Replies: 5
Views: 1871

What 'above thing' are you actually asking about? I don't see anything like a question or specific issue that you are having. :?
by chulett
Wed Nov 21, 2007 6:47 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: XML Input
Replies: 5
Views: 2278

1. Can you be more specific about the 'reordering' needed? What did the posts say need to come first/last? I suspect you may need a 'lib32' in there somewhere. :?

2. Just like in Server, except you have no Folder stage. Feed from the Sequential File stage instead.
by chulett
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

Or have a chat with your DBA.
by chulett
Wed Nov 21, 2007 6:40 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DATA TYPE COMPATABILITY
Replies: 3
Views: 1448

I don't see any 'issue' yet... have you tried it?
by chulett
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

Ugh... LONGs. :P
by chulett
Wed Nov 21, 2007 6:36 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Error While Creating Sequencer
Replies: 4
Views: 1513

If this error is specific to you, and the patch doesn't help, try a complete reinstall of the client software.
by chulett
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

Never mind the fact that processes can be handed around from CPU to CPU like hot potatoes. :D Have a chat with your Sys Admin types, they should be able to explain what information you can or can't get from your system.
by chulett
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

Search the forums for the error, this has been solved before. Permissions problem, from what I recall.
by chulett
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...
by chulett
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...
by chulett
Tue Nov 20, 2007 3:30 pm
Forum: DSXchange Testimonials
Topic: Some things are just "what the doctor ordered"
Replies: 8
Views: 19714

And here I thought parsimonious meant something that smelled like parsimmons. :wink:
by chulett
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:

Code: Select all

OConv(IConv(YourField[1,10],"D/"),"D-YMD[4,2,2]")

Off the cuff.
by chulett
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...
by chulett
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...
by chulett
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

Willing to post your routine code?