DSXchange

This is a topic for an orphaned message.

Sharon, Weve seen way too many problems with the link variables to rely on them in our jobs. At best it is inconsistent, at worst case it just plain ol doesnt work. [Tru64 5.1, DS 4.2.1r8, OCI 3.0, Oracle 8.1.7] Hopefully, it will be corrected in 5.1, but in the meantime weve fallen back on the olde...

Theresa: We are using DS 4.1 and we have "Output Link Execution Order" feature in the transform ... so this allows us to order the links explicitly ... is this feature absent in 3.6.1 ? I couldnt order the execution of different path (say more than one Transform involved) in one job, so I split them...

Provided that you have no constraints in the Transform (I havent tested this - constraints may not affect the timing of the initial truncate), the order of the links IS predictable. It is an undocumented feature in your version but can be explicitly defined in later versions. Whenever you change the...

Craig_Hulett@rsausa.com wrote: > If you are on some flavor of Unix, weve used "sort -u" in a before > job script to build a version of a file without duplicates before > loading it. If the sequential files are large enough and either sorting or loading are bottlenecks, you may want to consider the n...

Hi All! I have a lot of Excel files that I need to load to UDB 7.2. Some information from this files is loaded to relational tables through saving them as text files and parsing. Some information in this Excel files can not be normalized and I want to load them as BLOB to UDB. How to do this with mi...

Scenerio: Datastage v4.2 Oracle v2.7 I am writing a large number of records from a sequential stage to a OCI stage with no transform. I have 7 keyed fields in the Oracle table and there are a number of duplicate records present in the input sequential file based on those keyed fields. What would the...

What datamodel are you referring to? MetaStage datamodel or datamodel for a particular metabroker? They are published in Acrobat file format on you MetaStage CD. Look under "C:Program FilesArdent(or Ascential)MetaStage". For Every Metabroker, there a *.pdf file with its model. Hope this helps, Pavan...

Technically, your only issues should be with anything you do that is system specific - Unix scripts, usage of O/S utilities, that sort of thing. From a pure Job, OCI and Hash standpoint, Datastage is highly portable. Ive moved a ton of jobs between HP-UX and Compaq Tru64 without changing a thing. Yo...

Hi Theresa There is no absolutly right way to solve your problem. My favorit solution is a dummy job which does nothing but truncate the target database table. This job of course must run before you start updating the database with your existing job. I prefere this solution because most of my jobs a...

Hi, Im joining data in a sequential file to an Oracle table of vehicles accessed with the above plug-in. Using the |Output|Selection| tab of the plug-in, I have tried to create a subset of the Vehicle table that contains only the vehicle models I need. After the join, I only wish to keep records con...

This is a topic for an orphaned message.

You are using the correct method for starting/stopping the server engine, but it sounds as if the ds.rc script has an error in it. As this script file differs by platform I dont know the exact nature of the problem. If you wish, email it to me and I will take a look at it to determine the problem so...

Hi. What is the right way to set the Update Action in DataStage in an OCI in the following case? We have 2 links going from a transform to an OCI that writes to the same Oracle table from both links. Because there are 2 links going into the same OCI, we werent sure about doing "Clear table then inse...

Luiz This routine has 3 arguments and came from DS3.6. I will send the others tonight. Here is the ODBC version: *--------------------------------------------------------------------------- ---------------------------------------------------------------------------- ---------------------------------...