DSXchange

The UNIX-Copy command is the "cp"- or "copy"-command. (look man pages for details) You will get a copy of the file(s). You have then to find a mechanism not to load rows twice and not to load rows not, but there are most times mechanism in the file itsself. You only have to analyse. So much fun and ...

unfortunately, were actually still at 4.0 although i do have 5.2 stilling in my desk drawer ( great place for it huh.) anyway, were an NT shop so Im afraid I would not be able to help in offering a unix version of xcopy -----Original Message----- From: DS User [mailto:dsconsult2002@yahoo.co.in] Sent...

thanks for your comment. are you using v5.2 to run multiple job instances? what is the equivalent of Xcopy in unix environment. --- Himanshu Patel wrote: > We do runs about 4 times a day in some cases. > Using the Xcopy command we > move the needed 4 gigs of data files over in about > 5-6 minutes. M...

We do runs about 4 times a day in some cases. Using the Xcopy command we move the needed 4 gigs of data files over in about 5-6 minutes. My jobs are scheduled to run once another batch job verifies the files have been copied over. thats as close to real time ass we get. -----Original Message----- Fr...

Hi Mark, I was using oracle stage first but got inconsistance data type error for those 2 fields were defined VLOB. I was able to load table successfully by using ODBC early on, then recently that error kept coming up. If I could use oracle stage without problem, Id have used it in the first place. ...

Hi All! Has anyone used DS in real time processing? Files are being generated at a high rate ; hundreds in a few secs. The 2 main problems being faced are: 1> Moving files from the ftp area to the work area takes a long time. 2> While moving files to the work area, the client acquisition application...

Why are you using the ODBC Stage for Oracle? Why not use the OCI Oracle plugin and eliminate the ODBC layer all together. Oracle ODBC sits on top of Oracle Net8 so you must have Net8 configured on your DS server already. Try it. It might work for you. ----- Original Message ----- From: "James Lin" T...

Hi all, We are using datastage 5.1 and Ive been having trouble using ODBC stage to load oracle table. In this table, there are 2 fields defined as LongVarChar datatype from oracle but datastage does not support it. So I changed the data type to varchar and modify length to 10240. Strange enough, som...

Hi, I had a similar problem. Got the same message - Verb "UNLOCK" is not in your VOC. I had opened a telnet session from the server and had logged myself on and then onto the project. The UNLOCK command worked here (somehow). Later, I could release the locks from a remote system. Probably the UNLOCK...

I pulled this previous post out of the Oliver archives. In case someone wants to find a solution that may have already been discussed to death, you can go to www.tools4datastage.com and search the Oliver archives available there. How to unlock locked DataStage jobs for NT: You can use windows telnet...

maybe that youre right Larry, I still have DataStage 3.6 and I went to a collegue who has 5.1. There uvsh still works. The uvsh command itself is not in the project directory but in the datastage/bin-directory, which has to be put in path. Wolfgang > -----Original Message----- > From: Bos, Larry E [...

Hi Wolfgang, Thanks for your response. Unfortunately, neither your first nor your second suggestion works. I am running DataStage 5.2 on HPUX 11. None of the project directories in Unix has a uvsh command. And, as Raymond said, when you enter DS.TOOLS in the Administrator, the output is hard to read...

Hi Larry, as Raymond already wrote you have two options: (1) You start the Administrator, select your project and go to "command"-Button. There your write the letters "DS.TOOLS" and then the button "ececute" (2) on the unix-machine go into the directory of your project and then you write "uvsh" you ...

Raymond, Your response doesnt compute for me. What is "the Server Engine account"? How do you "run the DS.TOOLS menu"? I can run a program/command, but a menu? Is this maybe only for Windows servers? Larry -----Original Message----- From: Raymond Wurlod [mailto:wurlodr@au1.ibm.com] Sent: Tuesday, Ju...

Hi Henrik One option is to do a lookup on the target table before the insert. If the row does not exist then do the insert. However, if the target table is very large you may want to create a hash file of the target table first. The hash file approach will speed up processing vs looking up directly ...