DSXchange

Hi , Problem : I have a source-table which is continuously updated with new records. Once a week I have to insert these new records into a target-table. The target-table contains all the history from the source-table. DataStage provides some Update Actions-properties like "Insert new or Update Exist...

Dear Martin, What do u mean by fine tune the memory usage for hash file, I think I need to increase it from 256 to about 1024 in order to be able to load all my hash files, another thing as I understand Preloading file to memory will increase its speed of reading and make it go faster not the opposi...

This command exists initially only in the Server Engine account (project). If you run the DS.TOOLS menu in a project account, UNLOCK and a number of other commands are automatically installed into the project. If you run DS.TOOLS from the Administrator client, the output is apparently garbage, becau...

Hi all,

When I tried to unlock a job, I typed the following under administrators command line UNLOCK USER 65079 ALL
But I get this message:
Verb "UNLOCK" is not in your VOC.
anyone know whats wrong?

James

The dsjob command takes in its syntax, and within the job itself, you can use the #DSJobInvocationId# job parameter.... its also on the DSMacro option list in the pull down of a Derivation. Ernie -----Original Message----- From: Ian Godsell [mailto:Ian.Godsell@Hutchison3G.com] Sent: Tuesday, June 25...

Hi Rui, What do you think to use a parameter for identify a File Name? if you use this way you can easly pass it to the output field. I hope this will help. Giovanni Boccia ----- Original Message ----- From: "Rui Soares" To: "Datastage-Users (E-mail)" Sent: Tuesday, June 25, 2002 5:40 PM Subject: Pu...

Hi All In executing a Data Stage job from director, the invocation ID is available. However, I am kicking off my jobs from the operating system using the dsjob -run command. In running the jobs using dsjob -run, I cannot see if how it is possible to have multiple instances of the same job running at...

Hi,

In Datastage how can we pass the name of the file, to a field of my output ?


with best regards
Rui Soares

I did some experimenting with the Before and After Stage SQL and lo and behold, the set forceplan works if you place it in the BeforeSQL tab. You can also insert into a permanent temp table( however not create a normal #temp table) and then select out into the output stream from the main SQL tab. Pe...

Peter, I also caught into the same type of situation and the solution I implemented was like this. I run Sybase SQL query using UNIX Script and call this script from datastage. Pass the output into the file. Then read the file in Datastage and do all other work. Only problem with this solution is, i...

Prasad...you didnt say how you were bringin in the XML content, or how you defined the meta data in the link grid.... The most appropriate way to bring in the content is to read it via the Folder Stage. This reads files in a subdirectory via name or wild card(s), sending the filename as the first co...

Try looking in the &PH& directory within the directory for the project. It contains work files and there might be some left over from your failed job. If you are lucky, the contents of these might give you a clue. The file names are generated, so you will need to match the update time of the file wi...

Hi Rui, Yes you can. You can use the FTP stage on Designer. This operation will enable you to create together with Cobol program, JCL for compilation and execution, also the JCL step for the FTP. The FTP can be made to both NT or Unix Box. Espero que te vaya bien. Ciao Giovanni Boccia ----- Original...

Hi All, I am using the xmlreaderStage as a source and ODBC stage as a target.when I am compiling the job using DataStage5.2 I am getting the following error"Plugin Stage does not have the required stream inputs". My xml file is as follows 10 ACCOUNTING NEWYORK 20 RESEARCH DALLAS 30 SALES DALLAS 40 O...

Dear all Im getting a rather unusual problem where a job aborts early in the process but is left showing a green-tick. There is rarely any further information provided to aid debugging, resolution, etc. Has anyone encountered a similar scenario? Has anyone any thoughts on how we stop this or find ad...