DSXchange

So the difference lies in the time required to set up the query? I don't know what the difference could be. It must be something else that hasn't been identified yet - could there be anything else? Different userids on UNIX or in connecting to the DB? We are on Windows Server. SQL Server takes the ...

Are you 100% certain that the job gets started the same way (i.e. same parameters, no reset-if-required switch) between the 5-second and the 2-hour run? Check you 2-hour log - is there a large startup or finish time or do the rows process much slow? DataStage jobs are started as background processe...

We have scenario where a particular job runs in 5 secs (stand - alone). When the same job run through JobControl and/or Sequence, runs for 2 hours. We are passing the same parameters either when run individually(job alone) or through the jobcontrol and/or Sequence. Job is reading from a Table A (SQL...

Hi Folks, We are using DS 7.0. I'm not able to open a routine/job activity in a Sequencer job(in designer). This problem, i'm getting after my OS is upgrated to windows XP. And in all XP systems we are not able to open job/Routine activities. Let me know what is the problem and how to over come thi...

My JobSequence got aborted after running job J2 and jobSequence status is in Finished Status , instead of Aborted status . **************** My Sequence Job does not actually say it aborted, it says its finished, though Job J2 failed(aborted). Though it didn't start J3 & J4 (which is correct) , ...

My JobSequence got aborted after running job J2 and jobSequence status is in Finished Status , instead of Aborted status . **************** My Sequence Job does not actually say it aborted, it says its finished, though Job J2 failed(aborted). Though it didn't start J3 & J4 (which is correct) , S...

I have a Sequence job which runs jobs J1,J2,J3,J4 one after the other. I had enabled the following: Add checkpoints so sequence is restartable on failure Automatically handle activities My JobSequence got aborted after running job J2 and jobSequence status is in Finished Status , instead of Aborted ...

When loading the hashed file, load them as all upper-case or lower-case characters(see UPCASE() ) in a prior transformer. Convert the primary lookup to the same case using the key expression: UPCASE(in.col) PX has a case-insensitive lookup option. I havent found one yet in server. Thanks Craig &...

Is it possible to do a " Case Insensitive LookUp " from the HashFile? I have value coming from PrimaryInputRecord as " Single " and in the ReferenceHashfileRecord as " SINGLE ". I should able to say that the record is matched. How can i do this? Any thoughts? Thanks in ...

list of active and passive satges PASSIVE STAGES db2/udb dynamic rdbms ms oledb Odbc universe &unidata oracle redbrick load stored procedure Sybase Teradata complex flat file sequential file folder hashed file ACTIVE STAGES Aggregator command stage ftp plugin inter process link collector link p...

You have posted in the parallel jobs forum but specified "server" as your job type. Which is it? Particularly if it's server, please advise precisely what you mean by "partition", which has a very specific meaning for parallel jobs. Iam sorry, Its my mistake. I was supposed to p...

Poorna, DataStage has no real concept of datatypes and variables are not declared. Variables are typed according to the operations performed on them. In your case the value of the parameter is being set to parmPartitionId -1 which is a mathematical operation and thus it is considered to be a numeri...

Is there a way to define the Basic variable? We have coded JobControl using UniverseBasic in DataStage. I have a variable called "parmPartitionId". I would like to define its type as Character. How can i do this in Basic? The reason i want to define its type is: in the JobControl we have c...

You have to use the TCL prompt in a telnet session. You need to change to the DS engine directory. Enter ". ./dsenv" to put the environment file into your environment. Then, either "bin/uvsh" or "bin/dssh" depending on your version. You're now in the engine shema. Type...

You have to make the SQL all one line if you do it this way. The results can be copied with normal Windows cut and paste commands. Hi Duke, Let me tell you what i am doing? In DataStage Administrator, selecting the appropriate Project and clicking on "Command" button. At the Command promp...