DSXchange

Hi, I am new to NLS and am having an issue accessing turkish characters. I am using ISO8859-1 as my project default. The source database is an SQL server from where I take the data transform the same and output it into an Oracle server. When I say view data I get the data from the server, however I ...

Hi Ray,

Thanks for the instant reply on my query.

Do you know of the table in the Universe of where datastage stores information on whether the project is protected or not?

Thanks,
renita

Hi, Is anyone aware of a method to unprotect a project via command line. I believe there should be a mechanism to do so via uvsh or another DS admin command. Additionally this information should be stored in some universe table. Is anyone aware of the same? I need this information to automate a proc...

Hi, I am writing a shell script and within the shell script I needed to stop a job that runs on the background. This has to be done via the shell script. I use the following method. I have a main job and 2 dependant jobs. I stop the 2 dependant jobs first and then this job using the dsjob - stop com...

Hi All,

Any idea how i can go about importing all dsx files in a particular directory on windows.
I do not want to specify name of every dsx file in the directory rather would want to import all i.e. * in that directory?

Thanks,
renita

But the DSParams does not store the job level paramteres. It stores the Project level parameters right?
if i override a parameter value at job level, where would that be stored?

Awaiting responses...
Renita

Hey....
Thanks for the reply....
I agree we could do that....but i am curious to know where do these values reside in the universe.
Anyone familiar with this.

Hi All, Can someone help me as to where the default paramteres fro a job are stored. I am using $PROJDEF for each job. However certain users change the parameters at joblevel. I want to get the list of these jobs and then chnage them from backend. There should be some universe table where these defa...

Hi,
The import is still failing using DSN ODBC!
When i bind the DSN i get error
Package creation failed!: Specified security mechanism, (Unknown), is not supported by server.

Any help on this!

Hi,
The import was failing for job executibles. I excluded it in the import and it ran fine.Later i did a mass compile for all jobs in the system

Thanks! : )

Hi, I am using DataStage 7.5. I am exporting a project from on server to another.For this purpose i exported the project components in chunks i.e each component separately. Now when i try to import into the new project i get a DataStage report repository error : Error calling subroutine: *DataStage*...

Hi, As a part of checking the DSN connectivity, we tried to import table definitions using Designer Right click Table Definition->ODBC->DSN window However the for one of the database it did not list any tables. i got a message saying 'No Match Found!'. The DSN connectivity was done at the same time ...