DSXchange

if you are on unix you could execute a simple (and faster than processing each row in datastage) pre-job routine to strip out first and last rows: #!/bin/ksh echo "stripping out head and trailer" echo "" tempfile1="tempfile1" tempfile2="tempfile2" OUTPUTFILE="OUT.FILE" #remove files if extent from p...

Hi, I am trying to replicate the functionality of a Sybase stored procedure function call using a DataStage routine. As with stored procedure functions, you pass arguments to the stored procedure -- which process numerous SQL statements and ultimately return a result. (Refer to the example below) Wh...

Hi I need to execute a large number of updates on a single table. Because the number of updates are increasing on a week to week basis I would like to create a table with the update statements e.g. definitions, which DataStage kan read from. For example: I have 3 updates wich in sql would be like th...

Curiously, mine is a similar story. Scrolled right one day in the Columns grid, thinking to add some documentation, and found em. Shouldve read the manual of course, but whos got time for that these days? Hard copy manuals are good for commuters - its so hard to read CDs on the train! -----Original ...

Id recommend Rays 3rd option. Now you tell us Ray??? Do you know how long I played around and rummaged through the documentation before I figured this out?? Works like a charm now though. -----Original Message----- From: Ray Wurlod [mailto:ray.wurlod@informix.com] Sent: Thursday, 7 February 2002 3:2...

Hi Kittisak, The error is being generated by the sequential file stage, on which your format describes each row as having a number of columns delimited by the "|" character. The first and last lines in the file do not have this structure. You have a number of choices (depending to some extent on wha...

Hi, One way to handle this is : In the first sequential stage, read the entire file as one column. In the transformer, split it into the constituent fields using field command, and in the constraint, eliminate rows which do not have all constituent columns. Another way is: In the sequential file: th...

Hi all, I have multi-format text file look like this... File name: xxx.dat Date: dd/mm/yyyy 001|col1|col2|col3| 002|col1|col2|col3| ... Total 595 In other words, the first and the last line are information of text file. How can I ignore those two lines while transfrom? I tried to use @INROWNUM in co...

Hi

Any ideas on how to do this in 3.6

Thanks

Adam




"Giovanni Boccia" on 06/02/2002 08:35:13 PM

Please respond to datastage-users@oliver.com

To: datastage-users@oliver.com
cc: (bcc: Adam McGuinness/NSW/QBE/AU)
Subject: Re: R

Set up an additional output link from a Transformer stage, and set this link to handle rejected rows. Link variables on the other output link(s), stage variables, DataStage functions and system variables can all be used to generate the diagnostic columns on the rejected rows link. -----Original Mess...

Dear all We are loading data from a *.csv file to an Oracle 8i table using DataStage 4.2. Records can be rejected for any reasons like " too many number of columns" "value inserted too large for column" etc. In all such cases DataStage throws a warning. There can be n number of reasons for which a r...

Data type mismatch is a warning rather than an error. It signals the fact that the metadata in your stage type does not exactly correspond with whats in the database. For example, you may have DECIMAL(10,2) in your DataStage design, but the database may use DECIMAL(19,4) for currency. This would sti...

This is a topic for an orphaned message.

we are migrating jobs fro 3.6.3. to 5.1, doijng export/import. For some of the jobs on ORA OCI stage, when we click on the stage to open/properties, it pops up a "TYPE MISMATCH" error. The compilation of the jobs is uccessful and the jobs seems to run fine. anyone had similar problems during migrati...

The current jobs job handle is DSJ.ME -----Original Message----- From: Salstrom, Kenneth [mailto:Kenneth.Salstrom@msnyuhealth.org] Sent: Wednesday, 06 February 2002 05:11 To: DataStage List (E-mail) Subject: Parameters in Job Control I want to access parameters passed to the Datastage job (Edit/Job ...