DSXchange

I would like to run DataStage 7.1 and DataStage 6.0 on the same server at the same time. Can this be done? Why? I would like to upgrade my system test environment to DataStage 7.1 and verify that everything works okay in my system test environment before touching my user test environment. Details. I...

Yes, that is true. Hash file writes are "destructive overwrites", meaning the last one in wins. Sometimes this can be leveraged to remove duplicates from data, or to end up with the "most recent" record by properly sorting the source data. That's why it is very important to defin...

Craig. If two records come with the same key values, isn't it true that only the latest record will be retained in the hash file ? Thanks, Bibhu DW Engg, Rewards 503 220 3891 (PDX) "Craig Hulett" et> cc: Sent by: Subject: RE: Execution order in a server job datastage-users-bounces @oliver....

Sequential files are not databases. There is no concept of a "row" of data, it is just bytes of data. A or is just data. If you have two processes spooling data into the same file, the operating system (if it lets you) will merge on a block of bytes basis, not rows. This is readily verifia...

Craig: Thank you. I followed your instructions and replacing the seq file with a hash table, it worked fine. But I stil do not understand what does "... write three output streams to the *same* sequential file simultaneously ..." mean. Are they really simultaneously, or perhaps they are so...

I know it works on as400. It can append or overwrite. -----Mensagem original----- De: Mike [mailto:dwarchitect@comcast.net] Enviada em: Friday, February 27, 2004 2:46 PM Para: DataStage Users Discussion List Assunto: RE: RES: DB2 bulk loads I haven't tried it or checked into, but I would really be s...

I haven't tried it or checked into, but I would really be surprised if the UDBLoad stage supports mainframe DB2. Here's what I would do: Have your mainframe DB2 DBA write a JCL job to load the DB2 table (you can replace the current contents or append rows to it). Have him/her schedule the load job i...

I was thinking we had tried that stage about 6 months ago, and had some problems with it. I'll give it a shot again, though. Thanks! :> Can that stage add to the table as well, or simply overwrite what's out there? Eric ---------- 99% of lawyers give the rest a bad name. "Alex Martins" To:...

Eric, there is a stage named UDBLoad, which uses a DB2 utilitary to do this. All yu have to do is to fill the properties tab. Good luck, Alex -----Mensagem original----- De: Eric.Roufs@stpaul.com [mailto:Eric.Roufs@stpaul.com] Enviada em: Thursday, February 26, 2004 5:11 PM Para: DataStage Users Dis...

For to define tables in Universe you have three fields to fill, length, scale and display. display=length+2 (decimal seperator and +/- Prefix) and metasata in datastage have to be the same as metadata of Universetable. with LIST DICT you can check the metadata in a telnet-session of the project. Wol...

Guillermo, This isn't an 'execution order' problem. The error is caused by trying to write three output streams to the *same* sequential file simultaneously. This cannot be done, period. And before you ask, this has nothing to do with DataStage but is due to the fundamental nature of a 'sequential' ...

Ray: Thank you for your answer. The problem I'm having, is that a sequential file is fed from and aggregator, and from other two transformers at the same time. All records are "appended" to the file. For the run (and for the test data), there are no records, so it seems that three links ar...

Execution order is as specified in your design. Look in the log for "active stage starting" events. (Note that active stages are closed in the reverse order.) _______________________________________________ datastage-users mailing list datastage-users@oliver.com http://www.oliver.com/mailm...

I'm using DataStage version 6.0, on a windows server. We are doing loads to DB2 on a mainframe. Is there a good way to do bulk loads, replacing the entire table, other than using the DB2 Stage to do 1 insert at a time? Eric ---------- 99% of lawyers give the rest a bad name. ________________________...

I'ts straightforward to do in DataStage BASIC or in a UNIX shell script. Example in DataStage BASIC: TheDate = Oconv(@DATE, "DYMD" : @VM : "MCN") TheTime = Oconv(@TIME, "MTS:" : @VM : "MCN") NewDir = OldFileName : "_" : TheDate : "_" : TheT...