DSXchange

Hi, All I have a job which call unix script to extract data from csv file being in Unix. For some reason, this job kept running serval hours last night, but did nothing. This morning, I tried to stop it by command dsjob -stop ..., its status was still "RUNNING", Then I went to Cleanup Resources, log...

Hi, We are just starting a project using DataStage/XE 390 and are wondering whether people are using the sort routine that comes with DataStage Mainframe as opposed to doing the sort directly from JCL using the mainframe sort. The DataStage sort routine does use the mainframe sort through the use of...

Ray is absolutely right..I use Rays material (Advanced DataStage) as part of my lectures very often (Thanks Ray). We might be offering similar courses in the very near future here in US. Pavan Marpaka Datawarehouse Trainer Education Services Ascential Software Inc. 804-677-3346 (Cell) ----Original M...

The "clear table" rule. -----Original Message----- From: lhamilto@ncshealth.com [mailto:lhamilto@ncshealth.com] Sent: Monday, 13 August 2001 20:21 To: datastage-users@oliver.com Subject: Validation I have a job that has an update action to Oracle of Clear table then insert rows and is read committed...

DSHOME=`cat /.uvhome`;export DSHOME cd $DSHOME bin/uv "SELECT @ID,PATH FMT 40L FROM UV.ACCOUNT WHERE NAME LIKE DataStage%;" (Note that the SQL is case sensitive.) -----Original Message----- From: wolfgang.huerter@gerling.de [mailto:wolfgang.huerter@gerling.de] Sent: Monday, 13 August 2001 20:15 To: ...

Hi Mark, Thanks for your inputs. They have really been very helpful ! Regards, Bibhu --- mark.huffman@baesystems.com wrote: > Bibhu, > I asked the same question of DS tech support a few > months ago, and > they sent me these two articles in response. I have > attached them as zipped > Word 2000 docu...

When you validate a job the clear table command is executed. Hendrik Kotze Systems Engineer Ascential Software South Africa tel: +27 11 807-0313 fax: +27 11 807-2594 mobile: +27 83 326-6439 -----Original Message----- From: lhamilto@ncshealth.com [mailto:lhamilto@ncshealth.com] Sent: Monday, August 1...

I have a job that has an update action to Oracle of Clear table then insert rows and is read committed. The job itself runs fine, however when there is data populated in the table and I have to make changes to the job and validate the job it removes all data from the Oracle table. Any Ideas as to wh...

Hi, when I am on a Server with DataStage, which is not my home I get information on the DataStage path when I write "cat /.uvhome" at the Unix-Prompt. Is there a similar command for finding the Path(s) of the DataStage Projects? Mit freundlichen Gruessen Wolfgang Huerter ----------------------------...

This is a topic for an orphaned message.

No, theyre part of the Education curriculum. Ray -----Original Message----- From: Bibhu C [mailto:bibhuds@yahoo.com] Sent: Sunday, 12 August 2001 17:37 To: datastage-users@oliver.com Subject: Re: AD: datastage performance Ray, So these performance related documents dont normally come with the DataSt...

Bibhu, Design and Performance are ideal bed fellows in a course to give understanding. Design choices always involve a trade of a number of issues: - Performance, - Maintian Ability, - Re-useability, - Standards, - Aesthetics. It should come as no surprise that the choice of which is most important ...

This is a topic for an orphaned message.

Ray, So these performance related documents dont normally come with the DataStage literature ? Thanks Bibhu --- Ray Wurlod wrote: > There is a whole section called "Designing and > Performance" in the "Advanced > DataStage" class offered in the Asia-Pacific region. > Note that this is NOT > the same...

There is a whole section called "Designing and Performance" in the "Advanced DataStage" class offered in the Asia-Pacific region. Note that this is NOT the same class as DS305 offered in the USA. -----Original Message----- From: Bibhu C [mailto:bibhuds@yahoo.com] Sent: Saturday, 11 August 2001 02:55...