DSXchange

After it aborts, have you tried Resetting the job? If you do, is there anything in the log labelled 'From previous run'? This can give more clues as to the cause of the abort. I just reset it, but not getting any more helpful information. I basically have 2 million records i'm trying to sum down. I...

Could you have mistyped the name of a function in a derivation or routine, or have an incorrect argument list in a call? It's possible; i'll double-check that. I wouldn't think so in this case, though. I had the entire routine working fine in DB2. All i did was switch the input to a SQL Server tabl...

I am pulling data off of a SQL Server database, writing it to a temporary file, then trying to summarize that file. I am getting an error when trying to summarize: DataStage Job 200 Phantom 2456 Program "DSP.ActiveRun": Line 51, Exception raised in GCI subroutine: Access violation. Attempt...

We are pulling a comma-delimited file off of the mainframe, onto a server. The file has character fields with numbers like "06". These are in quotations, as they are character fields, not numeric. When DataStage pulls them in, though, it is treating them as numbers, and dropping the leadin...

Got some info that may come in handy for some of you....... i can't take credit for it, though. One of my co-workers came up with this...... He had the file go to a DB2 Stage, and then set it to "Generate DDL". That gave him pretty much what he needed....... all column names, with the appr...

This may be a simple question for the right person, but we have no experience or training doing this, so not sure where to begin. We pull a lot of our data off of the mainframe and work with it and keep it on servers. We now have a case where we have server data though, that we need to convert and s...

kduke wrote:If all you need is the column names then write to a sequential file in a job and quit after 1 row. Check make the first row the column names.

Hey, GREAT idea! Thanks! :> We actually need it all, but heck, that's a start. :>

Is there a quick and easy way to export my list of Column Definitions (from a Sequential File stage) to a text file?

P.S. UDB is also the same as DB2 under Windows (in DataStage anyway) Thanks for all the responses, everyone! I've never used UDB, but i was under the impression UDB was basically DB2 on a server, and DB2 was on the mainframe. We use Server DataStage, but we load all of our tables on mainframe DB2. ...

:D UDB is the same as DB2... go figure. But I wouldn't use the UDB bulk loader. Ascential kind of screwed this stage up which makes it sometimes even slower than the actual DB2 plugin. For all of our big loads we created db2load scripts (we are on UNIX) that are each about 10 times faster than the c...

Is there a Bulk Load Stage for DB2 in any of the newer versions of DataStage (we're using version 6)? I see a bulk load for UDB, but nothing for DB2. We're currently loading DB2 tables on the mainframe from our DataStage server jobs, and it becomes quite a headache!

Thanks for all the info so far! To answer some of your questions and provide a little more info..... We actually have both Oracle ad SQL Server both in house already. And both databases reside on their own servers, separate from DataStage. We don't have our "Data Warehouse" / "Star Sc...

Some background info: We are currently using DataStage version 6 on a Windows Server with 8 processors. We are hoping to switch to version 7 soon, and hopefully Unix by the end of the year. Currently we are using DB2 for all of our tables. We'd like to get completely off the mainframe, and do as muc...