DSXchange

I am running into this same problem. In the 'CFF Stage' -> 'Output' tab -> 'Selection Criteria' tab in the 'Redefined Fields' frame it is easy to choose an 'ID Field:' in the drop down and specify the 'Value:' to search for. This can be completed for many values provided you have an output link for ...

5. I don't believe I have a syntax error because the following command will throw a "80011 - Incorrect system name or invalid user name or password provided." error. C:\>"C:\Program Files\Ascential\DataStage7.5\dsjob.exe" -file "C:\Program Files\Ascential\DataStage7.5\Server...

Thank you for the explanation although I believe I have retraced all of the scenarios. 1. The IP address and server name do resolve using ping/nslookup. 2. I can log on to the AIX server with my user and password through telnet. 3. I can log on to DataStage Designer (10.10.10.10 and Project01) with ...

This appears to work fine: ------------------ Intializing Compiling "Job01" - Succeeded Compiling "Job02" - Succeeded Compiling "Job03" - Type cannot be compiled Compiling "Job04" - Failed etc. Done. ------------------ "C:\Program Files\Ascential\DataStag...

Yes, all other DS clients work correctly, i.e. DataStage Designer DataStage Administrator The closest I can get with all of my variations on syntax and parameters is the following which throws a "80011 - Incorrect system name or invalid user name or password provided." error. C:\>"C:\...

I can ping/nslookup and see the ip address and name of the server from the PC.

I have used the IP address and name of the server both in the dsjob command.

I have used my id+password and root id+password.

Is there a "PC host file" for DS I need to update?

The password is correct for the user I am specifying.

I don't recognize the "PC host file" you refer to. Can you elaborate?

Thanks again!

From www.webopedia.com TCL (outside of DataStage) Short for Tool Command Language, and pronounced T-C-L or tickle, a powerful interpreted programming language developed by John Ousterhout. One of the main strengths of Tcl is that it can be easily extended through the addition of custom Tcl libraries...

################################################################################ # Run job here ################################################################################ echo "dsjob -run -jobstatus -wait ${SET_PARAMS} $PROJECT $DSJOB" dsjob -run -jobstatus -wait ${SET_PARAMS} $PROJ...

chulett wrote:"Apathy Sweeping Nation, No One Cares"

How about:
"I joined the team and was met with ignorance and apathy." Well, what are you going to do about it? "I don't know and I don't care."

Actually, -lparams was what I desired:

Job_Params=`dsjob -lparams DSProject DSJob`

Status code = 0
file_name1
file_name2

Thank you for your help Craig. You set me on the right path!

Is there a way to attain job required parameters from a Unix shell script? I know I can get some job information using: Job_Info=`dsjob -jobinfo DSProject DSJob` Status code = 0 Job Status : NOT RUNNING (99) etc... But this does not show that the job requires two parameters when called, I.E. file_na...

Hello Wolfgang (WoMaWil),

I agree with your three tier approach to parameter management. Could you give specific parameters you keep in each tier, i.e.

(a) Platform Parameters
DatabaseSID, DatabaseUser, DatabasePassword

(b) Job Parameters

(c) Job Cycle Parameters
CycleNumber,Date?

Thanks,
CBC