DSXchange

This has been covered in depth a number of times on this list, with examples of DataStage BASIC code for doing it. Rather than reinvent the wheel, why not check out the archives, at www.tools4datastage.com/forum ? Theres a pretty good search capability. -----Original Message----- From: Fan, Yuzhou [...

I am interested in this subject. Are we talking about outputting log files to sequential files? I am always trying to think about a way to save the whole log files for each run to a sequential file, the default setting for my project is to purge the log after certain time which make sense, because i...

Hi all I have a job that extracts from a table and writes to a hash file. Nothing fancy. Ive checked that the folders exist where the hash file writes to and Ive checked the connections to the database table. When I run the job, this error comes up: ODSClaimDiag1..JobControl (fatal error from DSRunJ...

Interesting idea. Its dsjob (the command line interface) we want to use, rather than DSRunJob (from BASIC), but Ill give it a go. >From: "David Barham" >Reply-To: >To: >Subject: RE: Multiple Invocation from dsjob >Date: Sun, 22 Sep 2002 19:37:25 +1000 > >Based on how you use DSRunJob, Id try includi...

Based on how you use DSRunJob, Id try including the invocation id in the job name, separated by a "." For example: MyJob.InvocId -----Original Message----- From: Greg Smallhorn [mailto:greg_smallhorn@hotmail.com] Sent: Sunday, 22 September 2002 6:53 PM To: datastage-users@oliver.com Subject: Multipl...

well, that works OK, but it gets cumbersome, especially if you want to paramerterize it. Youre likely to need many variables to identify the condition, or a long one that IS the where clause (pretty ugly) Also, in this case its datastage 4.0 (not even 4.2) seems DB2 doesnt have a rownum thats access...

Does anyone know if one is planned as part of the next big (Version 6)
release? Or ever? Id *really* like to see some way to step through a
batch job or even code in a transform, with functionality similar to what
is available in the Designer.

Any chance of that?

-craig

I would create three links to feed the table; one that updates column 3 only, one that updates column 4 only, and one that updates column 5 only. Constraint expressions on these links would determine whether to send a row along that link. This approach also allows you to handle the situation that yo...

If you can identify the specific set of initial values you can use like 0& like 1& not like 0& and ..... to pare down the number of records into separate jobs. Different instances can be used in DS 5 to run each version of the job via Job Control or Job Sequencing running all jobs in parallel. I bel...

Christian Do it with a constraint. Output all the combinations. The constraint would be when the column is or is not null. Thanks Kim. --- "Pelletier, Christian" wrote: > Hi all! > > Long time no post... > > I have a situation here that needs some experts > help... > > Lets say I am doing an update ...

No, you cannot rewrite the SQL. DataStage will pass all columns you send to it. You have two options to handle this. 1. In DataStage, do a lookup on the row you wish to update and combine the data before sending it back to the database. or 2. Write an update trigger for the table to evaluate the col...

Hi all! Long time no post... I have a situation here that needs some experts help... Lets say I am doing an update on a table using an ODBC stage. I have 5 columns in my table definition, from which 2 are the keys. On the three remaining columns, I am doing an update only if there is a value in the ...

Mark, You can try having multiple delete statements with a commit statement in between them in the "Before" routine of DB2 stage, with each statements "where" clause having "like 0%, like 1% and so on provided they always start with a numeric. You can identify the volume of data available for each w...

Mark, If possible with your data, try using rownum < 5000 and rownum > 5000 like that ( this is what Oracle uses, check the similar function in DB2). That should limit your query. Mohan -----Original Message----- From: Mark Steen [mailto:mark.steen@damanconsulting.com] Sent: Wednesday, September 18,...

Hi all,
I am getting this error while trying to insert into
a dimension table. The error is
Oracle Error - OCI_NO_DATA

thanks in advance,
Binu


__________________________________________________
Do you Yahoo!?
Yahoo! News - Todays headlines
http://news.yahoo.com