DSXchange

This problem with parameters ... is this the change that arrived in about 4.1 or 4.2 or is this something different again? I know our 4.2 CD had a utility on it, which would search through all your functions to find those which change the input values. The CheckRoutines utility still appears to be o...

Hi all, We are using datastage 5.1 and have been told datastage does not support unique primary index. Is that true? When item defines as key, datastage will automatically define it as primary index in .fl file. I just want to make sure if datastage indeed not support unique primary index. James

A coworker spent 2 days this week trying to find the reason a job was aborting and we just discovered the reason. Anytime a called function modifies the passed argument value (we were doing an upcase) the job would hang, not even abort. The transformer thread would die, but not the main job thread. ...

Weve recently upgraded from datastage version 4.0 to version 5.2 and were having the following problem: "Abnormal termination of stage Account..Lookup detected". where Account is a datastage job and Lookup is the Transform stage. The problem is unpredictable in the sense that the job does run eventu...

DataStage Server Job Developers Guide, chapter 14 DataStage Development Kit (Job Control Interfaces), Command Line Interface (starting page 14-109 if you have DS 5.2 documentation) dsjob -run etc. Neil Beckwith Ascential Software, Australia & New Zealand neil.beckwith@ascentialsoftware.com ----- Ori...

Hi All I have UniAdmin installed on Windows 2000. I have a DataStage 5.2 server on the same machine. For some reason, I cant connect to the Universe database (with uniadmin). I get the following error: RPC Error: 81002 No connection I can connect using telnet localhost. I have added the following li...

For DataStage 5.1 and higher. CommandPath=`cat /.dshome`/bin $CommandPath/dsjob -server Elbert -user USERNAMEHERE -password PASSWORDHERE -run $Project $JobName Note: I set Project and JobName earlier in my ksh I borrowed this from.... Thanks, Lester F. Callif / Ascential Software, Inc. Centennial, C...

DataStage Server Job Developers Guide; Command Line Interface. In my version (5.1) its in Chapter 14. -craig Ian Godsell cc: Subject: Command line from Unix to run datastage 06/20/02 10:43 AM Please respond to datastage-users Hi All, Does anyone know how to call datastage job from the Unix command l...

"Kancharla,Radha,GLENDALE,IS" wrote: > Hello All, > I used the Merge stage to merge two big files with > complete outer join option and is very costly with respect to timing. > There are times, it is taking 3 to 3 hours just to merge two files. In > view of improving the performance, I am trying the...

This is a topic for an orphaned message.

Hi All, Does anyone know how to call datastage job from the Unix command line ? I cannot for the life of me remember the syntax. Or even better, point me towards documentation on it. Regards and thanks, Ian. ________________________________________________________________________ This e-mail message...

Hello All, I used the Merge stage to merge two big files with complete outer join option and is very costly with respect to timing. There are times, it is taking 3 to 3 hours just to merge two files. In view of improving the performance, I am trying the cosort and join option to merge two big files....

Hi, You require: 1. smtp server 2. blat configured on the computer where datastage server is installed 3. a file to read from You can use DSGetLogSummary, OpenSeq, WeofSeq to write into a log file. regards, A. -----Original Message----- From: Fan, Yuzhou [mailto:Yuzhou.Fan@okdhs.org] Sent: Thursday,...

Hi, You could probably have a control job that calls the job (say Job1) which u intend to run. Check the status of Job1 and if it has failed, then you can write a small statement like Job1 aborted using OpenSeq to a sequential file. Attach this file using Blat (if you are on DOS). For attaching Job1...

This is a topic for an orphaned message.