DSXchange

Hi everyone,

I need to compile all the jobs in a project and Id like to avoid to open each job in the designer and compile it.

Is there a command or function in Datastage to compile a job outside of the designer?

thanks

Sylvain

Ray, I would be interested to know if there is a non-SQL soln for "variable number of Field2 values per Field1 value". Thanks, Bibhu Rewards Data Team 503 220 3891 (Pdx) 801 333 5966 (Slc) "Raymond Wurlod" To: Niranjan.Purohit@ing.com.au Subject: Re: To derive a record from multiple records. 06/28/2...

There is a DSWaitforFile routine you can as a before job routine. -----Original Message----- From: Anju Musunuru [mailto:anju.musunuru@pmic.com] Sent: Friday, June 28, 2002 10:15 AM To: Data Stage User Group Subject: External dependencies We are using Data Stage XE v5.2 on a Win2k server to push dat...

There are several ways to accomplish things like this. Their is a command line interface, documented in the Server Jobs manual, that can be used to lauch a DataStage job directly from the O/S. The trigger or semaphore files way is also fairly normal and youve got a couple of choices on how to poll f...

We are using Data Stage XE v5.2 on a Win2k server to push data from Db2 on IBM Mainframe to SQL Server on Win2k. Is there a way to automatically kick-off data stage jobs after completion of mainframe job cycle (mainframe scheduler is CA-7, a computer associates product), and also to kick off mainfra...

Hello, There is a DataStage dll on the client of DataStage that encrypt data. The library is JOBAPILib( Path DataStage Instalatio of client jobapi.dll) and the class is IDSCrypt. > -----Mensaje original----- > De: BKS_Prasad [SMTP:BKS_Prasad@satyam.com] > Enviado el: viernes 28 de junio de 2002 14:0...

Hi Everybody While Exporting job to Xml file, the password of the data base gets encrypted. can anyone of u tell me the algorithm or the process which he is using for encryption and decryption of password. thanks Prasad ************************************************************************** This ...

Hi It depends on the volumes of data you are moving around, and whether you are experiencing problems with timings. Generally the OCI would be a little quicker than ODBC but nothing ground breaking. I think the ODBC stuff is just another layer on top of the core OCI anyway (someone please correct me...

"Never change a Running System!" If everything work okay and you dont have any performance or time problems, why should you change? If you change to OCI, the time you need may be between 60 % and 120 % of the time you need actually. If you are curious make a try and error, if not "be happy and dont ...

Niranjan, I taught a Red Brick class this week, during which I showed Amitabh a couple of techniques for pivoting data in DataStage. Ask him when he gets back. Your particular case (which is a "vertical pivot"), can be solved in a couple of ways, the appropriate one depending primarily on whether th...

Is there any way to derive a single record from multiple records associated with a common field? For example: If input consists of the following: RecNO Field1 Field2 1 X A 2 X B 3 Y C 4 Y D Output should be: X A B Y C D Thanks. Niranjan NOTICE The information contained in this electronic mail messag...

Hi, We are running on Oracle in unix environment and have used ODBC stages for all reads and loads. Any suggestions/comments on OCI and bulk loader? Many Thanks! ________________________________________________________________________ Want to sell your car? advertise on Yahoo Autos Classifieds. Its ...

Look in /etc/services, you should find an entry for the DataStage rpc daemon (uvrpc). Also, do the following: netstat -a |grep uv You should see the DataStage listener running. If you are missing the entry in /etc/services, then someone edited /etc/services and your entry got zapped. The safest thin...

All, In my schedule I am running four jobs in parallel and is working fine for some time. Recently I encountered the following problem which made the schedule to abort. All the four jobs ran in parallel and completed successfully. But at the end of one job, it did finish successfully,after that, the...

Hi!

Unable to open connection
Error:81014 - Cannot find UVRPC in host services file

Does anyone know what this error message means? I get that when trying to connect.

Thanks.

Christian