DSXchange

I have a string of 255 bytes that we want to split into 2 separate strings. The place we want to split them within is before and after a "v.". I am using the "Field" function to try to do this. The problem is this. My delimiter is 2 characters long instead of 1. It doesn't seem t...

Here's the Routine. I'm sure it could be optimized some, but I haven't had the need or time todate. If you do optimize it, I would apprecite it if you would post the changes back, so that I can improve my code as well............. . . . Good Luck, Tony Thanks, Tony! I'll give it a shot. I'm definit...

Ravi, It is relatively easy to read job parameters from a file and run a job, setting the appropriate job parameters with values from a file. This can be accomplished with a Job Sequence job or Batch Job (I can't remember if v5.2 has job sequence jobs or not). For Job Sequence jobs, I wrote a small...

Several different ways of doing that have been posted. Do a search on this forum and look e.g. at http://www.dsxchange.com/viewtopic.php?t=84590 . Ogmios I checked out the topic you pointed me too. Thanks! I have to laugh. :> When we were first given this DataStage tool, we were told it was so simp...

I use DB2 and ODBC stages all over the place. We usually have the exact same tables set up in both a "Test" area and a "Production" area. Right now, to switch between the 2, we have to go into each job, switch the "Server Name" and recompile. Is there a way to have that...

Just to set the record straight, I am not, and never have been, an employee of Ascential. While I continue to include many Ascential employees in my group of personal friends, I do not abuse that friendship by taking "back door" approaches. Well, not often, anyway, and then mainly for Uni...

Is it possible if you can provide me a more detailed steps to achieve this? I haven't tried something like this before. I have been using db2 plugin to insert data into the database. However, i keep getting a table lock. Sumtimes, it is due to stop action to the jobs that access the table, and subs...

Well Ray must be knowing this. But my answers is not in immediate new version of datastage. Doing Aggregation in datastage Server depends on the volume of records you have as well if sorted you get the max performance. For smaller number of records you can use this stage and I normally use a stagin...

From what i remember of using a similar summarization stage on the Mainframe version of DataStage, it was much quicker, easier, and intuitive then the Server version Aggregator Stage. Does anyone know if there are any plans on incorporating some of that into the Server version at some point?

Hi, since you left out the DB you are using I'll assume ORACEL, but I may be mistaken! when you have a <name>.<table name> it usually mean that the <name> is a scheme or owner and is only part of a fully qualified table name. so if you didn't check the use fully qualified names or filtered for only...

Are there any plugins or add-ons that allow DataStage to work directly with an old Focus database format? Our company just merged with another company, and they have a lot of their data on the mainframe in Focus tables.

When importing new tables into DataStage, we used to be able to provide a partial table name, and it would bring back any tables that had a portion of that string in the name. Now, it seems to not work. If we have a table called VJ.TEST_TABLE, we could just pull back everything with VJ. Now if we do...

On the issue of "Display Size", I think you'll find this has always been the case - it's just that it is being more tightly enforced. There was something in the readme about this, I believe. :? . So, basically, the "Display Size" always needs to match the "Length"? If ...

We just very recently upgraded from version 6 to version 7.1. In version 6, we always had a problem with the Display column. For example. We're reading in character fields that are all size 5, let's say. We put our Displays at size 7 (usually a mistake, but anyways.....). Suddenly, none of our field...

Probably memory / resource related. There are definitely limits to the amount of un-ordered data the Aggregator can handle on any given system, but I don't know of any hard-and-fast rules on how to determine what that limit might be. Si. I believe you are correct. Before i was pulling in a month at...