DSXchange

We are using DataStage v 7.1 on 2 Windows servers. We don't use the DataStage Job Scheduler a real lot here, but let me give you some background first. Apparently, you have to have Admin rights to the server to use the Scheduler. Only a few of us have that. I am one of those. Unfortunately, most peo...

ray.wurlod wrote:7.5 was the next release after 7.1. There was no version 7.2, 7.3 or 7.4.

Ahhh.... that is good to know, as well. Thanks, Ray. I guess I made a bad assumption there. :>

Thanks, Arnd. That's quite a list! :> So, is this list just what was fixed between version 7.4 and 7.5? If so, that's quite a list! I can only imagine that the bugs fixed and enhancements added between 7.1 and 7.5 would be quite significant!

I am wondering if anybody has a good list of what the differences (or bug fixes) are between DataStage Server version 7.1 and 7.5. We are currently using 7.1, and am wondering if there are any valid reasons we would want to upgrade to the most current version out there.

Thanks!

I am posting this message out here for a fellow DataStage Developer here, so hopefully i can get all of the facts straight on this. :> They have their original source data coming in from SQL Server, going into a Transform Stage, and then back out to another SQL Server table. Nothing complicated. How...

Hi, Use Oconv function as Oconv(Arg1-24835, "D") Where Arg1 is your 5 digit date format e.g 000000 ketfos Thanks! I actually just found the solution, though. DataStage has a built in function, DateDaysSince1900ToTimestamp, that does exactly what i'm looking for. Very neat, and simple! Who...

We have a date coming in in the form of a 5 digit number. It's the number of days since 1900 (January 1, 1900 being 00001). Is there anything built into DataStage that would help with converting this to a more "standard" date that we can use? Or does anybody have something already written ...

If they're all in the same database, join them with SQL; you may require outer joins depending on the exact relationships. If they're from disjoint databases, you can use the ODBC stage's multi-row return from lookup capability. Join them with SQL.... using the "Join" stage in DataStage?

I have 5 tables that are joined on a common key. On some of the tables, there is a one-to-many relationship. What is the best way to do this in DataStage? In our last version, i believe we had a "Join" stage we could use, although i never used it. We don't have it installed yet for version...

The easiest way is to create stage variables in your transform stage . Name them ptr, SubString1, and SubString2. The code to the right of the "=" is your derivation for each stage variable. I ended up going this route..... creating a Stage Variable and using the Index command. It works w...

Much of such a book has been written. Ascential placed too many legal obstacles in the path of its publication. :cry: Ascential is against having a book like this out there? Or just your standard "bureaucracy" getting in the way? Maybe if it was released "anonymously", no one co...

Try to stay away from the "advanced stuff". In the GUI jobs I most of the times only use seqential file stages, OCI, ODBC, DB2 stage, a tranformer and that's it. For the scheduling josb and the more difficult things I use BASIC jobs. The less "moving parts", the less can break. ...

Use the index function to find the "v.", then use [] to retrieve each substring. ptr = Index(YourString,"v.",1) SubString1 = YourString[1,(ptr - 1)] SubString2 = YourString[Len(YourString) - ptr - 1] It looks like you're assigning a variable (PTR) that i can use in my Transforme...

You could always try new things in DS and when you come up against a wall you could always come here and ask questions. Yep, that is EXACTLY what i am currently doing. It seems to work just fine, as long as i don't annoy too many people with too many "simple" questions, or my lack of unde...

I have been using DataStage for a while now, but our usage is not super "advanced". I'd love to take the advanced DataStage course, but who knows when (or even if) that will ever happen. In the meantime, is there a good book that i could use for some self-training? Something like "Dat...