DSXchange

Ouch!! A DBA changing he default date format would definately cause problems with my assumption.

Did you resolve the problem? The person who mentioned changing the date to a char should be correct, although we use varchar. That and formatting the "date" field to look like 13-JUN-05 should let it go right into oracle.

In the before (or after) tab put the following line If CALL doesn't work try execute, but for some reason I think datastage likes call better. I tried looking for an example of how we do this but couldn't find one.

I know we do this, but can't find the job at the moment. I know that we use execute instead of call, and that it is in the after sql on ours, so I would expect the before sql to work as well.

You can only ftp from a machine with an ftp service running on it. So for the Unix server to open a connection to the windows server through ftp, then the windows server will need to have an ftp servcie installed and running. You could use the windows ftp if this is a server, otherwise there are thi...

Also in regards to the NFS drive, the users would only be accessing the parts of the unix server that you allow them to. Give them minimal permissions so that they cannot get at anything else.

You could also do a similiar script from the Unx side so that datastage fires off the ftp command to get the fiels from the windows server.

If they can post the files to a windows server running ftp, you could use datastage and the command stage to ftp the files off of the windows server and back to the unix environment. We do the opposite in our environment going from datastage on nt to Unix. You could also set up and NFS drive on the ...

Ray, I just want to clarify our scenario before changing anything. Our datastage server is running on windows 2k, it hasn't been changed and is functioning as expected on the windows side. Our Unidata server is running on AIX. Both Unidata and AIX have been updated here. When datastage connects to t...

well it was 6.0.14 that we upgraded to, but it didn't help much. If anyone is familiar with Unidata it is being suggested to us that it is a problem with the uni objects using the wrong temp space. i.e. not the one from the udtconfig file. But we can't find any configuration files that would seem to...

Its the Unidata temp space used by datastage. The correct temp space is being used by the Unidata database for all other processing. IBM has told us that version 6.0.8 of Unidata has bugs with uni objects and recommended that we upgrade to 6.0.12. We will be doing this tonight and I'll let everyone ...

We are running Datastage 6 from a windows server, it extracts data from a Unidata database running on an AIX server. Over the weekend we upgraded both Unidata (5.2 to 6.0.8) and AIX (4.3.3 to 5.2) and are now finding temporary files being created in our /tmp directory on the AIX server, when we run ...

Bruce, When a job is run from designer or kicked off manually in director the job is run as the user who is logged in to the system. When Jobs are scheduled they do not run as this user. To Check who the job is running as or change to run the scheduled jobs as a differnt user 1. Launch Administrator...

I called Ascential support on this, and was able to get from them that my problem is due to the security implementation in our network. When I log into thorugh the client, a security token is created and passed to the server. When I try and login to the other computers through mapped drives, odbc, e...

I haven't used the DSExecute to do this, but we do something similiar with the command stage and ftp in our jobs, using almost the same syntax Don't know if this helps in any way.