DSXchange

Hi, i want to copy a dataset from my development server to system test server. Can anyone tell me what command to use. Thanks. first you need to have a NFS mount on your development server that is pointing to your test server. write a generic job with RCP turned on that has an input dataset and an ...

Hi All I use simple job: db2_UDB_API--Transformer--sequence file. I have very strange compilation error :( Output from transformer compilation follows: ##I TFCN 000001 10:44:42(000) <main_program> Ascential DataStage(tm) Enterprise Edition 7.5.1A Copyright (c) 2004, 1997-2004 Ascential Software Cor...

Yes I agree with you, but I am facing a weird condition..when try to compile a job using a transformer then it is tgrowing error but removing the transfor fer,I can perform the compilation...why it is happening? Parallel jobs can not be compiled on Windows.I can be compiled and run only on Unix ser...

Hi , We have a Sparse DB lookup in our PX job but the table will potentially grow to 30 billion records. Currently we are in development mode. This table is being looked up in all our jobs. In dev, the db2 instance does not have DPF installed. Question is will the performance of the lookup actually ...

Today, a parallel job can take 6 hours to load tables from oracle to oracle. We want to drop the px jobs by the ds jobs. In fact there is no transformation between the source and the target. The table are very big and contains lot of fields... Hi, If you can drop and create the target tables, then ...

Currently I use an ORAOCI9 Stage to Update existing records and Insert new ones. I'd like to use a bulk loader to carry out this process as it currently takes a long time to load records. Is this possible? Can anyone give me some suggestions? Hi, Don't think sqlloader lets your perform UPDATES but ...

DS can write to a csv file.You can link your Excel spreadsheet to the csv file for the values,I think.

Hi all, I am trying to read in a Variable Block / EBCDIC mainframe file.. I was able to import and stick in the meta- data. Made sure that the Occurs clause is taken care of, by modifying the cobol copybook. When i try to read the data i get the following error.. "Error reading on import. Encu...

Hi all, We are using a column as varchar without specifying any length. But while loading in the oracle table we specify as 4000 length in oci stage. Records with length more than 110 are going to reject link with a warning in log which specify a future chance of truncation. I tried using modify st...

IF you can get them to a file, I don't see why you can't write them to a table, what you need is to write a simple Unix script... Or... yet another DataStage job! :shock: :wink: of course but a lot depends on the format of the output file; point is the file needs to be formatted into tabular form a...

Hi... I observed this peculiar behaviour in one of my jobs... I have a DB2 stage in which row leakage is happening. To capture this, I have used a COPY stage and enabled RCP so as to catch the sqlcode and sqlstate of the rows being rejected. The o/p of copy stage is a sequential file. Everything wo...

Hi all, I want to write the statistics namely when the job started and the End time and the records that has processed at each link and as well as i have to capture the count at each link.I have tried with the Built-in Routine/Before/after/DsJobReport but i am able to write them only into a file an...

Hi, I have COBOL FD table definitions and LOAD in each of the STAGES. If I need to add another field to these table definitions, how would I go about reflecting the latest change to all STAGES that refer it? Is the only option, going to all Stages that use these definitions, and manually do the upd...

ray.wurlod wrote:Yes, the orchadmin utility has a subcommand for this task. ...

Hi Ray,
Where can I get a copy of the orchadmin Guide assuming there is one ?

Chin

Hi, I am using sort stage in my job with transformers, So ia m getting one warning for all seq.files in jobs, totally i am using 3 seq files as target i am getting warning like "Dup_Error_File_FF: When checking operator: A sequential operator cannot preserve the partitioning of the parallel da...