DSXchange

Well, this was something I am very much aware of, but it is good information for Ramesh to know. I was going to go down that path, but the code error seemed so obvious I started there. An additional point is the fact that, even if you run your scripts as root or dsadm, this *still* isnt the same as ...

DataStage can import the table definitions from SQL Server (through and ODBC data source, for example) then you can use the documentation tool or MetaStage (if you have the latter) to export them in a format that Tony can use. ----- Original Message ----- From: Doris Zammit Date: Fri, 10 Jan 2003 16...

Point of information: DataStage jobs execute under the environment of the engine daemon, not the user. Anytime you run a command/script from the system prompt and it works, then execute it from a job and it doesnt work, youre problem is most likely due to the fact that YOUR environment is not the JO...

Does the script not work or does DataStage just *tell* you it doesnt work. You might want to look at changing your code something more like: Call DSExecute("UNIX", "/datastg/Ascential/DataStage/DSEngine/temp/test_ftp.ksh", Output, ErrCode) If ErrCode = 0 Then GoTo NormalExit End MissingFiles: Call D...

Hi, I am calling shell script from datastage batch job, the code is as fallows. Call DSExecute("UNIX", "/datastg/Ascential/DataStage/DSEngine/temp/test_ftp.ksh", Output, ErrCode) If ErrCode 0 Then GoTo MissingFiles End MissingFiles: Call DSLogWarn("ftp canceled.", "FTPCONTROL") NormalExit: the shell...

Hi Don, Other than Jaick (since he will be in training), is there a someone that has access to a tool that can read SQL Server db table layouts? Im asking this because the DOT production files that we are moving now write to six existing SQL Server tables. We need to get the structures to Tony so he...

You really should send a new email for a new problem, instead of combining the two together. First problem: either way works. Its really up to you how youd prefer to get files from one server to another. Second problem: You didnt say what flavor of Unix you are running or if you are using OCI, but i...

Hi, Yesterday installed data stage 6.0 Created new project and started designing jobs. client to server connection is diconnecting freequently. The fallowing message is displaying Error calling sub routine: DSR_RECORD (Action=2); check datastage is set up correctly in project EDWDEV (The connection ...

Hi, Data stage server is on one unix box, but source files are on another unix box. always source files will be on remote machine, so for daily loading what is the best method to access those files which are on remote machine from datastage? can we use FTP stage at this point or simply copy files fr...

Yes, I suggest this way to control the status of connection, not for kill a process Bye. -----Original Message----- From: David Barham [mailto:david@barham.hm] Sent: Friday, January 10, 2003 9:26 AM To: datastage-users@oliver.com Subject: RE: how to kill a DS job.. Just a quick note on dsapi_slave.e...

Just a quick note on dsapi_slave.exe. This is not a running job. This is part of the server side of a client connection such as Director or Designer. A running job will appear as uvsh.exe in task manager. Task manager really isnt a pretty way to kill a job. It can leave locks in UniVerse that you ma...

Hi Lisa, Ive encountered a problem like yours, trying to aggregate record that has a null value in it. Check if also for you is the same (but I think yes) and replace the null value with string character. This will probably solve your problem. I hope that this will be helpfull for you. Best rgds Gio...

Hi Bhattacharrya, When you try to kill the process by director control with Task manager if exist the process dsapi_slave.exe because can be happen that there are more dsapi_slave running. Bye Sal. -----Original Message----- From: Giovanni Boccia [mailto:giovanni.boccia@cgey.com] Sent: Friday, Janua...

Hi Bhattacharya, First of all I suggest you to che if the job is really running, by DS.TOOLS command. If the job is running first of all try to stop it by Directory client interface. This will be enough for stop it. If isnt you can use DS.TOOLS for "kill" the process. If you check that the process i...

Surendranath If you are on UNIX this may be possible if your permissions are setup correctly. It could easily blow up on you too. You have to setup your default umask to be 002. Each project would then have to be owned by a different group. The users would also have to be in different groups. You sh...