DSXchange

I have an interesting question. We have a newer project coming on-line here, and are wondering if DataStage is the right tool to use, if it would even work at all. Basically, we would have one large mainframe file coming it. The file would contain several records with index information, as well as h...

I have just a general question about Parallel Extender. I have never used it myself. We have Windows Servers here. I have heard it is available for Windows DataStage, but that pretty much everyone that uses Parallel Extender uses it on Unix Servers. I am wondering (from a useage point, not a saleper...

ArndW wrote:Eric, declare that column as VARCHAR in the source and hashed file and it won't strip out the leading zeroes. ...

Thanks! I will give that a shot!

I am loading data from a comma-delimited file to a hash file, so I can do quick look-ups on it. The problem I'm having is that some of the data gets reformated when I move it over, for no apparent reason. Example: I have account numbers that need to be 4 digits. Some of them have leading zeroes, tho...

Well, how do you know what constitutes a "row" of data, when it begins and ends, what attributes make up a column and meaning, etc? Sounds like you need to crack a few heads. :x You could invent a Karnac (sp?) stage that figures out the answer without knowing the question. Sounds like a D...

What's the structure of the binary file, did they tell you how to read it? ... Nope. That's normal with a lot of the files I get. I just have to start taking a look at them and kind of figure it out.... basically, I'm "winging" it. :) And this one is no different, except that I can't tell...

Define "binary". Are you talking about an EBCDIC file? See the CFF stage. Remember, a Server Sequential stage expects to either read a delimited row ending with a line terminator (CR/LF, LF, user-defined) or a fixed width row with optional line terminator (read to line terminator or via s...

For my first time ever using DataStage, I am trying to read in a binary file. Is there an easy way to do that? I'm guessing (hoping) there is, but still looking for the way. So thought I'd throw this question out there while I continue my search.

Thanks for any info!

Nothing else it could be, Eric. And Mr Box-o-Doughnuts has nailed it, I would think. :wink: Sounds good. I will definitely give that a shot, then. :) Any ideas why it only is a problem occasionally, and not all the time, if I'm running the exact same job every time? Or why it might "wait"...

If the job itself didn't actual start in 60/90 seconds, it would throw a timeout error of -14. It *is* actually starting and the 12 minute "delay" you are seeing before the monitor kicks in is the amount of time it is taking your before job routine to run. Simple and small as it may be, i...

How do you determine if the job is "running"? What is the status of the job in Director? Are there stages that say "Starting" in the Monitor that contain SQL? Are there before-job routines that are executing? What's in the logs of the jobs? Have you check the DS server to see wh...

We have a problem with our jobs just sitting there and waiting often, and I am wondering what the problem is. Sometimes, we spend more time waiting for the jobs to "kick off" then we do for them to run.... rather ridiculous when we're running jobs where time is critical. Here is an example...

Surely what you're already doing ("every 1st") covers what you've asked? For the jobs that we run on every "1st", yes. We have jobs that run on a "set schedule", but not one that we can schedule using "every 1st" though. For example, we might have a job that ...

Windows Server, version 7.1. We use the DataStage Scheduler regularly, but we usually schedule jobs to run every Saturday, every 1st of the month, stuff like that. It works great for that. However, we have some jobs that we need to schedule once a month, but not always on the same day. Is there a wa...

ray.wurlod wrote:It's better in version 7.5.

So when we upgrade to 7.5 in a few months here, I can use the parameters within then?