DSXchange

Ray and JRodriguez - Thank you both for your suggestions. From my testing, it appears that the OCONV functions will be the way to go for now. Ray - I have to admit I wasn't even aware of the MatchField function, but I am intrigued by it, and anxious to see how I might use it in future applications. ...

I've searched a lot for this, and haven't found anything, though I would imagine it's been a common question so here goes - I have some trimmed address fields containing city, state , zip info (exp: MilwaukeeWI54621), where I need to parse the values out into separate fields. After working various f...

Craig -

Thanks for that suggestion. I don't see any project-level variables that appear to address that issue, but I'll check with IBM to see if there might be one that can be set in the User Defined section that would take care of it. I'll post any results that I find here.

Tom

Ahh - excellent idea. I didn't think of that. Thanks for the suggestion!

Mike - It picks up one file per day. I'm using file pattern because it will have a different day in the file name each time.

I'm wondering if anyone has run into this before, or has a suggestion for a solution. I have a simple sequential file to read, and to output to another sequential target file. The file name will always contain a date, so I am reading it using the file pattern option (with a wild card for the date). ...

ArndW - In your reply above, is the 'extra software' you're referring to the Excel ODBC driver from Microsoft? The reason I'm asking is that I'm needing to do the exact thing the OP refers to, which is adding data to an existing Xcel template. I know this topic gets brought up from time to time, but...

Sorry Craig - I meant go include that - unix flavor is Solaris. At any rate, I've confirmed that DataStage v. 8 is compatible with Oracle 11g. I believe it was actually a "user error" on the part of our developer here who initially encountered the Bus Error. I'm marking this thread as Reso...

Craig - Thanks for your reply. We're on Unix, and using the 10g client.

Hello - Searching didn't produce any references to anyone asking this question previously, so I'll ask - does anyone know if DataStage 8.0.1 is compatible with Oracle 11g? The reason I'm asking is that we're getting a "Bus Error" when trying to connect to an 11g database, and never have pr...

The workaround we decided to use was to alter our job run scripts to allow for return codes of both 1 and 134.

Another odd thing is that we don't always even get the dump I posted previously, and there's no mention of anything related to java. On these occasions, (as in a failure we just had), the only indication of a problem that we see are these entries in the history and error log (both of which are from ...

Ernie - I'm not dealing directly with java at all. The only Java that's going in is that which is running behind the scenes in v.8. The problem jobs are simple - they are, for the most part, simple multi-instance jobs (server). (Though we do have this same error with regular server jobs occasionally...

Craig - I saw your post yesterday but didn't know what you meant. I did some searching and I think I see now what you were asking. We are on a Sun Solaris system (vers 9 i believe), so I think that would rule out any use of HP-UX.

Thanks for the reply so far. Istaur - According to the following information below provided by my unix admin, I believe I am using the correct version of Java: /app/IBM/InformationServer/ASBNode/apps/jre/bin/java -version shows: java version "1.4.2_11" Java(TM) 2 Runtime Environment, Stand...