DSXchange

To Forum Were processing Cobol files and would like to create a single row audit file once the Transform has completed processing the Input file. Were using DS6.0 I know there is a transform that will tell me the number of rows that were processed based on my constraints. That is not the problem. Th...

Hi , We are using Microsoft Visual SourceSafe for source code control. We export the DataStage components and create a .dsx file. We check in and check out the .dsx files for source control.This is what we are doing presently. Do mail in if there are better inputs on the same. With regards, Wilcy Wi...

Hi , We are using Microsoft Visual SourceSafe for source code control. We export the DataStage components and create a .dsx file. We check in and check out the .dsx files for source control.This is what we are doing presently. Do mail in if there are better inputs on the same. With regards, Wilcy Wi...

Hi, Just wondering if anyone out there has managed to successfully integrate any of the standard source code control systems (MS SourceSafe, PVCS, SCCS, etc) with DataStage. We have tried the Version Control product but need something that gives us a greater level of control over our sources specifi...

We do usually use UNC names. Its really easy and convenient once correctly set up. IMO, it is a much better method than maping drives* And its easier than FTP when you are in de Zindoz world. The main point is that DS must run as a user with appropriate network rights. The default is the local syste...

This is a topic for an orphaned message.

We dont run on NT, we have a Unix server, but have had no issues expanding the space allocated to DataStage. Not sure thats really equivalent to what youll need to do - are you planning on *moving* your installation to a larger drive? Id imaging doing that may wreak havoc on your installation unless...

Hi Brad, Seeing as you are using Windows, you can quite happily use drive mappings to shares on other servers or even UNC names (ie serversharefolder... etc ) when referring to files in a sequential stage. Just remember that any drive mappings you might choose to use must be set up on the server and...

We are running DataStage 5.2r1 on a Windows 2000 Advanced Server (i.e., NT) with a 30GB harddrive. Due to the large sizes of some files were processing, we are having major space problems. Only about 3GB left, which gets chewed up quite easily with large sequential files. So, weve requested our LAN ...

We use a job, launched at the beginning of our ETL application, to reset all the jobs in the project (See the code below). However, instancied jobs are not reset, and sometimes they could never run anymore ("Job control error (-2) (DSRunJob) Job GetRejectsList.Suppl is not in a runnable state") Seem...

Hi Karthik, this is a strange behavior, could you send us the error log? ..could you explain us what this job do? Regards, Riccardo ----- Original Message ----- From: "Kandamuri, Karthik" To: Sent: Thursday, December 05, 2002 5:46 AM Subject: Aborting a job if the input table has no records > Hello ...

Many thanks wolfang. Rgds Mani wolfgang.huerter @gerling.de To: datastage-users@oliver.com cc: 04-Dec-2002 Subject: RE: Validating a job with DB stage 03:25 PM Please respond to datastage-users Sender Info: No Sender Info found in the address Book Hi Mani, yes, that is a normal behaviour in DataStag...

Hi Karthik You can create a control job that analyses the link down which the data from the source table flows. Use an if statement to branch accordingly. Good luck Adam "Kandamuri, Karthik" on 05/12/2002 03:46:30 PM Please respond to datastage-users@oliver.com To: datastage-users@oliver.com cc: (bc...

Hello Everyone, I have job where in if there is no data in the source table, Job should start and look for records in source table, and stop if no records found. Job Should not Abort as this is considered as a job failure preventing the following jobs in Nightly batch jobs. How do I do this in DataS...

You will possibly have noted that the names of the generated programs do not refer directly to the stage name or link name, instead using an internal DataStage representation such as V0S2. The names of generated DataStage BASIC source code follow a convention (I wont bore you with the details, but -...