DSXchange

Yes you are correct! I actually did that but somehow left that line out of my post.

You guys don't miss a beat!

Thanks for that!

great! thanks

I am trying to get data from a remote Oracle database and insert it in my local Oracle database. I have created a job with an Oracle Enterprise stage and have selected the Remote Server variable. Now I need to tell Datastage how to access the data so it will need the server name, port and SID for th...

This is the proccess I am doing: [dsadm@perf-c-01 ~]$ export DSHOME=`cat /.dshome` [dsadm@perf-c-01 ~]$ cd $DSHOME [dsadm@perf-c-01 DSEngine]$ export PATH=$PATH:DSHOME/bin [dsadm@perf-c-01 DSEngine]$ cd ../Projects/PabloDEV1 [dsadm@perf-c-01 PabloDEV1]$ uv -bash: uv: command not found [dsadm@perf-c-...

Found the problem: I could set "Null field value" = "Null" as a global default in the definition file, but it was not picking it up because for some reason ALL of the fields had the "Null field value" set to "" at the row level (i.e. "Edit Row") So N...

Is it possible to define this in the definition file or do I have to just do it in a transformer stage. I noticed there is a option in the definition dialog called "null field value" byt setting this to "Null" does not change anything.

Thanks for your help guys,

I had the administrator run those commands from root, and all seems to work great now.

No, that part was not literal, the same error appeared 100's of times (once for each and every file).

My appologies for that missunderstanding.

cool thanks for that. when I run these commands I come accross some problems: chgrp -R dstage /opt/IBM/Ascential/DataStage/Projects/MyProject chgrp: changing group of `each/and/every/file': Operation not permitted chmod -R g+w /opt/IBM/Ascential/DataStage/Projects/MyProject chmod: changing permissio...

Hi Ray, Thanks for that, can you tell me how to check these settings as I have no idea what you are telling me to do. I would like to check these first then send a request to the server support people to get them to update the umask settings, but first I want to understand what I am to be asking them.

Well done ArndW, I did what you said and it worked when I compiled with same user. You have solved it! However, in saying that, what if I want this particular user to be able to run ANY job from commandline. (this is a scheduler tool). There are a bunch of Datastage developers all with their individ...

I just double checked and yes it is compiled, also job runs with no errors or warnings from Designer/Director.

@ Chulett > Sure it sounds like a valid test. I successfully connected using user credentials after adding the server. However did not solve the problem. I can get jobinfo but not run a job. @ ArndW > Thanks I tried it, but no luck :( [dsadm@perf MyProject]$ $DSHOME/bin/dsjob -run -mode NORMAL "...

It appears that there is no difference to any of these commands when ran with or without the quotes around the project

I have tried a number of variations of that, but no it does not seem to work: [dsadm@perf MyProject]$ /opt/IBM/Ascential/DataStage/DSEngine/bin/dsjob -user dsadm -password mypwd -jobinfo "MyProject" testseq ERROR: Failed to open project Status code = 81011 [dsadm@perf MyProject]$ I'm prett...