DSXchange

Hi ^_^ the files that are created when you create a job reside into the project directory. You can identify this file with the job ident appends to the file name (field JOBNO in DS_JOBS). Into DS_JOBOBJECTS table you can find all job objects (stages, links and so on). I hope this will help you Ricca...

Hello Pavan, I was reading some passages on the DataStage digest. I just want to make sure I understand your comment on one particular issue. So the following files that are created when a job is created resides under DS_JOBOBJECTS and not in the project directory in version 5.1. If you can just cla...

hi , is there any site where i can find samples of datastage files that is .dsx files or zips.i am currently developing a complicated ETL process using datastage. any information on this would be of great help or if some one can send some good datastage application developed it would really help in ...

Hi there, goodmorning, Ive problem with Extract Pack plug-in that return me the following abort message: Mismatch in number of column between data and link. After row 1, link......., while processing column ...... Ive checked the data on SAP system, but everythink seems to be OK. Do somebody have ne...

Avoid using spaces in the names of jobs. Those jobs can be recovered, but you will need Engine-level commands to do so. Contact Ascential support for details. Ray Wurlod Trainer, Asia-Pacific Region IBM Informix Education Department Level 22, 60 City Road Southbank, Victoria, 3006 Australia Telephon...

Hi All I dont know whats happening with our server(NT) but we are developing jobs and the jobs are erased from the Manager after we disconnect! The name of the job seems to be in the VOC but there is no way we will find the job back. And there is a job named PDI 1 (the "PDI" are the first characters...

Yes, what your asking can be done. It uses ODBC rather than OCI. However, it doesnt sound the best solution for your problem. Your concerns are unfounded. DataStage will declare a query with oracle using the SQL in the lookup stage, with bind variables. For each row your transform processes, it will...

If you are running DS5.1, there are no longer DS_Jobnn table/folder, instead all the job object ids are in a separate table called DS_JOBOBJECTS. PKM -----Original Message----- From: wolfgang.huerter@gerling.de To: datastage-users@oliver.com Sent: 5/8/2002 7:19 AM Subject: RE: Files created for a jo...

Hi, I have a task in which I need to do an Oracle lookup based on data being passed through some transformer stages. The table I am doing the lookup from is very large and Im not certain that a straight Oracle8 OCI lookup stage wont attempt to return the entire results from the table for Datastage t...

This is a topic for an orphaned message.

Hi all,

I need export some jobs with a command line. Somebody can help me?

Thanks, Boris.

Hi Boris, you can export only whole projects using the command line. Take a look to "Datastage Manager Guide" and search for dsexport/dsimport. Hope this will help you Regards, Riccardo ----- Original Message ----- From: "Boris" To: Sent: Wednesday, May 08, 2002 3:53 PM Subject: Export e import comm...

Hi Denzil, what Giovanni wrote is a good mean to solve your problem. Each Job creates several files in the project directory. (RT_LOGnnn, RT_STATUSnnn, RT_BPnnn.O, RT_BPnnn, DS_TEMPnnn, RT_CONFIGnnn, DS_JOBnnn) where nnn is the number of the Job. You can get the number of the job in administrator wi...

Riccardo, this is a known bug for this DS release and HP-platform. Please contact your Ascential support team. Best regards Klaus -----Original Message----- From: Riccardo Tani [mailto:riccardo.tani@datamat.it] Sent: Tuesday, May 07, 2002 12:09 PM To: datastage-ML Subject: Scheduling a job Hi, Ive a...

Hi all Can someone give me a list of files (or extentions) that are created when a new job is designed for datastage? I need to change a few of those files permissions because Ive gone and created a job using root and not the development user. Now the dev user cant run/edit those jobs. Lesson learnt...