DSXchange

I had two client pcs, one running Windows95 and the other running Windows98 that errored out after installing the 5.1a client. Other Win98 and Nt clients installed without a problem. Im hoping someone has the fix for this, as Ascential is closed today. Apparently, this is a known possible problem, a...

Hi Gang, On an NT Server (running NT 4.0 SP4 at the moment, soon to upgrade to SP6), I need to be able to execute a DOS command to run "something" to convert an MS Access database into a tab (or semicolon) delimited text file. Im asking about DOS (i.e., command line via DS ExecDOS statement) because...

Hard to tell w/out seeing the Job itself. Are all your inpute going thru 1 transform or 3 separate one ? Im guessing 1. Another item: are you using Stage Variables to help control the inputs and outputs? The error indicates that output from 1 of your FTP is conflicing with anothers in regards to the...

Yes, all FTP processes run in parrallel in 1 GUI job an create a single output hashed file for time saving. Before we ran FTP sequentially. Thanks, Leonid Himanshu Patel on 02/18/2002 09:08:15 AM Please respond to To: "datastage-users@oliver.com" cc: Subject: RE: FTP problem are all FTP processes in...

are all FTP processes in 1 job ? perhaps one is clobbering the other during certain run times. a suggestion is create a job control job and execute the FTP processes individually or, set it up Control Job so that each FTP process starts a few seconds apart. -----Original Message----- From: lfrumke@s...

Hi all, I am running a job which does 3 parallel FTP processes (written in GUI). It gets 3 files from 3 different servers and puts output on the same hashed file. There is no way to have duplicate records on the source files. This job failes 2-3 times a week, each time on a different link. We use DS...

Save the following in a bat file name check.bat @echo off rem 2001 , Comparex Africa COA, Pieter Brundyn if not exist %1 goto notfound goto found :notfound goto exit1 :found echo File has been found.... rem Run a program... goto exit1 :exit1 ----- From datastage run (using CallDSExecute) check.bat C...

Under DataStage Director, on the menu, select jobs->cleanup resources, this will allow to view/release/logout process and locks for all jobs and users. In order to access this menu, you must enable "job administration in director" for projects within DataStage Administrator. -----Original Message---...

also within administrator there is a section that allows you to run universe commands. in there, you can type in: UNLOCK ALL this will unlock the file / record locks datastage created within universe. -----Original Message----- From: DaeHwan Kim [mailto:whatcanido@lexken.co.kr] Sent: Monday, Februar...

Thanks Dave, At the end, Ive founded it. But what Im afraid to do now is change this parameter on Production Environment. Do you know whats the inpact on the DataStage installation and on Projects?. Cause checking on the description of this parameter Ive verified that is enough "dangerous" to change...

>Program "JOB.58782607.DT.1246837844.V0S7": Line 281, Attempted WRITE >with record ID larger than file/table maximum record ID size of 255 >characters. > >Somebody know if there is a limit to the Hash File Key?? Yes, the maximum key size is/was 255 characters. There is a configurable parameter, MAXK...

Hi we have detected a problem when we useda ODBC driver, it gave the next error Statement was:SELECT dummy FROM dual SQLSTATE=27, DBMS.CODE=3114 [Ardent][SQL Client][ODBC][MERANT][ODBC 20101 driver][20101]ORA-03114: not connected to ORACLE We use the datastage 4.0, in a Unix machine, with ORACLE 8.0...

Thanks Aedla for elaborating the steps... Regards, YN --- Phaneender Aedla wrote: > Hi, > > This is for Windows. Not sure abt any other OS. > 1. Login as the Administrator into the DataStage > Director. > 2. Go to Job --> Cleanup Resources (this will take a > few mins). > 3. You should see a window ...

Hi Kim, Thanks.. it worked. Now I do not need to restart the DS Server!! YN --- DaeHwan Kim wrote: > Hi > If You Know Job No (Internally, DataStage job has > unique job no) > > First Check Process with Job no. > > You can see datastage directory menu ( Job --> > Cleanup Resource) > If this menus dis...

Hi, This is for Windows. Not sure abt any other OS. 1. Login as the Administrator into the DataStage Director. 2. Go to Job --> Cleanup Resources (this will take a few mins). 3. You should see a window which has two frames in it - a. Click on the radio button - Show All in the top frame. b. Look for...