Search found 21 matches

by brownnt
Tue Feb 02, 2010 9:22 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Dscmdexport via Task Scheduler
Replies: 27
Views: 16530

try to echo path and the command you are going to execute. like adding echo %PATH% >path.txt echo (start /wait %ExeDir%\dscmdexport /H=%Host% /U=%User% /P=%Password% %%a %ExportDir%\%%a.dsx /V) > command.txt to see if path is correctly reflected to the script and you are getting the correct values ...
by brownnt
Tue Feb 02, 2010 8:55 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Dscmdexport via Task Scheduler
Replies: 27
Views: 16530

You are running the script in verbose mode so why don't you put the logs in to a log file to make the life a bit easy. Some useful information can be found in the log file. Do something like ........%\%%a.dsx /V > %ExportDir%\%%a.log and let us know the results and anything in that log files if cre...
by brownnt
Tue Feb 02, 2010 7:28 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Dscmdexport via Task Scheduler
Replies: 27
Views: 16530

Dscmdexport via Task Scheduler

I am working on a batch file that runs dscmdexport to export a list of my projects from reading a text file of project names. 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 sugg...
by brownnt
Tue Jan 26, 2010 4:45 pm
Forum: General
Topic: Converting Special Characters in Datastage
Replies: 3
Views: 12830

Converting Special Characters in Datastage

I am reading a file that has a multi-value field. The data in the multi-value field is separated with a special character( looks like a box). When we used oracle 9 it would convert the box to a question mark. Then in the transformer, I would convert the ? to blanks. Now that we have converted to ora...
by brownnt
Wed Jan 13, 2010 11:53 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: UniData 7.2.3 Upgrade with server job
Replies: 4
Views: 2161

Ok good. All of our jobs are using ODBC to connect to the Unidata which should work fine on Unidata 7.2.3 right?
by brownnt
Tue Jan 12, 2010 10:51 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: UniData 7.2.3 Upgrade with server job
Replies: 4
Views: 2161

UniData 7.2.3 Upgrade with server job

We have several server jobs that pull data out of our leasing system Infolease and it uses Unidata stage as the connection. Our company is looking to upgrade our version of UniData to 7.2.3. Will DataStage 8.01 work with this version of UniData or will we have porblems?