DSXchange

> Just in case anyone was interested.... My theory was wrong. I had assumed that the job was in the running state due to the scheduler kicking it off. But, the detail I missed was that it was actually still running from the prior day. So, I had to enhance my sleep logic to wakeup when the end of day...

I just had to do this for a job and normalized the records (after parsing for desired values) by concat a CHAR(10)(On Unix) on the end of each record- in the next stage, set line termination to none. This performs a pivot for you. By writing to a file and describing input/output differently, you ess...

There is not much happening on the system - but I believe the problem is connecting to the datastage server. In connecting through director, designer or manager - it is taking 30+ seconds just to display the list of projects. On our dev box is takes about 2 seconds. -----Original Message----- From: ...

The box in question is doing virutally nothing. 4 processors with an average of 95% availability and loads of memory. Unfortunately I do not know what (if anything) has changed. In using a dsjob in this way - is this creating a seperate session on the box ? -----Original Message----- From: Ray Wurlo...

Are there lots more jobs or much more activity on the system than there was when the times were acceptable? What else has changed in the meantime? ----- Original Message ----- From: Ian Godsell Date: Tue, 11 Mar 2003 08:39:28 -0000 To: "datastage-users@oliver.com" Subject: dsjob logsum - Slow down i...

Hi, I have a shell script that retrieves the log summary for a job. The syntax is as below. ../DSEngine/bin/dsjob -server 255.255.255.255 -user username -password pwd -logsum projectname jobname This command used to take around 3 or 4 seconds to complete. However it is now taking 30+ seconds. Has an...

DS4.2 on Win NT The user has administrator right and problem is with this project only and problem started suddenly. The files (RT_LOGXXX) are existing and then why this is giving error? Thanks, Binu -----Original Message----- From: Craig Hulett [mailto:Craig.Hulett@attbi.com] Sent: Mon 3/10/2003 7:...

Is there a known limit on how many fields there can be? Option 1 - requires an arbitrary limit. Define a field list which allows for the maximum number of allowable subfields. Definitions might look like... Field1 Field2a[";",1,1] Field2b[";",2,1] ...etc Field3a[";",1,1] Field3b[";",2,1] ... etc Put...

Hi Andrew, You can use Field1[1,1],Field2[1,1],Field3[1,1] Thanks Siva ----- Original Message ----- From: "Burton Andrew" To: Sent: Tuesday, March 11, 2003 9:53 AM Subject: substrings into records Hi all, How would one take an input as follows (3 example records- 3 fields each): "A","G","X "B","G;H"...

Hi all, How would one take an input as follows (3 example records- 3 fields each): "A","G","X "B","G;H","X;Y" "C","G;K;M","P;Q;R" and produce the following desired output: "A","G","X" "B","G","X" "B","H","Y" "C","G","P" "C","K","Q" "C","M","R" Any ideas? Thanks in advance... Andrew Burton. *********...

Thanks everyone for their suggestions -----Original Message----- From: Kim Duke [mailto:Kim_G_Duke@Yahoo.com] Sent: Thursday, March 06, 2003 4:26 PM To: datastage-users@oliver.com Subject: RE: Help on uv sql code Surendra There is no describe command. To list the fields on a hash file: LIST DICT DS_...

Binu R T. wrote: > Hi all, > Im getting this error while selecting view --> Log in director. > Jobs are not running in this project. > > Error selecting from log file RT_LOG652 > Command was: SSELECT RT_LOG652 WITH @ID LIKE 1N0N AND ( TYPE = 2 OR > TYPE = > 3 OR TYPE = 4 OR TYPE = 5 OR TYPE = 6 OR T...

I will be out of the office starting 10/03/2003 and will not return until 24/03/2003. ----------------------------------------------------------------------------------------------- Have you seen our website?.... m CAUTION: This correspondence is confidential and intended for the named recipient(s) ...

This is a topic for an orphaned message.

DataStage security is set up on a per-project basis. In Administrator client, use different groups in each project as DataStage operators and developers. Then assign appropriate personnel to appropriate groups in the operating system. > -----Original Message----- > From: Dahlfors M. (Martin) [mailto...