DSXchange

As mentioned in a previous post, I was missing the usage of $PROJDEF within the jobs.
That fixed everything.

Thanks for your help.
-- john

Changing the variable only did not work.
The only way I could get it to work was to go into the individual job(s) and drop those 2 vrbls, and then add them in again.
This can't be the right way to do it.
-- john

I am using version 7.5.2.
I looked at Manager and could not see how to compile multiple jobs.
-- john herr

I am running 20 jobs against Database1 (with its userID and Password). I want to run those 20 jobs against Database2 (with its different userID and Password). In the Administrator, I defined project variables DB_USR and DB_PSWD, and set them to the values for DB1. I compiled all the jobs, ran them, ...

We have multiple people working on a project -- for the last 2 months All of a sudden, 2 members of the group cannont enter DataStage Designer, with the following msg: ACCESS DENIED: You do not have access to this project. Insure that you are setup as a DataStage user for this project. See your Admi...

My unix script: sqlldr user/pswd@dbase control=<path>myfile.ctl data=<path>mydata.dat I can run this script on unix cmd line and it works fine. The data is loaded into the Oracle table (identified in the .ctl file) Then I use an Execute Command stage, calling this same unix script. In the log "...

We have various users that are logging into the same DataStage project. But a new member of the team's login attempt gives the error: Record 2C605B81-1386-4A9D-9119-DE8021D168FC-TGHSWA003:10125 on file 29 cannot be written. That's pretty criptic. Is this a license issue? We have been told that we ha...

That was it.
I added a commit and it worked.
Thanks
-- john

I created a stored procedure (SP), sp_code.sql as: set serverout on alter session set plsql_warnings='enbale:all'; drop public synonym sp_code; create or replace procedure sp_code as begin delete from my_table; end; / create public synonym sp_code for sp_code; grant execute on sp_code; I DB is Oracl...

When using named user licenses to access Oracle 11i and making a connection to the Open Interface Tables or the Extention/Custom tables from a parallel job on the Data Stage canvas you need to configure the job with user login and database instance. This probabily does not change if you are using pl...

When a team is comprised of 10 or more people, and I need to get into one of my jobs, and someone else is in that job, then I have to call every person to find out who is in my job. Worse yet: Mr X opened my job, then minimized it, then exited DataStage, and then went on vacation for 2 weeks. The jo...

Given a dataset file (xxxxx.ds), which is a pointer to the actual data stored in a Datasets directory. If we have deleted the header file (xxxxx.ds), without using the utility 'orchadmin delete' command, then we end up with orphaned dataset file in the Datasets directory. I understand that there exi...

I cannot find the webmaster's email address.
-- john

I am with Lockheed Martin in Denver and we need to hire some DataStage experience.
I tried to enter a help-wanted entry into 'Looking for Talent' but it said I needed special permission to do that.
So, how do I do that???
-- john

I paid for Premium membership.
I got the Email confirmation
Then I logged out, and logged back in.
And I saw "Order Pending Review"
How long does it take so that I can see the Premium messages?
-- john