DSXchange

Welcome! I don't recall having to work with "epoch" dates in the past and found this site which has a ton of information on the subject including how to do it in Oracle, among other things. So that may be an option for you. Or perhaps custom C++, something UCDI would probably glad to help ...

Because then all of their secrets would be safe. :wink: It's a legitimate option and some people choose to do so for their production (or production-like) environments. Hopefully they recognize the support fun they are creating, like not being able to debug a failing job and probably a bunch of othe...

Did you ever get this figured out?

Hey Ernie, was IGC available back in the 8.x release? That's what the OP is running, unless the post is not marked correctly... if not do you recall when it was introduced?

Have you tried an exact search for "data lineage" yet? You'll find quite a number of posts in the Metadata Workbench forum, including some I saw about Best Practices, see if anything there helps.

Okay... is there something "different" about your PC than the others, as in it only has a minimal amount of memory and others have more? Have you installed more software lately so the amount of available memory for DataStage has gone down? Does your login work on someone else's client inst...

As a guess, I'd wager you are out of memory. :wink: In all seriousness, define the scope - is this something that used to work and now doesn't or you've never been able to do it? Does it affect everyone or just you? Does it matter what project you connect to? Interesting, was going to suggest you se...

That sounds like a permissions issue. Have you looked at the permissions of the project's job related tables in the repository, comparing the ones that work to the ones that don't?

Based on your information I updated the original post. Hopefully someone will have some actual helpful information for you shortly. Sadly, for this, that's not me.

Is that means in 8.7 we can do the range selection ? You'd have to answer that... seems to me the answer is "yes" only if that functionality is provided by the ODBC drivers. Failing that you stage the whole file and then from the staging area pull just the data elements / ranges / rows yo...

So... you are running a 64bit version of DataStage?

Let me get you into your own post (so you have control over its fate) and linked back to the other one... there you go. Are you still running an 8.x version and have DataStage on a Windows server? And just to confirm, you are getting the exact same error using the same import command / syntax? If it...

Ah... I always assume that people are here posting problems with parallel jobs when it is in this forum. Sorry about that. I'll push this back to the General forum as it is about DataStage itself and is probably something that will require a patch, at a guess.

Perhaps a description of your job design is in order...

Oh, they are all possible but you'll have all of the "normal" PITA problems we all have with using Excel as a source... as noted, one awesome issue is how it loves to turn things into numbers. And the people building the spreadsheets need to be very disciplined and consistent, something I ...