DSXchange

I am trying to extract data from a Unidata database using the Unidata stage in DataStage for a 24 month rolling period based on a period end date. I have tried the below but it does not seem to be working properly.

UTM_PERIOD_END > @DATE -24

Thanks for the help. We were also looking at the Change Data Capture plugin to reduce the amount of data going across the WAN. Has anyone else used this plugin and is it work the investment?

We have the option to either use a DataStage environment where the source systems reside or where the target Teradata database resides. Do you think it would be better to query across the WAN from the source our push the data across the WAN to the Target?

We are working on a data warehouse project that involves moving data across a WAN. We have been challenged by management to leverage a Teradata database that is located 400 miles from our headquarter building where all the production data resides because of a prior investment in Teradata by another ...

I checked the logs for the anti-virus client and there are no files quarantined. I am able to run the sqlldr from the command line without error also.

Thats correct everything was working fine on the server until yesterday. There was a new version of anti-virus client installed on the server last week but we removed the anti-virus completely and the problem still exist. Here is the details behind the error message. Also when you go look for the lo...

Our development DataStage environment has stopped running any parallel job that has an Oracle stage. Below is the error log we are receiving. I have checked the permissions on the server for Scratch and the dsadm user has administrator access. Occurred: 10:24:01 AM On date: 2/1/2011 Type: Fatal Even...

Was this issue ever resolved? I am getting the same error message in an 8.1 Windows environment.

I tried to add the /D command, but it gave me the error below: dscmdexport aborted: Failed to attach to the project And you say that exactly the same batch works fine when you run it manually? Yes, sir. Run just fine when I kick off the batch file manually via command line. Will not run via windows...

ray.wurlod wrote:I know they're not supposed to be positional, but try it with the domain switch first. For example:

Code: Select all

dscmdexport  /D=%Domain% /U=%User% /P=%Password% /H=%Server% %ProjectName%

Thanks, but I tried it that way.

Wasn't talking about the Windows scheduler or what user it uses to run the task but rather something you probably need to add to the dscmdexport command line: dscmdexport /H=%Host% /U=%User% /P=%Password% /D=???? I tried to add the /D command, but it gave me the error below: dscmdexport aborted: Fa...

Probably a crendentials issue. For the 8.x release, I believe you'll need to add the /D "domain" parameter as well as the normal userid/password. Any idea on how to setup the Task Scheduler service login? Right now it is configured to run as Local System, the task itself uses a DOMAIN\Dat...

After removing the start /wait atleast now the scheduled task will run and create log files with the error below in the logfiles.

dscmdexport aborted:
Failed to attach to the project


Thanks.

This batch file works when I run it interactively, but the dscmdexport command does not export the projects when I run it via the windows task scheduler. Anyone have any suggestions. The only thing I can think of is there is something different about the environment when the scheduler runs the scri...

chulett wrote:There's a complete, working version of one in the DS Tips section of Kim Duke's website. You could use or at least crib from it.

Kim is using 7.5 where I am on 8.01. Kim also uses dsexport where I am using dscmdexport.